Re: List item' query - Forms 5

From: Pete Kolton <peter.kolton_at_nospambtinternet.com>
Date: Wed, 3 Nov 1999 13:40:34 -0000
Message-ID: <7vpdt4$ib4$1_at_supernews.com>

Try...
sql_stat := 'SELECT rpad(make, 6)||'' ''||model, vin FROM auto';

---

Pete Kolton
ORACLE Systems Consultant
All reasonable offers considered :-)

http://www.kolton.com

---

wozi wrote in message
<49BC5500BD558C51.175C7AA794269B7F.609D6E4F3AE60E1F_at_lp.airnews.net>...
>I am using the following code to populate a list item, but I like the
output
>to be different.
>
>--Build the SQL statement.
>sql_stat := 'SELECT make||'' ''||model, vin FROM auto';
>
> Populate_the_List(list_id, sql_stat);
>
>here is a sample output: here is what I like to see:
>Mazda 929 Mazda 929
>Isuzu Troper Isuzu Tropper
>Ford Escort Ford Escort
>Honda Accord Honda Accord
>
>any help with constructing the query?
>
>
Received on Wed Nov 03 1999 - 14:40:34 CET