Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Deleting a record in an ADO recordset
Message
From
30/05/2001 17:15:06
Gifford Nicholson
Orion Healthcare Technology
Omaha, Nebraska, United States
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00510535
Message ID:
00512917
Views:
7
This message has been marked as the solution to the initial question of the thread.
If you are using a client side cursor use the "Unique Table" dynamic property. Give this property the name of the table you wish to delete from.

lcSQL1 = "SELECT a.*, b.intdate, b.costcenter FROM followup a, general b where a.genid = b.genid"
oRecSet1=GetRecSet(lcSQL1 )
oRecSet1.properties('unique table') = 'followup'

oRecSet1.MOVEFIRST
P=oRecSet1.FIELDS('GENID').VALUE
oRecSet1.DELETE
oRecSet1.UPDATE

Deletes from the followup table only
Gifford Nicholson
Systems Developer
Orion Healthcare Technology
gifford@accurateassessments.com
Previous
Reply
Map
View

Click here to load this message in the networking platform