Unidac (Interbase) - where :PARAM='' fail

[Petriukx]

Hello again

I have problems with Unidac, Interbase provider when i try to open query on any interbase/firebird database with simple SQL:


select * from RDB$DATABASE
WHERE :DATA = ''


Error: Dynamic SQL Error
SQL error code = -303
arithmetic exception, numeric overflow, or string truncation
string right truncation

All bad things here is from :DATA='' SQL part.
How to solve this problem as soon as posible?

[ViktorV]

Try to set the DescribeParams option to True:

Code: Select all

  UniQuery.SpecificOptions.Values['DescribeParams'] := 'True';

[Petriukx]

Thanks it worked well.

But can you explain a little bit more what this option do and how it effects other situations. Should i set it by default to all project querys or only in few - where problem persists?..

[ViktorV]

You can find the description of this option in our documentation: http://www.devart.com/ibdac/docs/devart ... params.htm. If you have any specific issues after reading the article, please ask them - and we will answer you.