Re: how to deal with multiple result sets in D6 ADO?

From: David S (nowhere_at_nowthere.com)
Date: 03/14/05

  • Next message: Jeremy Collins: "Re: Size of resultset" 
    Date: Sun, 13 Mar 2005 21:55:11 -0700

    Great resource I didn't know about!

    I found exactly what I was looking for.

    Thanks!
    -David

    Peds wrote:
    >
    > "David S" <nowhere@nowthere.com> wrote in message
    > news:423136BE.C6E74CFE@nowthere.com...
    > > Thanks, but after further studying, I find I need more info. Can you
    > > possibly point to a code example somewhere? I've been searching the
    > > web, and haven't found anything beyond the "examples" in Delphi's help,
    > > which aren't terribly informative in this case. And the help text
    > > itself looks to be adapted from Microsoft's documentation and not very
    > > well tailored for Delphi.
    > >
    > > For instance, in SQL Server 2k, the sp_help proc returns a varying
    > > number of result sets, between one and six or so, depending on the
    > > argument you pass to it. Can each result set be displayed in a separate
    > > TDBGrid? Or do you need to extract data and stuff it into a TStrinGrid
    > > if you want to display it? When you switch result sets, how do you know
    > > what a given result set represents if the number of result sets varies?
    > > When you run sp_help in the Query Analyzer, that's one thing: you can
    > > eyeball the data and figure out what it is. But, what's an application
    > > to do? Surely, someone has discussed this topic somewhere!
    >
    > David,
    >
    > Search on NextRecordSet on
    > http://www.fulltextsearch.com (Borland newsgroups)

  • Next message: Jeremy Collins: "Re: Size of resultset"

    Relevant Pages

    • Re: how to deal with multiple result sets in D6 ADO?
      ... "David S" wrote in message ... I've been searching the ... Or do you need to extract data and stuff it into a TStrinGrid ... > if you want to display it? ...
      (borland.public.delphi.database.ado)
    • Re: Can I mimic a btn_Click() ?
      ... In the sample code instead of searching an event with type of ... Other remote UDP command are> OK as long as the display is not affected. ... Once I'm in the> CalibrateLCD_Clickevent handler my sender and "this" look OK in my> "Autos" window in both cases. ...
      (microsoft.public.dotnet.framework.compactframework)
    • For readers
      ... I keep searching for the perfect gadget to take ... Around a 6" x 9" display ... The purpose of the operating is *mainly* to retrieve (from ... I know there have been some ebook-type reader marketing failures, ...
      (microsoft.public.pocketpc)
    • Re: Create a button to save/update record OR add new record
      ... automatic in ms-access anyway). ... So, you need some caution if you are use the SAME form for searching, as any ... ' invoice exist...lets display the invoice form ... invoice form to ONE record,then you can hide/disable the record navigation ...
      (microsoft.public.access.forms)
    • Re: Create and store unique record number.
      ... > I've been searching through the threads trying to find a post that ... RecordID field and RecordDate field. ... You can just store the date and format it to give the value you ... It would be better to have to fields and use a calculated field to display ...
      (microsoft.public.access.forms)