Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Pass Through error when running
Message
 
 
À
09/05/2006 06:41:31
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
OS:
Windows XP
Network:
SAMBA Server
Database:
MySQL
Divers
Thread ID:
01120275
Message ID:
01120400
Vues:
16
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--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform