Deleted records being returned

2004-05-17 Thread John Croney
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]

Re: Deleted records being returned

2004-05-17 Thread John Croney
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

RE: Deleted records being returned

2004-05-17 Thread Greg Luce
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

Re: Deleted records being returned

2004-05-17 Thread Doug White
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