Re: TADOStoredProc

For instance. TAdoQuery sets the SQL using a Tstringlist while
TadoDataset uses a Widestring;

That is not good example, really. From D2006 the SQL is of type TWideStrings class. Similar about performance. One can write:

with SQL do begin
BeginUpdate;
SQL.Add('SELECT....');
SQL.Add('FROM ....');
SQL.Add('ORDER BY....');
EndUpdate;
end;

or can write

CommandText := 'SELECT ...';
CommandText := CommandText + 'FROM ....';

I prefer first way <g>

I know few extremely large application built on TADOQuery,
TADOStoredProc. And there is nothing, what these application
can get additionally, if they will use TADOCommand & TADODataSet.
TADOCommand & TADODataSet usage will give you more explicit / natural control on recorset manipulations, briefcase model, persistence,
etc. Just if application is needing that ...

Regards,
Dmitry

--
Dmitry Arefiev - www.da-soft.com
AnyDAC - Oracle, MySQL, MSSQL, MSAccess, IBM DB2, Sybase
ASA, Interbase/Firebird, DbExpress, ODBC data access engine
ThinDAC - multitier data access engine

.

Relevant Pages

  • Re: Use query or stored procedure
    ... but I'd recommend the tADODataset instead of the tADOQuery. ... > Since the SQL is an insert statement and returns no records a TadoCommand ...
    (borland.public.delphi.database.ado)
  • How do I capture Delphi 5 TADODataset timeout error consistently?
    ... hitting a SQL Server 2000 database. ... I have a simple reporting application that uses a TADODataset to run ... After lDSMain runs, it loops through its datasets, assigning each to ... If the timeout does not get recognized, ...
    (borland.public.delphi.database.ado)
  • Re: How do I capture Delphi 5 TADODataset timeout error consistently?
    ... When I run a query that executes a stored procedure, ... If I just run straight SQL text that returns a large dataset, ... > I am using Delphi 5, hitting a SQL Server 2000 database. ... > I have a simple reporting application that uses a TADODataset to run ...
    (borland.public.delphi.database.ado)
  • Using TADODataset
    ... Are there any advantages to using the IndexFieldNames and IndexName property ... of the TADODataset versus just writing the SQL the way you want your result ...
    (borland.public.delphi.database.ado)
  • Re: Creating a linked table programmatically
    ... >I am able to set up a TADODataset as I am understanding from your ... Linking means you have two TadoDatasets where the records in the linked dataset ... or you have linked servers. ... You will have to write the SQL in your code so you ...
    (borland.public.delphi.database.ado)