Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Update tables with sqlexec
Message
De
15/02/2006 05:53:04
 
 
À
15/02/2006 05:29:22
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:
Windows XP
Database:
MySQL
Divers
Thread ID:
01096425
Message ID:
01096428
Vues:
13
Check How to make SQL Pass-Through cursor updatable FAQ #8153

>HI all ,
>
>I use sqlexec like this :
>
>
>               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')
>
>
> after modify records like this
>
>
>
>      INSERT INTO telcursor(tel_code,ver_code,pos_etat) VALUES (thisform.text1.value,;           Codecursor.ver_code,thisform.text2.Value)
>
>
>
>How can I update tables
>
>Thanks
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
Répondre
Fil
Voir

Click here to load this message in the networking platform