From: danhw@aol.com (DanHW)
Subject: Re: Help!...SQL*Forms 4.5
Date: 1998/02/02
Message-ID: <19980202015301.UAA19645@ladder03.news.aol.com>#1/1
References: <6b2fuq$qog$1@us1.rhbnc.ac.uk>
X-Admin: news@aol.com
Organization: AOL http://www.aol.com
Newsgroups: comp.databases.oracle.tools



>I'm trying to use the following code to manipulate row names:
>
>:global.row_select := 'row'||to_char(row_num);
>
>	 select :global.row_select
>         into :global.contents
>         from seat_avail
>	 where flight_id = :global.flight_id;
>	
>The code is not working.  I believe SQL*Forms converts the code into 
>
>e.g. select 'row10'
>     into :global.contents
>     from seat_avail
>     where flight_id = 1234;
>
>What I require it to do is:
>
>select row10
> into :global.contents
>     from seat_avail
>     where flight_id = 1234;  
>
>Is there any way to get my code working?
>(It would be impracticle to write several 'select' routines since
>there are 68 rows in EACH table!)
>
>Many thanks for all your help!
>
>Best Regards
>Dipen
>
>
>
You cannot modify the SQL statement like that. You need to us the dynamic SQL
stuff to do that. Look in the documentation, but I forget which package it is
in....

try something like 
DBMS_SQL.PARSE

Hope that helps
Dan