NetNews Usenet Archive 1992 #16/NN_1992_16.iso/spool/comp/database/oracle/1089

Text File | 1992-07-21 | 1.3 KB | 27 lines

Newsgroups: comp.databases.oracle
Path: sparky!uunet!sun-barr!cs.utexas.edu!qt.cs.utexas.edu!yale.edu!yale!gumby!destroyer!ubc-cs!unixg.ubc.ca!unixg.ubc.ca!george
From: [e-mail] (George chow)
Subject: SQL*Forms 3.0 LOV, controlling the width...
Message-ID: <[e-mail]>
Followup-To: comp.databases.oracle
Originator: [e-mail]
Sender: [e-mail] (Usenet News Maintenance)
Nntp-Posting-Host: unixg.ubc.ca
Organization: University of British Columbia, Vancouver, B.C., Canada
Date: Tue, 21 Jul 1992 21:33:06 GMT
Lines: 13

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