🚀 go-pugleaf

Jirzi,

Thanks for your reply, but I dont want to perform a Lookup on a Table.

I want to use a TField with with FieldKind = fkLookup.



The code is like this:

ADOTableUren->FieldByName("opdracht")->FieldKind = fkLookup;

ADOTableUren->FieldByName("opdracht")->KeyFields = "klant_id";

ADOTableUren->FieldByName("opdracht")->LookupDataSet = ADOTableOpdracht;

ADOTableUren->FieldByName("opdracht")->LookupKeyFields = "klant_id";

ADOTableUren->FieldByName("opdracht")->LookupResultField = "omschrijving";




this is working, but now I want to use more than one keyfield, that code is
like:

ADOTableUren->FieldByName("opdracht")->KeyFields = "klant_id;volgnr";

ADOTableUren->FieldByName("opdracht")->LookupKeyFields = "klant_id;volg_nr";




This is not working. The following error arises:

ADOTableUren: Field 'klant_id;volgnr' not found.



Erik



"Jirzi" <norc@mailexcite.com> wrote in message news:3bd15add_2@dnews...
> You probaly saw this, but anyway:
>
> int C;
> AnsiString A;
> Variant V;
> V = Table1->Lookup("Company;State", VarArrayOf(OPENARRAY(Variant, ("Blue
> Sports","OR"))),  CustNo;Addr1");
> if !(VarType(V) == varNull)
> {
>   C = V[0];
>   A = V[1];
>   ShowMessage(IntToStr(C) + #10 + A);
> }
> else
>   ShowMessage("Search unsuccessful!");
>
> For KeyFields you should use VarArray.
>
> Maybe this helps.
>
> Jirzi
>
> "Erik" <erik@ietsbinnenaxi.nl> wrote in message news:3bd018eb_1@dnews...
> > I have a problem creating a lookupfield using more than one keyfield.
> (When
> > I use just one keyfield all goes well).
> > According to the C++ help I should set the KeyFields and the
> LookupKeyFields
> > property of my TField and seperate each keyfield name with a semicolon.
> When
> > I do so the following error arises:
> >
> > ADOTabe: Field 'keyfield1;keyfield2' not found.
> >
> > Any ideas?
> >
> > Lots of thanks.
> >
> > Erik.
> >
> >
>
>