Problem with ODBC tables in FR 2.5

peteoshea

I am trying to set up a simple report using an ODBC connection to get the data. I have done the exact same thing using paradox tables many times so I know it should work.

I have set up a simple TfrBDEQuery and then created two TfrBDETables, the first with the master source pointed at the query and the other pointing at the first:

Query1 <- Table1 <- Table2

The table names are in the form: "LINK:public.TABLE".

Now when I click on Master Fields I see items in both the Detail Fields and the Master Fields columns. I can then join the appropriate id fields in both table1 and table2.

If I then save the report, the next time I open it in design time when I select table1 and click on Master Fields I get a message:

table1: Field index out of range

and then the Detail Fields, Master Fields and Joined Fields are all empty.

If I then click on table2's Master Fields I get a different message:

List index out of bounds (0)

If I go in and out of the tables Master Fields option then the messages seem to appear at random, sometimes one of them seems to work but I cannot seem to get both working at the same time without removing them and recreateing each time I want to change the report.

Any ideas?
TIA
Pete

gordk

Pete if your talking about designtime under ide make sure datamodule has been viewed once before trying to do anything else.