Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem . Upadate cursor with CURSORSETPROP
Message
De
16/02/2006 06:57:59
 
 
À
16/02/2006 05:00:54
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Versions des environnements
Visual FoxPro:
VFP 8
OS:
Windows XP
Network:
Windows XP
Database:
MySQL
Divers
Thread ID:
01096684
Message ID:
01096695
Vues:
11
>HI ALL ,
> When I try to update my cursor : this message appeared : no update tables are specified , use tables property of cursor
>
>what's wrong ?
>here my program
>
>
>
>SQLEXEC(gnConnHandle,'SELECT Posseder_tel.* FROM ;
>     rubrique Rubrique INNER JOIN version Version;
>   ON  Rubrique.rub_code=Version.rub_code ;
>    INNER JOIN posseder_tel Posseder_tel ;
>   ON  Version.ver_code=Posseder_tel.ver_code;
> WHERE Rubrique.rub_code=?Crub_code','telcursor')
>
>
>CURSORSETPROP("Tables","Posseder_tel")
>CURSORSETPROP("KeyFieldList","tel_code")
>CURSORSETPROP("UpdatableFieldList","Tel_code,ver_code,pos_etat","telcursor")
>CURSORSETPROP("UpdateNameList","Tel_code,ver_code,pos_etat","telcursor")
>CURSORSETPROP("SendUpdates",.T.,"telcursor")
>CURSORSETPROP("WhereType",3,"telcursor")
>CURSORSETPROP("BatchUpdateCount",5,"telcursor")
>
>
>THANKS


You didn't set UpdatenameList properly:
** UpdateNameList must be setted as pair of Remote Table Field and Local cursor field (with alias)
CURSORSETPROP("UpdateNameList","Tel_code telcursor.Tel_Code,"+;
                               "ver_code telcursor.ver_code,"+;
                               "pos_etat telcursor.pos_etat","telcursor")
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