Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problems with MySql
Message
De
10/06/2004 17:43:38
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00912372
Message ID:
00912455
Vues:
13
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
Fil
Voir

Click here to load this message in the networking platform