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.
"Cannot convert type" with TimeStamp Parameter
-
- Posts: 4
- Joined: Mon 27 Mar 2017 13:07
Re: "Cannot convert type" with TimeStamp Parameter
Please, specify the DBMS and the field data type in the DB table where the specified error occurs.
-
- Posts: 4
- Joined: Mon 27 Mar 2017 13:07
Re: "Cannot convert type" with TimeStamp Parameter
At two cases:
UniDac + Oracle 11g Express (11.2) + "DATE" Field in DB;
UniDac + Oracle 11g Express (11.2) + "TIMESTAMP(6)" Field in DB;
UniDac + Oracle 11g Express (11.2) + "DATE" Field in DB;
UniDac + Oracle 11g Express (11.2) + "TIMESTAMP(6)" Field in DB;
Re: "Cannot convert type" with TimeStamp Parameter
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" ).