Re: Update Paradox table with TADODataSet


>I try to update a Paradox table using an TADODataSet that have a simple
>query. Is that posible? I'm getting the error: [Microsoft][ODBC Paradox
>Driver] Operation must use an updateable query.
>
>I know that this component is capable to update a table just like a TADO
>Table. Seems to me to be a limitation of ODBC Paradox Driver.
>
>The only way to make that simple update is to use a TADOTable?

Paradox queries are not normally updateable so it makes sense that ODBC would
not be able to update a query. The Microsoft ODBC driver for Paradox just uses
BDE.
You can set AdoDataset.commandType to cmdTable but that basically gets you the
functionality of a TadoTable.
Paradox and ADO are not a good combination.
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.

Relevant Pages

  • Re: Accessing a paradox table from a C# application...
    ... The ODBC driver that I am using is the Microsoft Paradox ... I'm not sure that the ODBC driver has anything to do with your query speed. ... If you restructured your table and added an integer field using the integer field for the key, that new field would be the source of the .px file for that table. ...
    (comp.databases.paradox)
  • Re: Could not open Paradox.net
    ... and this impacts the ODBC driver and version control, ... Paradox Support & Sales ... Another computer has PHP and Apache on it. ... I will refer to these as PHP machine ...
    (comp.databases.paradox)
  • Re: Blob fields
    ... Borland has neve published the internal format of Paradox tables so any ... other driver was created by reverse engineering the table format. ... but ADO works fine with blobs in other databases so the only thing left ...
    (borland.public.delphi.database.ado)
  • Re: Blob fields
    ... Borland has neve published the internal format of Paradox tables so any ... other driver was created by reverse engineering the table format. ... Eventhough it seemed to work on the surface, the BDE was still needed. ...
    (borland.public.delphi.database.ado)
  • Re: Paradox Data Export
    ... Not if you have available just about any Windows machine, which have an ODBC ... driver that'll usually do it. ... If you have Paradox or some BDE application, ...
    (comp.databases.paradox)