TcxDBLookupComboBox how to use it?

Dev Shed Forums Sponsor:

August 1st, 2012, 09:51 AM

zdenekkrejci

Registered User

Join Date: Aug 2012

Posts: 3

Time spent in forums: 22 m 37 sec
Reputation Power: 0

TcxDBLookupComboBox how to use it?

Hi guys I started Delphi not long time ago. Could you please help me with how to use TcxDBLookupComboBox?

I kind of don't understand if it is for two different datasources or just one?

My idea is

Code:

//To show customers name
lookupcombo.databinding.datafield:= 'customer_name';
lookupcombo.databinding.datasource := customersSrc;

and connect different source to join records on a ID field in customersSrc?

lookupcombo.properties.ListColumns... add some columns
lookupcombo.properties.listsource := customersOrdersSrc;
//Lock the customer_id in customerSrc on customer_id in CusomersOrdersSrc
lookupcombo.properties.listFieldIndex:= 'customer_id';

is this the way is suppose to work??

Thank you in advance

August 1st, 2012, 12:25 PM

clivew

Contributing User

Join Date: Jan 2006

Location: Carlsbad, CA

Posts: 2,045

Time spent in forums: 1 Week 6 Days 2 h 37 m
Reputation Power: 382

Yes. Two datasources.
One for the table you are editing and one (listsource) for the table (view, query) that
will populate the drop down list.

August 1st, 2012, 12:58 PM

zdenekkrejci

Registered User

Join Date: Aug 2012

Posts: 3

Time spent in forums: 22 m 37 sec
Reputation Power: 0

Quote:

Originally Posted by clivew

Yes. Two datasources.
One for the table you are editing and one (listsource) for the table (view, query) that
will populate the drop down list.

Thank you very much, and the above is actually not working for me could you give me a hint?
Also just to make sure so the

Code:

lookupcombo.properties.listFieldIndex:= 'customer_id';

is to lock index of the two tables is it?

August 1st, 2012, 03:28 PM

clivew

Contributing User

Join Date: Jan 2006

Location: Carlsbad, CA

Posts: 2,045

Time spent in forums: 1 Week 6 Days 2 h 37 m
Reputation Power: 382

I don't use the DevExpress component myself.
I was just able to answer the first question from generic knowledge of how
DBLookupCombos work.

I do not want to mislead you about specifics.
I would think DevExpress has a forum somewhere where you should get a more authoritative answer.

August 1st, 2012, 03:33 PM

zdenekkrejci

Registered User

Join Date: Aug 2012

Posts: 3

Time spent in forums: 22 m 37 sec
Reputation Power: 0

Quote:

Originally Posted by clivew

OK no prob. thank you anyway...

TcxDBLookupComboBox how to use it?

Developer Shed Advertisers and Affiliates