Path: utzoo!attcan!uunet!tut.cis.ohio-state.edu!usenet.ins.cwru.edu!eagle!news
From: tprife@venus.lerc.nasa.gov (Mike Rife (Boeing))
Newsgroups: comp.databases
Subject: Re: differences in concatenation v2.0,v2.3 ORACLE SQL*Forms
Message-ID: <1990Sep19.045514.26484@eagle.lerc.nasa.gov>
Date: 19 Sep 90 04:55:14 GMT
References: <11299@spool.cs.wisc.edu>
Reply-To: tprife@venus.lerc.nasa.gov
Organization: Space Station Freedom Project, NASA Lewis Research Center
Lines: 28
News-Software: VAX/VMS VNEWS 1.3-4

In article <11299@spool.cs.wisc.edu>, beverly@ai.cs.wisc.edu (Beverly Seavey (-Kung)) writes...
>The following statement works for me just hunky-dory in SQL*Forms 2.3:
> 
>  #COPY 'molecule.'||&SYSTEM.CURRENT_FIELD GLOBAL.curr_atom;
> 
>When I use the same line in v2.0, I get the msg:
> 
>  IAXCPY: Not enough arguments.
> 
>Adding or removing blanks between tokens doesn't seem to change the situation.
>I seem to remember reading somewhere that concatenation like that takes an
>extra step in version 2.0. Does anyone remember?


In v2.0 I believe that you can not do concatenation in the middle of the #COPY
macro.  Concatenation within macros was added with v2.3.  What you need to do
is:

1:	#Copy &SYSTEM.CURRENT_FIELD :CONTROL.TEMP;
2:	select 'molecule.'||:CONTROL.TEMP
	into :CONTROL.TEMP
	from system.dual
3:	#Copy :CONTROL.TEMP GLOBAL.curr_atom;

NOTE:	TEMP is a temporary, non-database field on page 0 of the CONTROL 
	block.  The names do not matter.  Just copy CURRENT_FIELD inot a
	temporary field on page 0 and then concatenate with a SQL step and 
	COPY the value inot the global variable.