Chris Seymour
|
Posted: 09/12/2002, 1:20 PM |
|
Hi All,
Is it possible to use SQL such as this in the Listbox Lookup SQL:
select distinct projecttype from projects
I have this in a search grid but I do not get any rows populated.
Thanks.
|
|
|
Shawn Mason
|
Posted: 09/12/2002, 2:51 PM |
|
Yes, but you must either use the Sql box to code it or replace the sql being
generated with code in an event.
--
Kindest Regards,
Shawn Mason,CCD,MCP
I.S. Software Design Associates
"Chris Seymour" <cseymour@seyware.com> wrote in message
news:9287AE903cseymourseywarecom@66.180.229.147...
> Hi All,
> Is it possible to use SQL such as this in the Listbox Lookup SQL:
>
> select distinct projecttype from projects
>
> I have this in a search grid but I do not get any rows populated.
>
> Thanks.
>
|
|
|
guest
|
Posted: 09/12/2002, 7:03 PM |
|
The select statement should look something like this
select distinct projecttype, projecttype from projects
The first field in the select will be passed as selected, the 2nd field will
actually populate the list box.
"Chris Seymour" <cseymour@seyware.com> wrote in message
news:9287AE903cseymourseywarecom@66.180.229.147...
> Hi All,
> Is it possible to use SQL such as this in the Listbox Lookup SQL:
>
> select distinct projecttype from projects
>
> I have this in a search grid but I do not get any rows populated.
>
> Thanks.
>
|
|
|
Chris Seymour
|
Posted: 09/13/2002, 10:03 AM |
|
That's the ticket.
Thanks again.
|
|
|
|