Hi,

I am using Rapid SQL 7.2.1 on Windows XP to access Sybase 12.5.0.1
using Transact SQL.

When I declare a number of variables in Transact SQL and then give the
variables a value using the select statement and run it, I get the "1
row(s) affected." message for each variable I set a value for. How
can I stop SQL/Rapid from outputting this message while still allowing
the actual select query statmennts to return values.

Here is an example of how I am declaring and setting values:

create table #report
(id int, report char(20))
insert into #report (id,report) values (3, "Report name")

declare @repid int
select @repid = (select dbo.rep.id from dbo.rep where
dbo.rep.report_name in
(select report from #report where id =3))

declare @runfilter1 int
select @runfilter1 = (select run_filter_1 from dbo.rep_run where id =
@repid)

The SQL above would have returned "1 row(s) affected." twice where I
would like it not to return any message as I am simply setting up
variables.

Any help on this would be greatly appreciated.

thanks
Brendan

On Wed, 14 Jul 2004 00:14:26 -0700, brendang wrote:

Try running:

set nocount on

before running your query.

Michael
--
Michael Peppler Data Migrations, Inc.
mpeppler (AT) peppler (DOT) org http://www.peppler.org/
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or
long term contract positions - http://www.peppler.org/resume.html

Thanks for taking the time to reply to my query. Your suggestion worked perfectly.
Brendan

Michael Peppler <mpeppler (AT) peppler (DOT) org> wrote