Help!...SQL*Forms 4.5

[Quoted] [Quoted] 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 Received on Sun Feb 01 1998 - 00:00:00 CET