SQL Stored Procedure

Hi All,

I have written one SQL stored procedure to return a record set to the
calling program. in this Stored procedure i am fetching data from the
data base files.
Now the problem is that the application(calling program) is unable to
fetch all the data which is returning in record set. But if i am
sending some constant values then the application can fetch the data
easily.So i cant find out where is the problem?

Please help.

Thanks
Mohan

.

Relevant Pages

  • multiple recordset error trapping
    ... The stored procedure has internal error checking so that it ... thought was that it wold be similar in the recordset returned to the ASP ... response.write "1st record set" ... Microsoft OLE DB Provider for ODBC Drivers ...
    (microsoft.public.scripting.vbscript)
  • Re: SQL Stored Procedure
    ... I have written one SQL stored procedure to return a record set to the ... in this Stored procedure i am fetching data from the ... fetch all the data which is returning in record set. ...
    (comp.sys.ibm.as400.misc)
  • How to get stored procedure to ignore an @@error.
    ... The stored procedure seems to work properly, ... calling program diverts program flow to the "catch" portion of the try/catch ... test the @err output parameter. ... Please make sure the database has been initialized using ...
    (microsoft.public.sqlserver.programming)
  • Re: How to get stored procedure to ignore an @@error.
    ... The stored procedure seems to work properly, ... > And here's the calling program that sets up the parameter list and calls ... > MessageBox.Show("The connection with the database canīt be established", ... > SqlParameter param_CategoryName = ...
    (microsoft.public.sqlserver.programming)
  • Re: Damn you, FEDEX! or Nikon D40 lost in Springfield, MO blackhole.
    ... the 2 mp Mavica he had been using with a Nikon D40. ... After shopping around, he got me to order one for him. ... The shipper had it insured, but from what I have read it could take weeks to sort this crap out. ... You may get your insurance from FedEx and a couple weeks later they find it and deliver it. ...
    (alt.photography)