Master Detail and ADOQuery

tchant

Hi All,

I'm using FastREports Ver 5.1.1 , simle problem but I can't see what the problem is , In essense I have two tables

"Select * from t_asset_serv_hdr" Query for Master Table

" Select * from t_aset_serv_dtl WHERE RecID = :RecID" Query for second table with one parameter

I set the ADOQuery Master Table to the 1st Query

I then set The Parameter Editor to <DBFaultHdr."RecID"> for the parameter "RecID" with an Integer as the type

Drop a Master Data Band and set - run the report and I get all the master data

The I drop a Detail Band on the report set the DataSet and run -

The report shows nothing - I can do the same using ADOTables and it works perfectly - Any ideas why or am I missing something really simple ?


Any Help appreciated

Kind regards

Trevor

gpi

Use
"Select * from t_asset_serv_hdr" Query for Master Query

"Select * from t_aset_serv_dtl WHERE RecID = :RecID" for Detail Query

Set the ADOQuery2.Master = ADOQuery1

Wolfgang Reuter

gpi wrote: »

Use
"Select * from t_asset_serv_hdr" Query for Master Query

"Select * from t_aset_serv_dtl WHERE RecID = :RecID" for Detail Query

Set the ADOQuery2.Master = ADOQuery1

I have also Problems with Parameter.

All works fine in the case the Parameter are integer or string, but with uniqueidentifier it doesn't work?

gpi

Don't set parameter properties, just set SQL query text