Re: TADOStoredProc

On Fri, 12 Oct 2007 22:47:44 +0100, Niklas Larsson <nla@xxxxxxxxxxxxxxxxxx> wrote:

I must say I'm sorry for starting this "battle" ...

Whoops! I hadn't noticed any "battle" here.

For the record, I agree with Brian that if you're starting out on a new project, instead of "tAdoQuery", you'd be better advised to use "tAdoDataSet" (would that they had come up with a more expressive name!)

But if you are tasked with maintaining an existing program, converting each and every tAdoQuery to a tAdoDataset probably won't, by itself, be the "magic bullet" you're looking for.

--
Paul Scott
Information Management Systems
Macclesfield, UK.
.

Relevant Pages

  • Re: ADOQuery or ADOTable?
    ... TADOQuery is ok for querys, but as TADODataset has all the ... > features, ... As per Delphi Help. ... TADODataSet is not capable of issuing Data Manipulation Language SQL ...
    (borland.public.delphi.database.ado)
  • Re: slow refresh of mysql datasets via ADO
    ... the nasty habit to try to load the whole table data. ... TADODataset instead. ... I already got rid of the table. ...
    (borland.public.delphi.database.ado)
  • Re: Changing DB with TADOConnection
    ... >to the new DB and can even oepn up a TADOQuery and manipulate it. ... >However, when I then go to open a TADODataset, I get either a "stack ...
    (borland.public.delphi.database.ado)
  • Re: ADOQuery or ADOTable?
    ... a TADOQuery must be used for DML. ... > TADODataSet is not capable of issuing Data Manipulation Language ... > (DML) SQL statements that do not return result sets (like DELETE, ... could be seen as personal POV. ...
    (borland.public.delphi.database.ado)
  • Re: Changing DB with TADOConnection
    ... >ok I switch the TadoDataset to a TadoQuery and I am testing with D5 ... >No problem with previously posted code ... Hmmm, I wonder if it has to do with multiple ado datasets. ...
    (borland.public.delphi.database.ado)