The MS-dBase ODBC driver has an option to show deleted records.
UNcheck that option. You might also want to have an expression index
with a value of DELETED()--not sure about that part.
/<eith
----- Original Message -----
From: "Howie Hamlin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 04, 2000 3:07 PM
Subject: Dbase woes
> I have a site that uses primarily dbase files (don't ask - I have no
control
> over this). Anyway, I found something strange with a query today. I do a
> query on a table that has deleted records and the deleted records show up
in
> the results. I know in Dbase you can check the deleted flag of a record
but
> I ca't see how to filter these out in SQL.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
