Devart Forums

Hi, i get a SQL Error Code -804 Datatype Unknown when i try to open a TIBCQuery that is linked to another TIBCQuery with a Datasource and the MasterFields properties set.

I am using IBDac v5.2.6 with Delphi 7.

Regards

Stefanos Charalampous

TwinSoft

Unfortunately, we can not reproduce the problem.
Please create a small sample that demonstrates the problem, including a script to create the test database, and send it to eugeniyz*devart*com.

I have backported IBDac to 5.1.4 in order to have a working version. The steps i did to reproduce the problem in 5.2.6 are:

1) Put a IBCConection and a IBCTransaction and connect to your DB
2) Put a TIBCQuery and set the SQL to select * from TableA
3) Put a second TIBCQuery and set the SQL to select * from TableB
4) Put a TDatasource and set it to the first TIBCQuery
5) Set the MasterSource property on the second TIBCQuery to the TDatasource
6) Set the MasterFields property and select the joining fields
7) Try to open the second TIBCQuery by setting the Active property

The joining fields are integer fields (primary key and foreign key) and i am using FB 2.1.5

This produces the error.

Regards,

Stefanos

TwinSoft

Thank you for the information.
We have reproduced the issue and fixed it. The error is specific to the Firebird version 2.1 and lower. We will include the fix in the next IBDAC release.