Re: List Box Values from a Table

populate_list built-in expects a RecordGroup or a Query which gives two char datatype columns. Check the help for "populate_list" built-in.

Prasad.

mark m wrote:
>
> I am trying to populate a list box with values from a table in my
> database. I have tried using the clear_list() and populate_list()
> functions. The first works, but the second doesn't get my list. I can
> pull the list using the SELECT statement in SQL Worksheet that I use
> for my record group. Am I missing something?
>
> Here are the actual statements:
>
> clear_list('beds_view.bed_type');
> populate_list('beds_view.bed_type', create_group_from_query
> ('BED_TYPES', 'SELECT bed_type FROM bedt_view'));
>
> ~~~~
> mark m _at_ team health
> ~~~~
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Mon Jun 07 1999 - 19:45:18 CEST