Re: Pass back values from a SQL statement

[Denise Goin <Denise_Goin@PARAMOUNT.COM>]

I have tried different variations of the begin-select, and as long as the
[$fieldname] is in there it errors-

Error on line 122:
   (SQR 3743) Dynamic columns must have a &pseudonym.
[$field]

Error on line 129:
   (SQR 4702) Line found outside paragraph.
end-procedure GET-VALUES


This might just be a SYBASE  problem, the previous suggestion from David-
begin-sql
select [$fieldname] as fieldone
INTO $somefieldtostorevalues
FROM [$FROM]
where [$WHERE]
end-sql
doesn't work in SYBASE either.

I am looking into doing -

begin-sql On-Error=VALUE-ERROR
insert into PS_Z_AUDIT_TEMP
select [$fieldname]

FROM [$FROM]
where [$WHERE]

end-sql

begin-select
AUDITFIELD

  let $AUDIT_FIELD = &AUDITFIELD
  show $FIELDNAME '|' $AUDIT_FIELD '|'

from PS_Z_AUDIT_TEMP
end-select