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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only