Re: Update Paradox table with TADODataSet

The SQL will be the same whether you use TADODataSet or TQuery and the
performance should be better with TQuery. I have no idea why you cannot
update using TADODataSet.

Note that using Paradox tables is not a good idea since Borland stopped
all development of the BDE years ago.

--
Bill Todd (TeamB)
.

Relevant Pages

  • Re: Update Paradox table with TADODataSet
    ... Bill Todd wrote: ... performance should be better with TQuery. ... Note that using Paradox tables is not a good idea since Borland stopped ... I sad that TADODataSet is a convenient way to do my updates because I don't have to write an Delete, Insert, Modify, Delete sql statament like I should do with an TUpdateSQL. ...
    (borland.public.delphi.database.ado)
  • Re: Update Paradox table with TADODataSet
    ... Bill Todd wrote: ... performance should be better with TQuery. ... Note that using Paradox tables is not a good idea since Borland stopped ... I sad that TADODataSet is a convenient way to do my updates because I don't have to write an Delete, Insert, Modify, Delete sql statament like I should do with an TUpdateSQL. ...
    (borland.public.delphi.database.ado)
  • Re: Update Paradox table with TADODataSet
    ... Bill Todd wrote: ... performance should be better with TQuery. ... Note that using Paradox tables is not a good idea since Borland stopped ... I sad that TADODataSet is a convenient way to do my updates because I don't have to write an Delete, Insert, Modify, Delete sql statament like I should do with an TUpdateSQL. ...
    (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: TADOStoredProc
    ... From D2006 the SQL is of type TWideStrings class. ... if they will use TADOCommand & TADODataSet. ... TADOCommand & TADODataSet usage will give you more explicit / natural control on recorset manipulations, briefcase model, persistence, ... ASA, Interbase/Firebird, DbExpress, ODBC data access engine ...
    (borland.public.delphi.database.ado)