[sqr-users] RE: sqr-users Digest, Vol 43, Issue 6

["Stevenson, Christine" <Christine_Stevenson@bausch.com>]

-----Original Message-----
From: sqr-users-request@sqrug.org [mailto:sqr-users-request@sqrug.org] 
Sent: Monday, September 10, 2007 6:03 AM
To: sqr-users@sqrug.org
Subject: sqr-users Digest, Vol 43, Issue 6


Send sqr-users mailing list submissions to
        sqr-users@sqrug.org

To subscribe or unsubscribe via the World Wide Web, visit
        http://www.sqrug.org/mailman/listinfo/sqr-users
or, via email, send a message with subject or body 'help' to
        sqr-users-request@sqrug.org

You can reach the person managing the list at
        sqr-users-owner@sqrug.org

When replying, please edit your Subject line so it is more specific than
"Re: Contents of sqr-users digest..."


Today's Topics:

   1. RE: dynamic variable in sqr (Sanjay Sambhe)


----------------------------------------------------------------------

Message: 1
Date: Mon, 10 Sep 2007 14:32:58 +0530
From: Sanjay Sambhe <ssambhe@cisco.com>
Subject: RE: [sqr-users] dynamic variable in sqr
To: "'This list is for discussion about the SQR database reporting
        language        from Hyperion Solutions.'" <sqr-users@sqrug.org>
Message-ID: <5833.74221189415080.pent.cisco.com@MHS>
Content-Type: text/plain;       charset="us-ascii"

Thanks Steven,

It is  resolved...

ss 

-----Original Message-----
From: sqr-users-bounces+ssambhe=cisco.com@sqrug.org
[mailto:sqr-users-bounces+ssambhe=cisco.com@sqrug.org] On Behalf Of
Alexander, Steven
Sent: Friday, September 07, 2007 5:40 AM
To: 'This list is for discussion about the SQR database reportinglanguage
from Hyperion Solutions.'
Subject: RE: [sqr-users] dynamic variable in sqr

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



------------------------------

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


End of sqr-users Digest, Vol 43, Issue 6
****************************************




EMAIL DISCLAIMER 

Please Note: The information contained in this message may be  privileged and 
confidential, protected from disclosure, and/or intended only for the use of
the individual or entity named above. If the reader of this message is not
the intended recipient, or an employee or agent responsible for delivering
this message to the intended recipient, you are hereby notified that any
disclosure, distribution, copying or other dissemination of this
communication is strictly prohibited. If you received this communication in
error, please immediately reply to the sender, delete the message and 
destroy all copies of it.

Thank You


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