Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Deleting a record in an ADO recordset
Message
De
30/05/2001 17:15:06
Gifford Nicholson
Orion Healthcare Technology
Omaha, Nebraska, États-Unis
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00510535
Message ID:
00512917
Vues:
8
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform