Devart Forums

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?

Try to set the DescribeParams option to True:

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?..

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.