RE: [sqr-users] dynamic variable in sqr

["Alexander, Steven" <Steven.Alexander@sanjoseca.gov>]

The compiler is trying to validate your SQL and you've given it nothing.  I
don't know how the rest of the program is going to use database input if you
don't even know the fieldname in advance.  There is syntax for telling the
compiler what table has a layout like $recname and what type of field is
$fieldname.

You could write:

begin-select
[$fieldname] &NAME=char

from
[$recname]
end-select

in other situations you could write:

begin-select
A.NAME

from
[$recname : PEOPLE_TBL] A
end-select

-----Original Message-----
From: sqr-users-bounces+steven.alexander=sanjoseca.gov@sqrug.org
[mailto:sqr-users-bounces+steven.alexander=sanjoseca.gov@sqrug.org] On
Behalf Of Sanjay Sambhe
Sent: Thursday, September 06, 2007 3:20 PM
To: 'This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.'
Subject: [sqr-users] dynamic variable in sqr

Hi ,

I am passing dynamic variable in sqr in begin-select. But I am getting error
like

 Invalid &pseudonym or 'TYPE=' data-type specified for a begin-select
column-variable.  Valid types are:
CHAR, TEXT, DATE, NUMBER

My code is :
begin-select
[$fieldname $s]
        
from
[$recname]
[$wheresqlstr]
end-select
end-procedure

Please advice.

Thanks 
ss


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users