Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problems with MySql
Message
From
10/06/2004 17:43:38
 
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00912372
Message ID:
00912455
Views:
14
I send the following three commands via sqlexec() in a single string:

DELETE FROM TABLA1 WHERE Codigo = ?x_codigo AND Ames = ?c_ames AND peri = ?p_peri;
DELETE FROM TABLA2 WHERE Codigo = ?x_codigo AND peri = ?p_peri;
DELETE FROM TABLA3 WHERE Codigo = ?x_codigo AND Ames = ?c_ames AND Peri = ?p_peri;

All parameters are previously defined and have the right values

Sqlexec returns -1 and the error array contents are:

1) 1526
2) Connectivity error: [MySQL][ODBC 3.51 Driver][mysqld-5.0.0-alpha-nt]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '; DELETE FROM TABLA2 WHERE Codigo = ' 701"...
3) MySQL][ODBC 3.51 Driver][mysqld-5.0.0-alpha-nt]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '; DELETE FROM TABLA2 WHERE Codigo = ' 7010804-6' AND peri"
4) 37000
5) 1064
6) 1
7) .NULL.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform