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'