Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Issues creating an updatable cursor at runtime.
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 8 SP1
Database:
MS SQL Server
Divers
Thread ID:
00998849
Message ID:
00998851
Vues:
33
Here the code I used to do the same:
csql = SQLEXEC(sqlh, "SELECT * FROM Staff_New WHERE OutNom = ?mid","cStaff")

SELECT cStaff
CursorSetProp('KeyFieldList','OutNom'   ,'cStaff')
CursorSetProp('WhereType'   ,          2,'cStaff')
CursorSetProp('Tables'      ,'Staff_New','cStaff')
CursorSetProp("UpdateNameList", ;
              "OutNom    Staff_New.OutNom,"+;
              "Ime       Staff_New.Ime,"+;
              "Dlj       Staff_New.Dlj,"+;
              "Egn       Staff_New.Egn,"+;
              "Zweno     Staff_New.Zweno","cStaff")
CursorSetProp('UpdatableFieldList','OutNom,Ime,Photo,Dlj,Egn,Zweno','cStaff')
CursorSetProp('SendUpdates',.T.,'cStaff')
CursorSetProp('Buffering',    5,'cStaff')
I deleted the Check for successful SQLEXEC from this example.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform