Devart Forums

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

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.

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

Thank you for all you do.

tonyM