TClientDataSet - Lookup with miltiple key field - Thread - go-pugleaf

Thread View: borland.public.cppbuilder.database.multi-tier

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Ben Mon, 12 Nov 2001 05:39

TClientDataSet - Lookup with miltiple key field

#466

Author: Ben
Date: Mon, 12 Nov 2001 05:39

21 lines
1424 bytes

Hi all,

I have a problem with setting up lookup field which requires multiple keys.

I want to use combined key filed to lookup particular data, but I always get
error message said, CDS1 field "Key1;Key2;Key3" is not found.


My set up looks like:

CDS1.LookupKeyFields = "Key1;Key2;Key3";
CDS1.KeyKeyFields = "Key1;Key2;Key3";
CDS1.LookupResultField = Result;
LookupDataSet = CSD2;

CDS2 has filed Key1, Key2 and Key3 as a combined primary key.


Any idea?

Ben

Re: TClientDataSet - Lookup with miltiple key field

#467

Author: Ben
Date: Mon, 12 Nov 2001 07:04

29 lines
1624 bytes

It was caused by other aspect..
I was using 3rdparty grid control, which looks like can not handle this.....

"Ben" <nakagawa@xtra.co.nz> wrote in message news:3bef6109_1@dnews...
> Hi all,
>
> I have a problem with setting up lookup field which requires multiple
keys.
>
> I want to use combined key filed to lookup particular data, but I always
get
> error message said, CDS1 field "Key1;Key2;Key3" is not found.
>
>
> My set up looks like:
>
> CDS1.LookupKeyFields = "Key1;Key2;Key3";
> CDS1.KeyKeyFields = "Key1;Key2;Key3";
> CDS1.LookupResultField = Result;
> LookupDataSet = CSD2;
>
> CDS2 has filed Key1, Key2 and Key3 as a combined primary key.
>
>
> Any idea?
>
> Ben
>
>

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads