Home -> Usenet -> comp.databases.oracle -> SQL*Forms 3.0 LOV, controlling the width...

SQL*Forms 3.0 LOV, controlling the width...

From: George chow <george_at_unixg.ubc.ca>
Date: Tue, 21 Jul 1992 21:33:06 GMT
Message-ID: <1992Jul21.213306.8315_at_unixg.ubc.ca> 






I'm building a form with SQL*Forms 3.0 with a few LOV. Anyways, the columns 
in my tables are quite wide (just in case I need it in the future). For each 
LOV, I want to SELECT about 3-4 columns. The situation right now is that 
Forms will allocate space for each column in the LOV according to the declared 
width of the column from the table. Because my tables tend to have wide
columns, I can't see more than about 2.5-3 table columns in the LOV.
What I would prefer to do is to split the 80 columns among all four columns
from the tables. How can I control the width of the what SELECT returns? 
I don't think there is any way via (standard) SQL. But is there some way in 
Forms to do what I want?



George
Received on Tue Jul 21 1992 - 23:33:06 CEST












Original text of this message