Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Sqlexec to try insert record on mysql database
Message
 
 
À
19/07/2005 21:45:31
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP1
Database:
MySQL
Divers
Thread ID:
01034083
Message ID:
01034086
Vues:
24
This message has been marked as a message which has helped to the initial question of the thread.
>The following statement is issued to insert a record on mysql database. If issue it on command window of VFP the record is inserted, but if issue it inside method of form the record is not inserted and retval returns -1.
>
>retval = SQLEXEC(lnHandle,'INSERT INTO fcdl.fatura (codigo, referencia) VALUES (' + m.codigo + "," + m.dtinvertida + ')')
>
>What is wrong?

You tell us. Use AERROR() to get ODBC error info.
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform