Ado and Client Datasets

From: Rick (rick_at_tariffnet.com)
Date: 01/19/05 

Date: Wed, 19 Jan 2005 14:57:17 -0500

Platform: Delphi 2005 Pro (with patch), Win2k Server (fully patched).

Hello,
I have just been getting my hands around the Delphi ADO objects. I have a
little test program and have been having trouble getting it to return data
using a ClientDataSet.

Details (dbGo where it matters):
AdoConnection --> AdoDataSet --> DatasetProvider --> ClientDataSet -->
DataSource --> DBGrid

Everything is linked and seems to work great with a standard SQL Statement
(eg Select ... from ...). However when I call a stored procedure that
returns records, the grid is blank, actually it has field names but no
records. I know its not the stored procedure, because 19 records are
returned to the AdoDataset, but never seem to make it the rest of the way
down stream. if I set the AdoDataset to load the Datasource directly, the
grid is filled perfectly.
What am I missing?

The DataSetProvider.DataSet is set to AdoDataSet1. No storedprocedure is
working, even a simple select statement... please help.

thanks
Rick

Relevant Pages

  • Re: Returning records from a Store Procedure
    ... It is being assigned to a datareader. ... Runs decently when the Stored procedure returns a small data set. ... That takes 10 minutes to finish loading. ... > object to get data out of a database, but if you're loading it to a grid it ...
    (microsoft.public.data.ado)
  • Re: Local dataset show parts in two grids
    ... How about using clone of original ADODataSet with properly assined filter ... for each grid. ... > other in a second DBGrid depending on the value in one of the fields. ...
    (borland.public.delphi.database.ado)
  • Re: DataGrid Colum Names
    ... Should I create a datatable from the stored procedure? ... > You'll reference the DataTable that you bound the grid to. ... > grid is just the presentation of the underlying data obejct. ...
    (microsoft.public.dotnet.languages.vb)
  • Unable to retrieve schema - Divide by zero error encountered
    ... Here's the funny thing - the grid works fine. ... I get to the point where I can test the data source, ... calls a stored procedure with two arguments) are correct. ... even Visual Studio manages to get the data in the data source configuration ...
    (microsoft.public.dotnet.framework.aspnet.datagridcontrol)
  • Re: Stored Procedure Help
    ... if you are expecting the results of the stored procedure to display in the ... refresh the grid. ... Be sure to disable controls before calling the close, ...
    (borland.public.delphi.database.ado)