Problem connecting to Firebird through SQL

Petter S.

Hi all.

I'm new to Fast Reports (been using Rave for some years).

We have our data in Firebird databases. In most reports we use data from 2 databases. I am having this problem:

In a new report I drop 2 items of TfrxIBXDatabase, named IBXDatabase1 and IBXDatabase2. I connect both of them to the same databasefile (normally the connect to different files, but here i simplify just for testing).

Then I drop 2 items of TfrxIBXTable, named IBXTable1 and IBXTable2.
IBXTable1 is connected to the table 'client' in IBXDatabase1, and IBXTable2 is connected to the table 'client' in IBXDatabase2.
Both of them are now showing their fields in the Data Tree.

So far everything is OK.

Then I drop 2 items of TfrxIBXQuery, named IBXQuery1 and IBXQuery2.
IBXQuery1 is connected to IBXDatabase1, and IBXQuery2 is connected to IBXDatabase2.
Both of them get the same SQL: 'select * from client'.

Now the problem is:
IBXQuery1 is showing its fields in the DataTree.
IBXQuery2 is not.

(The TfrxIBXTable-components have nothing to do with the problem as far as I can see, I just added them to check that the database-components connected as expected)

Now I'm stuck. What am I missing here?

Thanks for any response.