I am using Visual Fox Pro8 to create my dbf tables.
I have created a connection on the server ODBC and referred to it in Coldfusion. The option for Deleted in the ODBC for VFP is not checked.
When I retrieve the records, all records are return including the deleted ones.
[Todays Threads]
Can someone please help???
I am using Visual Fox Pro8 to create my dbf tables.
I have created a connection on the server ODBC and referred to it in
Coldfusion. The option for Deleted in the ODBC for VFP is not checked.
When I retrieve the records, all records are return including the
Message-
From: John Croney [mailto:[EMAIL PROTECTED]
Sent: Monday, May 17, 2004 2:34 PM
To: CF-Talk
Subject: Re: Deleted records being returned
Can someone please help???
I am using Visual Fox Pro8 to create my dbf tables.
I have created a connection on the server ODBC and referred
In VFP look at the commands
Set deleted() on(to filter deleted records)
PACK(this command will remove the deleted records permanently)
These commands only work within the VFP environment.If you do it via SQL, then
you must copy the records to another table (temp will do) with a Where not
4 matches
Mail list logo