Missing fields in Data Tree
Hi,
We are testing FastReport 4.10.16 with Delphi 2009. We connect with Firebird 2.1 database inside the report, when we use a TfrxIBXTable we don????????¬???????t have any problem. But when we use a TfrxIBXQuery we lose all the fields in the Data Tree, after various tests we think this is because the COLLATE of some of the fields.
The table is:
<!--sql--><div class='sqltop'>SQL</div><div class='sqlmain'><!--sql1-->TABLE PRUEBA (
IDPRUEBA ID NOT NULL /* ID <span style='color:orange'>=</span> INTEGER */,
PRUEBA VARCHAR(10) CHARACTER SET ISO8859_1,
PRUEBA2 VARCHAR(10) CHARACTER SET NONE,
PRUEBA3 VARCHAR(10) CHARACTER SET ISO8859_1 COLLATE ES_ES
); <!--sql2--></div><!--sql3-->
In the TfrxIBXQuery we just make a SELECT of the fields of the table PRUEBA. If we select fields IDPRUEBA, PRUEBA and PRUEBA2 in the TfrxIBXQuery everything is ok, but when we include field PRUEBA3 all the fields disappear (like if the SQL was incorrect) and if you run the report you get the error Division by zero, any idea?
We have proved with Firebird 1.5 with the same result.
We also have proved with FastReport 3 and Delphi 7 and everything works ok, maybe a bug in version 4 or are we missing something?
Regards,
Rosa
We are testing FastReport 4.10.16 with Delphi 2009. We connect with Firebird 2.1 database inside the report, when we use a TfrxIBXTable we don????????¬???????t have any problem. But when we use a TfrxIBXQuery we lose all the fields in the Data Tree, after various tests we think this is because the COLLATE of some of the fields.
The table is:
<!--sql--><div class='sqltop'>SQL</div><div class='sqlmain'><!--sql1-->TABLE PRUEBA (
IDPRUEBA ID NOT NULL /* ID <span style='color:orange'>=</span> INTEGER */,
PRUEBA VARCHAR(10) CHARACTER SET ISO8859_1,
PRUEBA2 VARCHAR(10) CHARACTER SET NONE,
PRUEBA3 VARCHAR(10) CHARACTER SET ISO8859_1 COLLATE ES_ES
); <!--sql2--></div><!--sql3-->
In the TfrxIBXQuery we just make a SELECT of the fields of the table PRUEBA. If we select fields IDPRUEBA, PRUEBA and PRUEBA2 in the TfrxIBXQuery everything is ok, but when we include field PRUEBA3 all the fields disappear (like if the SQL was incorrect) and if you run the report you get the error Division by zero, any idea?
We have proved with Firebird 1.5 with the same result.
We also have proved with FastReport 3 and Delphi 7 and everything works ok, maybe a bug in version 4 or are we missing something?
Regards,
Rosa