Re: Help!...SQL*Forms 4.5

>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 Received on Mon Feb 02 1998 - 00:00:00 CET