[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
RE: [sqr-users] dynamic variable in sqr
- Subject: RE: [sqr-users] dynamic variable in sqr
- From: Sanjay Sambhe <ssambhe@cisco.com>
- Date: Mon, 10 Sep 2007 14:32:58 +0530
- Authentication-results: sj-dkim-2; header.From=ssambhe@cisco.com; dkim=pass (sig from cisco.com/sjdkim2002 verified; );
- Delivery-date: Mon, 10 Sep 2007 05:08:47 -0400
- Dkim-signature: v=0.5; a=rsa-sha256; q=dns/txt; l=1983; t=1189415085;x=1190279085; c=relaxed/simple; s=sjdkim2002;h=Content-Type:From:Subject:Content-Transfer-Encoding:MIME-Version;d=cisco.com; i=ssambhe@cisco.com;z=From:=20Sanjay=20Sambhe=20<ssambhe@cisco.com>|Subject:=20RE=3A=20[sqr-users]=20dynamic=20variable=20in=20sqr|Sender:=20; bh=ftaBrN2vJQZYN/W1vL6vZbXqSJvkIMiMx4ql3brvvMA=;b=YkfuZ4hYRDIj9pIETIAgl4qR4+HpK9CcyxKIveNENfp46g6kgZAdMeMB8BTNE7A3bEYaPhoAWCGfTwRsRTUN7E/bzmhGXa3qMishboUKVlgJlvPSkfRwgv+UmE9cvFWW;
- In-reply-to: <02839363BA87B447B34ECE391D0DC654782189@ex01.sjcity.net>
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
- Thread-index: Acfw44fNHAtSjzqfRsetUnVlAU7GTQCpdAbw
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