Perfect. Did the trick.
Im always happier after posting a question to here, coz I always get an answer.
Chad.
-----Original Message-----
From: paresh.j.patel@BELLATLANTIC.COM
[mailto:paresh.j.patel@BELLATLANTIC.COM]
Sent: Wednesday, April 12, 2000 2:35 PM
To: SQR-USERS@LIST.IEX.NET
Subject: Re: dynamically assign select variable???
Try this.
let $var = 'field'
begin-select
[$var] &FIELDNAME=char (or whatever fieldtype it is)
from table
end-select
"Slattery, Chad" <Chad.Slattery@CSCLAC.IRLGOV.IE> on 04/12/2000 09:02:25 AM
Please respond to sqr-users@list.iex.net
To: SQR-USERS@list.iex.net
cc: (bcc: PARESH J. PATEL/EMPL/MD/Bell-Atl)
Subject: dynamically assign select variable???
hi all,
does anyone know if you can dynamically assign a select variable, I think I
read somewhere you cant but it would help if you could.
eg. (I know the below doesnt work, but the theory would be the same)
let $var = 'field'
begin-select
$var
from table
end-select
thanks,
Chad.