i tried these to insert to a firebird database.. (connection was established successfully, and insert is successful except when i'm inserting a date value. The date format
for date seems to be incorrect):
?sqlexec(nHandle, "insert into table1 (reference, date) values;
('23422','2005/01/01')")
* returns -1
?sqlexec(nHandle, "insert into table1 (reference, date) values;
('23422','01/01/2005')")
* returns -1
?sqlexec(nHandle, "insert into table1 (reference, date) values;
('23422','2005-01-01')")
* returns -1
?sqlexec(nHandle, "insert into table1 (reference, date) values;
('23422','2005-01-01')")
* returns -1
?sqlexec(nHandle, "insert into table1 (reference, date) values;
('23422',{2005-01-01})")
* returns -1
?sqlexec(nHandle, "insert into table1 (reference, date) values;
('23422',{01/01/2005})")
* returns -1
...and almost all possible ways of defining date such as {2005/01/01}
{1.1.2005} {^2005/01/01} '^2005/01/01'
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