Path: utzoo!attcan!uunet!ingr!infonode!tensmekl From: tensmekl@infonode.ingr.com (Kermit Tensmeyer) Newsgroups: comp.databases Subject: Re: differences in concatenation v2.0,v2.3 ORACLE SQL*Forms Message-ID: <1990Sep19.222907.10870@infonode.ingr.com> Date: 19 Sep 90 22:29:07 GMT References: <11299@spool.cs.wisc.edu> Reply-To: tensmekl@infonode.UUCP (Kermit Tensmeyer) Organization: Intergraph Corp. Huntsville, AL Lines: 30 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? Nope, can't doit that way try Select 'molecule.' || &System.Current_Field into :blk.buffer from dual; #copy :blk.buffer GLOBAL.curr_atom; ah from the 'good ole day's Pre V3.0', ya know their discussing the advance features of V4.0 including accessing 'Foreign Datatbases' -- Kermit Tensmeyer | Intergraph Corporation UUCP: ...uunet!ingr!tensmekl | One Madison Industrial Park INTERNET: tensmekl@ingr.com | Mail Stop LR23A2 AT&T: (205)730-8127 | Huntsville, AL 35807-4201