Ask a Question related to Coldfusion Database Access, Design and Development.
-
Natesac #1
Accessing Deleted Records in FoxPro with CF
For those of you who know FoxPro, there's an initial column (blank), which if
black, designates that the record has been deleted. Now, the information is
still stored in the table, but the information does not display in typical CF
queries. It's important that these records stay deleted, but I still want to
be able to display the record in its entirety.
Any thoughts?
-Nathan
Natesac Guest
-
Foxpro access in Coldfusion 7
With Coldfusion 5-6.1 we were accessing are old Foxpro 2.6 databases through ODBC using the Visual Foxpro Drivers. There wasn't any major problems.... -
Coldfusion MX & Visual FoxPro
Hi, We have recently upgraded from Coldfusion 4.5 to MX 6.1 and previously had a Dbase5 database that was administered in 4.5 using the link to... -
cf and foxpro stored procedures
I have successfully connected to my colleagues foxpro database via odbc and can query, add and update info. I was hoping he could write into his... -
Trigger & stored procedure to archive deleted records
Hi, I have some tables where users make frequent updates, inserts and deletes. My question is, is it possible using a trigger on "before update"... -
Connecting to Visual Foxpro via ASP
Hello, I need to do some reporting via ASP pages, based on the data stored in our SBT Pro accounting system. SBT is based on Visual Foxpro... -
Sojovi #2 Re: Accessing Deleted Records in FoxPro with CF
You have the deleted() function that returns true or false depending if the
record is marked as deleted. But also depends on the configuration of the ODBC
connection (must be checked the option "Show deleted records")
i.e : SELECT * FROM Table WHERE deleted()
Regards
Sojovi Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
