Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Making a SQL Pass-through updatable.
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00434375
Message ID:
00434380
Vues:
18
? SQLEXEC(1, [SELECT Vdr_No, vdr_add3 FROM VNDR WHERE Vdr_No = 9141], [MyCur])

This opens a local cursor, not an updateable remote view.

? CURSORSETPROP('SendUpdates',.T. ,'mycur')

Contains true (.T.) if a SQL update query is sent to update tables when an update is made using the view <-----

? CURSORSETPROP('Tables', 'KPOPS.VNDR')
? CURSORSETPROP('UpdateNameList','vdr_add3', 'MyCur')
? CURSORSETPROP('KeyFieldList','vdr_no', 'MyCur')
? CURSORSETPROP('UpdatableFieldList', 'vdr_add3, vdr_add3', 'MyCur')

The rest of these, I believe, only apply to a view.
Eric Kleeman - EDS Consulting Services
MCP Visual FoxPro
MCSD C#.NET
Hua Hin Thailand
Los Angeles California
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform