I am having the exact same problem -

in PB 11.5 Database painter ISQL Session.

It won't spit out a variable value. Only a SQL result set.

But I am connected to Oracle 10g - looks like your using SQL Server yes ?



I will research further to see why the error.

And let you know what I find.



Thks

 

Steve Adams
(916) 316 3737

----- Original Message -----
From: "Visweswaran suBRAMANyam" <vas2862@...>
To: PowerObject@yahoogroups.com
Sent: Friday, July 3, 2009 10:31:23 AM GMT -08:00 US/Canada Pacific
Subject: [PowerObject] Can I declare variables on ISQL editor in PB?!








Good morning/evening!

I wanted to declare a memory vaiable and store value in it from PB's DB editor's
ISQL Session Tab by the following script.

declare @msg_id varchar;
go
select @msg_id = 'aaaa';

but an error is thrown saying Must declare variable '@msg_id '

Assistance please....

Thanks a lot, in advance!
VISVESH




[Non-text portions of this message have been removed]