Re: RETURN_VALUES ??? done... What have I gained?


>General question...
>
>-using an ADOSTOREDPROC component... is there any reason why I should use
>something else, say ADOQuery ???? With adodataset I was getting an error
>about a result set and didn't see anywhere where I had the opportunity to
>Execproc vs Open... (did I miss something there?)
>
>-the only advantage I see is that I'm not trying to return a dataset when
>all I need is a stinkin value, amount, string, what-have-you... there is
>nothing especially clean and simple about it... so... (the question)
>(FINALLY!)... Did I really gain anything??? (other then some tiny sense of
>accomplishment)
>
>That is a serious question by the way... is it somehow more effecient to
>retrieve one value/result when that is all you need?
When Borland came out with its ADO components they included three dataset
components (TadoTable,TadoQuery,TadoStoredProc) that closely resembled similar
BDE components. They also gave use two dataset components that had properties
that where closer to ADO native properties . These two are TadoDataSet and
TadoCommand. You use TadoDataset when a recordset is returned and TadoCommand
when you don't get a recordset.
There should be a small performance gain in not having a recordset returned and
it should require less code to use.


--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.

Relevant Pages

  • Re: OLE error 80040200 when assigning events of a TCustomADODatasetpointingto a multi-select stored
    ... all properties should be set on initial recordset before Open. ... recordsets will inherit properties. ... There should be no memory leaks because TADODataSet is not reference ...
    (borland.public.delphi.database.ado)
  • Re: How do I work with Recordset in ExecuteComplete event?
    ... I want to use Recordset external to the ExecuteComplete event. ... TADODataSet has read/write property RecordSet, so you can create TADODataSet assign its recordset and use TDataSet methods. ...
    (borland.public.delphi.database.ado)
  • Re: ADOCommand.Execute
    ... ADOCommand object does not return a Recordset ... TadoTable and TadoDataset are both TCustomAdoDataset descendants ... Brian Bushay ...
    (borland.public.delphi.database.ado)
  • Re: adoquery.Recordset.pagesize
    ... >Access Violation as before. ... This appears to be one of the properties that can only be set when a recordset ... Delphi 6 and up TadoDataset has an OnRecordsetCreate Event you can ...
    (borland.public.delphi.database.ado)