Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Issues creating an updatable cursor at runtime.
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
Database:
MS SQL Server
Miscellaneous
Thread ID:
00998849
Message ID:
00998851
Views:
32
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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform