Re: List Box Values from a Table
Date: Mon, 07 Jun 1999 17:29:18 GMT
Message-ID: <7jgvh1$t4o$1_at_nnrp1.deja.com>
You have to provide TWO columns in your select statement: First one is for Label, second one is for value. So change your selection as: ...... SELECT bed_type,bed_type FROM bedt_view
Good luck.
HC
In article <7jgp78$ql7$1_at_nnrp1.deja.com>,
mark m <mockm_at_my-deja.com> 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.
>
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Mon Jun 07 1999 - 19:29:18 CEST