[DUG] QuickReport Delphi 5 Enterprise MSSQL 2005 Storedprocedure

Jeremy Coulter jscoulter at gmail.com
Tue Aug 4 14:54:19 NZST 2009


yeah sometimes I have to put  SET NOCOUNT ON in some stored procs too.
I find some stored procs throw a wobbly in ASP as well as Dephi, but I
suspect thats more of an ADO issue since I use ADO in both technologies.
 
 
Jeremy

  _____  

From: delphi-bounces at delphi.org.nz [mailto:delphi-bounces at delphi.org.nz] On
Behalf Of Leigh Wanstead
Sent: 4 August 2009 14:50
To: NZ Borland Developers Group - Delphi List
Subject: Re: [DUG] QuickReport Delphi 5 Enterprise MSSQL 2005
Storedprocedure


I got around the problem by putting these statements in the stored procedure
 
 SET CONCAT_NULL_YIELDS_NULL on;
 SET ANSI_WARNINGS on;
 SET ANSI_PADDING on;
 SET ARITHABORT on;

Have a nice day
 
Regards
Leigh

-----Original Message-----
From: delphi-bounces at delphi.org.nz [mailto:delphi-bounces at delphi.org.nz]On
Behalf Of Jeremy Coulter
Sent: Tuesday, 4 August 2009 2:30 p.m.
To: 'NZ Borland Developers Group - Delphi List'
Subject: Re: [DUG] QuickReport Delphi 5 Enterprise MSSQL 2005
Storedprocedure


does the Stored proc. you are calling work ok if you call it in iSQL?
That would help eliminate it being something wrong with the stored proc.
 
Jeremy

  _____  

From: delphi-bounces at delphi.org.nz [mailto:delphi-bounces at delphi.org.nz] On
Behalf Of Leigh Wanstead
Sent: 4 August 2009 14:26
To: NZ Borland Developers Group - Delphi List
Subject: [DUG] QuickReport Delphi 5 Enterprise MSSQL 2005 Stored procedure


Good afternoon,
 
I am calling a stored procedure in Quick report Dataset. I got the error
shown in the attachment.
 
What can I do?
 
TIA
 
Regards
Leigh

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserver.123.net.nz/pipermail/delphi/attachments/20090804/4ab9cf12/attachment.html 


More information about the Delphi mailing list