[DUG] QuickReport Delphi 5 Enterprise MSSQL 2005 Storedprocedure
Neven MacEwan
neven at mwk.co.nz
Tue Aug 4 17:49:01 NZST 2009
J
Yes ADO is the issue, IIRC it checks the count on updates, ie number of
rows affected versus expected
I had this problem with some triggers
N
> 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
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> NZ Borland Developers Group - Delphi mailing list
> Post: delphi at delphi.org.nz
> Admin: http://delphi.org.nz/mailman/listinfo/delphi
> Unsubscribe: send an email to delphi-request at delphi.org.nz with Subject: unsubscribe
More information about the Delphi
mailing list