Devart Forums

Hello,
I'm migrating my server applications from DBExpress to UniDac an I've a problem using TUniQuery with a timestamp parameter.

I can set the timestamp parameter with correct date and time (as well formated SqlTimSt.StrToSQLTimeStamp).
But as soon as open a TClientDataSet (cds that is connected in TDataSetProvider, and Provider is connected in TUniQuery) I get an error: "cannot convert type".

The same test using Firebird DB is sucessefully.
And more, this case using DbExpress + "dbExpress driver for Oracle" (DBXOda) also works.

I am doing something wrong?
Thanks.

Please, specify the DBMS and the field data type in the DB table where the specified error occurs.

At two cases:
UniDac + Oracle 11g Express (11.2) + "DATE" Field in DB;
UniDac + Oracle 11g Express (11.2) + "TIMESTAMP(6)" Field in DB;

We checked UniDAC behavior when working with SQLTimeStamp parameter type using Oracle 11 XE. Unfortunately, we could not reproduce the described problem. Please compose and send us a small sample in which the problem occurs using the e-support form ( https://www.devart.com menu "Support"\"Request Support" ).