SQLERROR -804 Data Type unknown

[Suhaimin]

Hello,
var
intvalue : integer;

Uniquery.close;
Uniquery.sql.clear;
Uniquery.sql.add('SELECT NOMOR, (TOTAL - :p0) as Subtot from Test')
uniquery.parambyname('p0').asinteger := intvalue;
uniquery.open;

after open Error message occurs. "SQL Error Code = -804 data type unknown". whats wrong in my code ?thanks

[Suhaimin]

Hello,
Database Firebird embeded 2.5 . thanks

[ViktorV]

To solve the problem, try in your code to change the SQL query assigning string of the TUniQuery component with the following:

Code: Select all

  Uniquery.sql.add('SELECT NOMOR, (TOTAL - CAST(:p0 as INT)) as Subtot from Test');

[Suhaimin]

Thanks.problem solved

[ViktorV]

Glad to see that the issue was resolved. Feel free to contact us if you have any further questions about UniDAC.