Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Keith Patterson
  Where is Keith Patterson?
 Roanoke
 Virginia - United States
 Keith Patterson
 To: Cetin Basoz
  Where is Cetin Basoz?
 Izmir
 Turkey
 Cetin Basoz
 Tags
Subject: RE: OLEDB connection and deleted records
Thread ID: 227333 Message ID: 228554 # Views: 1 # Ratings: 0
Version: Visual FoxPro 6 Category: ODBC, ADO and OLEDB
Date: Tuesday, May 19, 2009 9:28:19 PM         
   


> > I need to be able to see deleted records thru an OLEDB connection.
> >
> > My connection string is
> >
> > Provider=vfpoledb.1;Data Source=c:\data;Collating Sequence=machine;Exclusive=false;Nulls=false;
> >
> > I tried adding Deleted=true/false/yes/no (since this works on the ODBC connection), but this had no effect.
> >
> > I've tried adding "AND DELETED()" to the query, no effect.
> >
> > What do I have to do to be able to see records that have been deleted?
> >
> > Keith
>
> First send 'set deleted off' as a command to your connection.
>
> Cetin Basoz
>
> .Net has got better.Think about moving - check my blog:
> Blog (main)
> Blog (mirror)

Izmir,

Thank you for the reply and sorry for the delay in getting back to you.

Business requirements dictated that the user did not need to see the deleted records after all.

I'll store this for future use, tho.

Keith

ENTIRE THREAD

OLEDB connection and deleted records Posted by Keith Patterson @ 5/8/2009 1:56:59 PM
RE: OLEDB connection and deleted records Posted by Cetin Basoz @ 5/8/2009 2:18:38 PM
RE: OLEDB connection and deleted records Posted by Keith Patterson @ 5/19/2009 9:28:19 PM