Querying foxpro database for deleted records

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Less Confused - 31 Jul 2003 17:24 GMT

Thanks Graham for your response. This is my connection
string is the Deleted=No the attribute you were talking
about?

Driver={Microsoft Visual FoxPro
Driver};Provider=MSDASQL.1;UID=;PWD=;SourceDB=C:\IMS_Data;
SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Collate=Ma
chine;Null=Yes;Deleted=No;

Reply to this Message

Graham Dobson - 31 Jul 2003 18:16 GMT

I would think so, and if you want to see the deleted records, I would set
Deleted=True, which would seem more reasonable than the strange logic of SET
DELETED. If that fails I know that with SQL Server you can set the various
SET options at the top of your SQL query, not sure if SET DELETED OFF would
work with your ODBC provider in this manner but that could be worth a try
too. And if all else fails I'm sure this setting would also be exposed
through the Properties collection of the recordset or connection. Perhaps
it would be something like rs.Properties("Deleted") = TRUE, which could be
set before opening the recordset. Good Luck. -- Graham

> Thanks Graham for your response. This is my connection
> string is the Deleted=No the attribute you were talking
[quoted text clipped - 4 lines]
> SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Collate=Ma
> chine;Null=Yes;Deleted=No;

Reply to this Message

VB Forum / Database Access / July 2003

Querying foxpro database for deleted records