Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Pass Through error when running
Message
 
 
To
09/05/2006 06:41:31
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8
OS:
Windows XP
Network:
SAMBA Server
Database:
MySQL
Miscellaneous
Thread ID:
01120275
Message ID:
01120400
Views:
20
Try
...
CURSORSETPROP("UpdateNameList","tel_code posseder_tel.Tel_Code,"+;
                               "ver_code posseder_tel.ver_code,"+;
                               "pos_etat posseder_tel.pos_etat","telcursor") 
CURSORSETPROP("KeyFieldList","tel_code,ver_code")
CURSORSETPROP("UpdatableFieldList","Tel_code,ver_code,pos_etat","telcursor") 
...
>this message appears 'invalid update column name "tel_code" on CURSORSETPROP("KeyFieldList","tel_code,ver_code")
>
>
>
>LcSQL="SELECT posseder_tel.tel_code,posseder_tel.pos_etat,posseder_tel.ver_code FROM "+;
>   "posseder_tel posseder_tel "+;
>   " INNER JOIN telephone telephone "+;
>   "ON  posseder_tel.tel_code = telephone.tel_code "+;
>   " INNER JOIN version Version "+;
>   "ON  posseder_tel.ver_code = version.ver_code"
>
>SQLEXEC(gnConnHandle,LcSQL,'telcursor')
>
>CURSORSETPROP("Tables","posseder_tel")
>CURSORSETPROP("KeyFieldList","tel_code,ver_code")
>CURSORSETPROP("UpdatableFieldList","Tel_code,ver_code,pos_etat","telcursor")
>CURSORSETPROP("UpdateNameList","Tel_code posseder_tel.Tel_Code,"+;
>                               "ver_code posseder_tel.ver_code,"+;
>                               "pos_etat posseder_tel.pos_etat","telcursor")
>CURSORSETPROP("SendUpdates",.T.,"telcursor")
>CURSORSETPROP("WhereType",3,"telcursor")
>CURSORSETPROP("BatchUpdateCount",5,"telcursor")
>CURSORSETPROP("Buffering",5,"telcursor")
>
>
>Help please
>Best regards
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform