Devart Forums

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

Hello,
Database Firebird embeded 2.5 . thanks

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

Thanks.problem solved

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