Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update tables with sqlexec
Message
From
15/02/2006 05:53:04
 
 
To
15/02/2006 05:29:22
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8
OS:
Windows XP
Network:
Windows XP
Database:
MySQL
Miscellaneous
Thread ID:
01096425
Message ID:
01096428
Views:
14
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.
Previous
Reply
Map
View

Click here to load this message in the networking platform