Hi,

I'm trying to use a DBCombobox, but I don't know how to show all records. Only the first record shows.
What I did :
Put an IBConnection on the form. Fill in the details. Put an SQLTransaction on the form.
Put an SQLQuery on the form and fill in the details about the table to use. Put a Datasource on the form.
Put a DBCombobox on the form.
To test I put a DBGrid on the form.
When I activate the SQL, I see some records filling the grid and the first record in the DBCombobox.
When I run the application, I can navigate to all records in the grid and I see the first record in the DBCombobox. But the drop down of the DBCombobox shows nothing so I can't select other records than the first.

I'm using Lazarus 0.9.30.4 with FPC 2.6.0.

What am I missing ?

Regards,

Koenraad Lelong.

No suggestions what I'm doing wrong ?

I enclose a project, using the employee-database.

Regards,

Koenraad Lelong.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: laztest2.7z
Type: application/x-7z-compressed
Size: 60854 bytes
Desc: not available
URL: <http://lists.lazarus.freepascal.org/pipermail/lazarus/attachments/20120618/2f038016/attachment-0001.bin>

Hi,

I forgot to say that scrolling the grid makes the highlighted field of the grid appear in the combobox, but only that field is available, not other fields are visible.

Regards,

Koenraad Lelong.

TDBComboBox is for your own list of values.
Maybe you are looking for TDBLookupComboBox?

Mattias

Apparently the combobox is bound to the CUSTOMER datafield in the datasource => the customer name field in the customers table. If you move down the grid, that is also linked to the datasource, the combobox value changes because the bound field changes. No idea what this dbcombobox is for... but my Delphi experience is near zero and imagination has not yet been too coffee-fuelled yet.

Try seeing if a DBLookupCombobox does what you want: it should let you select a value out of another table and insert that into the field bound to the dblookupcombobox.

I think you have a misunderstanding of what a DBCombobox does. It is a control that lets you edit the current record by entering data directly or by selecting from a pre-defined list. You are looking for a list that is populated from a table. That is TDBLookupComboBox.

Ludo

Reinier Olislagers wrote

Try seeing if a DBLookupCombobox does what you want: it should let you select a value out of another table and insert that into the field bound to the dblookupcombobox.

Hi,

Just tried, it's worse. There absolutely nothing shows. I must be doing something wrong.

I'll switch to Delphi (again, frustrating).

Thanks.

Koenraad.

Explain what you want to do, give a sample of what failed up to now... My crystal ball says you bound the combobox to the field you want to edit but you haven't told the combobox in what other table to look up its data.

... looking at the object inspector when having a dblookupcombobox selected shows listsource and listfield as interesting targets for that.

There is an example of the DBLookupCombobox usage in the lazarus examples\database\dblookup directory.

Ludo