Re: Update Paradox table with TADODataSet

Bill Todd wrote: 
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.


Yes I know that the Borland has stopped development of BDE but I'm using it just for a desktop database with couple of tables normalized.

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. For know I'm using Master/Detail relationships between my tables and everythings seem to work fine even with tables full loaded as I'll expecting to be in production.

Thanks Bill
.

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
    ... The SQL will be the same whether you use TADODataSet or TQuery and the ... Prev by Date: ...
    (borland.public.delphi.database.ado)
  • Re: Inserting a bitmap into a SQL server image field
    ... It suggests using TADODataSet ... with commandtype of cmdTableDirect. ... the way I use Paradox tables ... ...
    (borland.public.delphi.database.ado)
  • Update Paradox table with TADODataSet
    ... I try to update a Paradox table using an TADODataSet that have a simple query. ... Arminio, ...
    (borland.public.delphi.database.ado)