Filling Params with datetime (IB error)

tonymeadors · Post by **tonymeadors** » Wed 28 Sep 2011 14:46

Background:
[i][i]We are moving a suite of tools from D7 to D2010 and changing from dbexpress connections to unidac-based connections.

With the same software we support IB, FB, MSSQL & Oracle.
The bear is dealing with all the datatype oddities.[/i][/i]

Previously, using dbexpress queries we consistently used
params[i].assqltimestamp:= xxxxx;

With tuniquery, the following gives an error with Interbase:

uniquery.sql.add('update ap_master set check_date=:xdatetime');
uniquery.parambyname('xdatetime').assqltimestamp:= datetimetosqltimestamp(now);

interbase yields:
"EConvertError with message Unknown Datatype"
sql server works
oracle works

Looking for similar code to work across db types.

sincerely,
tonyM

AndreyZ · Post by **AndreyZ** » Fri 30 Sep 2011 08:57

Thank you for the information. We have reproduced the problem and the investigation of the problem is in progress. As soon as we solve the problem we will let you know.

AndreyZ · Post by **AndreyZ** » Fri 30 Sep 2011 11:44

We have fixed this problem. This fix will be included in the next UniDAC build.

tonymeadors · Post by **tonymeadors** » Fri 30 Sep 2011 18:07

Thank you for all you do.

tonyM