Re: DataSet and SQL results dont match, help

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


"JP" <JP@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:01C4560E-EC44-432E-94F2-5D654E266702@xxxxxxxxxxxxxxxx
As anyone ever run into this before. VS 2005 C#. This is a combination of
SQL
and framework so I wasn't quite sure where to post it.

I have a SP that executes multiple SELECT statements. If the ROWCOUNT = 0
it
executes the next SELECT and so fourth. In the past its always been that
the
last SELECT executed would be the results that were returned to whatever
objAdapter executed the SP.

However, I've noticed that the results in the data adapter always contain
the results of the first SELECT. So if SELECT #1 returned 0 records and
the
last SELECT returned 3 records, the dataset would have 0 records.

Is this a bug? How can it be fixed?

--
JP
.NET Software Developer

In order to address your question, we'd need to see your code. Can you show
the selection logic block, or better still, reproduce the symptoms in a
short, but complete program?



.

Relevant Pages

  • Re: Pocket PC Data Transfer via internet
    ... (executes on your web server) ... that you call from your Phone Edition Compact ... Framework application. ...
    (microsoft.public.pocketpc.developer)
  • Simple framework for regression tests in src/tools/regression
    ... When I converted the test program for the posix shm stuff over to a regression ... framework provides routines for the test to indicate its result like so: ... one executes the 'run_tests' method provided by the ... case a test utility wants to take optional arguments, ...
    (freebsd-arch)
  • Re: Simple framework for regression tests in src/tools/regression
    ... framework provides routines for the test to indicate its result like so: ... one executes the 'run_tests' method provided by the ... case a test utility wants to take optional arguments, ... There is C++ in the base system. ...
    (freebsd-arch)
  • How to start a thread with a parameter in framework 2.0?
    ... I have heard theres a new way to start threads with parameters in framework 2.0, does anyone know how to do that? ... Start a thread that executes some stuff, in this case it does gets all files from a directory. ... the thread should be started with a parameter, in this case its a string that contains the path to the files... ...
    (microsoft.public.dotnet.languages.vb)