[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
[sqr-users] dynamic variable in sqr
- Subject: [sqr-users] dynamic variable in sqr
- From: Sanjay Sambhe <ssambhe@cisco.com>
- Date: Fri, 7 Sep 2007 03:50:22 +0530
- Authentication-results: sj-dkim-4; header.From=ssambhe@cisco.com; dkim=pass (sig from cisco.com/sjdkim4002 verified; );
- Delivery-date: Thu, 06 Sep 2007 18:25:00 -0400
- Dkim-signature: v=0.5; a=rsa-sha256; q=dns/txt; l=371; t=1189117322;x=1189981322; c=relaxed/simple; s=sjdkim4002;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:=20dynamic=20variable=20in=20sqr |Sender:=20;bh=A4OSPF8lRl1rrSxNiaJ8qLMrhwtb1zAYT7Zo0d8axeo=;b=a00wLv4CI5GNoDqooSLu/L65/0qpkNH2hiezwfauODPpjS4RhU51WHVHSEEd+0+wGw460a8z+1xzkDrtwdUE7E8+eT0+rs7XKA+KMYspS2YgB8X0XsncrBXOrNiAO/7N;
- In-reply-to: <825F292D00AA964EBD7A4CB6BC4FC045931EAE@pwn434e2040.ent.corp.bcbsm.com>
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
- Thread-index: AcfvM5NisOOOqknBRoGFtzWzb8tpMwBoEjzw
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