[yunqa.de] Re: Field can not be dealed as type variant

  • From: Delphi Inspiration <delphi@xxxxxxxx>
  • To: yunqa@xxxxxxxxxxxxx
  • Date: Wed, 24 Aug 2011 13:23:13 +0200

Rather than using TClientDataSet, did you try to use
TDISQLite3UniDirQuery with FastReport directly?

I have attached an example project which I will add to the DISQLite3
demos with the next version. It does handle master-detail, but maybe it
helps nevertheless?

Ralf

On 23.08.2011 12:50, Thompson77 wrote:

> Hi,
>  
> I want to use DISQLite3 with Delphi 7 and FastReport 4 to generate a
> master-detail report.
> For this I have to use 2 TClientDataSets and link them together with
> MasterSource and MasterFields properties set.
>  
> I did the following:
>  
> DISQLite3UniDirQuery1 with "SELECT id,groupname"  (id is INTEGER,
> groupname is TEXT) --> DataSetProvider1 --> ClientDataSet1 -> DataSource1
>  
> DISQLite3UniDirQuery2 with "SELECT rid,groupid,lastname,firstname" 
> (rid and groupid are INTEGER, lastname and firstname are TEXT) -->
> DataSetProvider2 --> ClientDataSet2 -> DataSource2
>  
> Then I set the MasterSource property of ClientDataSet2 to DataSource1.
>  
> When I want to set the MasterFields property with the Field Link
> Designer in Delphi to "groupid=id" I get the error "field 'groupid' can
> not be dealed as type variant".
>  
> Has anyone an idea what I can do to solve this?
>  
> Regards,
>  Thomas

Other related posts: