[DUG] QuickReport Delphi 5 Enterprise MSSQL 2005 Storedprocedure

[Leigh Wanstead]

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/3ee9ecbf/attachment.html