Wrong SQL view from Firebird

[dikan]

I have report with ODBC connection to Firebird database. When I select records from SQL tool everything is Ok but if I run select from my report or even designer I received same columns but in one of columns is wrong content. It should be null value but there is some trash from database from some other fields. No meter I move order of columns in my query or I rearrange query or even simplify it to only one table with no conditions I just received some other trash in that particular field. That field is 100 varchar.

It looks that record buffer is wrongly handled.

Ok. I can give you a hint. After some heavy thinking we decided to replace varchar definition to char definition and everything works well now. So you got a problem with varchar fields (and we have same problem too).

Regards,
Djole

[Alex K.]

Hello,

Please send us simple report with database for analysis on support@stimulsoft.com.

Thank you.

[dikan]

This is what we already prepared for you, so please check images until we prepare report and database:

Report :

http://img101.imageshack.us/img101/6274/reportz.jpg

query - marked row in column "PREDUZETO" and every other that has number and squares in should be empty (just like empty fields in last column "NAPOMENA"):

http://img43.imageshack.us/img43/4449/viewquery.jpg

same sql query:
http://img52.imageshack.us/img52/6492/sqle.jpg

[Alex K.]

Hello,

Thank you for the detailed explanation of the issue.
We are checking this problem.

Thank you.