SQL*Forms 3.0 and Referencing

I have a SQL*Forms v3.0 PL/SQL procedure that just doesn't seem to work.

In a one procedure I assign two temp fields to 'A.MONDN' & 'A.MONUP' and try to reference them in a PL/SQL procedure.

	procedure one is
	begin


	  .blah..blah..


	    :block.temp_field1 := 'A.MONDN' ;
	    :block.temp_field2 := 'A.MONUP' ;
	end ; /*proc one*/

	procedure two is
	begin


	  .blah..blah..


	  declare
	    cursor tmp_cur ;
	      SELECT name_in(:block.temp_field1), name_in(:block.temp_field2)
		FROM table_name a
	       WHERE ...stuff... ;
	  begin
	    open ...
	    fetch ...
	  end ;
	end ;

Procedure TWO uses the alias 'A' ... is this the problem? Since this proc will be used for more than one day (7 day week) I would like to pass the day of the week (concatenated if I have to MON||DN, MON||UP, TUE||DN, etc.).

If you have any ideas let me know.

-Mike Received on Tue Nov 16 1993 - 00:11:04 CET