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.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement