Listboxes

[Ricalmeida]

Hello,

I would like to have an unbound listbox, showing a certain list of values coming from a SQL query. Until this point I can manage to do. The problem is how can I make it two columns, only one showing and exctract the value on the other colunm in OO Basic?

Thanks for any help.

[DrewJensen]

There is no way to do this directly in the ListBox control that I know of.

The only work around that I have found is to create a macro that is called on the Item Status Changed event for the list box. In this macro you would use a prepared statement to query the database for the record you want, using the selected item's text as the criteria.

If you want an example of exactly how to do this let me know.

Drew

[Ricalmeida]

Thanks for the answer.

I already thought of that, but as I am only starting to learn OO basic, I was trying to avoid that.

If you have already the code written I would be very grateful if you posted it.
In the meanwhile I will try to write it myself.

EDIT: It's done.