Delphi7 - Populating List Box From DB

Endurance Man · 2008-02-20 09:54:18

I have a DBLookUpListBox which i want to populate with data from a field in a database. The field is in the 'Event' Table, field name is 'EventType'. Under the ListBox propertys i have set my dataSource to the query and then set the DataField to EventType. How do i get the list box to populate now? I would have thought…

20-02-2008 09:54AM

#1

Endurance Man

Closed Accounts Posts: 5,240 ✭✭✭

Join Date: June 2005

Posts: 4887

I have a DBLookUpListBox which i want to populate with data from a field in a database. The field is in the 'Event' Table, field name is 'EventType'.

Under the ListBox propertys i have set my dataSource to the query and then set the DataField to EventType. How do i get the list box to populate now? I would have thought once those two propertys are set it would populate automatically. Guessing im missing some line : LookUpBox.populate or something?
Am new to delphi so any help would be appreciated :].

Endo

0

Comments

#2 20-02-2008 10:44AM

dazberry

Registered Users, Registered Users 2 Posts: 2,159 ✭✭✭

Join Date: October 2001

Posts: 2051

You also need to set the ListSource property to point to your "lookup" datasource, and set the KeyField and ListField properties as appropriate.

D.

0
#3 20-02-2008 11:02AM

Endurance Man

Closed Accounts Posts: 5,240 ✭✭✭

Join Date: June 2005

Posts: 4887

Thanks dazberry, that worked.

0