Re: TADOStoredProc



Nigel Jones wrote:

I'm not sure what you mean by "do not match up well"? We have a large
client suite that excusively uses TADOQuery and TADOStoredProc
components for database access. We don't appear to have any problems
with the components and they are easy-to-use.

Read a bood about ADO and try to map the objectes, properties, methods
and events to TADOQuery, TADOStoredProc, TADOCommand and TADODataSet.
You will find the mapping almost perfect with TADOCommand and
TADODataSet. TADOQuery and TADOStoredProc work well but they do not
expose all of the features of ADO the way TADOCommand and TADODataSet
do.

--
Bill Todd (TeamB)
.



Relevant Pages

  • Re: TADOStoredProc
    ... used TadoDataset and TadoCommand instead of TadoStoredProc or TadoQuery ...
    (borland.public.delphi.database.ado)
  • Re: TADOStoredProc
    ... TadoStoredProc and TadoQuery are intended to match up with the properties ... TadoCommand do. ...
    (borland.public.delphi.database.ado)
  • 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)
  • Re: ADOConnection TimeOut 30 second, no way to change it ???
    ... TadoStoredProc. ... Use a Tadocommand or TadoDataset and set the commandtimeout ...
    (borland.public.delphi.database.ado)
  • Re: TADOStoredProc
    ... If the underlying dataset (TADOStoredProc, TADOQuery, TADODataSet, etc) is ... FErrorMsg:= 'Unable to refresh term lookup due to ...
    (borland.public.delphi.database.ado)