Update Paradox table with TADODataSet

Hi,

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?

Arminio,
Thanks
.

Relevant Pages

  • Re: Accessing a paradox table from a C# application...
    ... I would get a copy of Paradox and play around with restructuring the table and indexes and see what happens to query speed. ... There are several threads on the optimal way to set up a network. ... SELECT TOP 1000 * FROM ModelSer ...
    (comp.databases.paradox)
  • Re: Number of Records
    ... Paradox query process but seem to remember it can generate a lot of traffic ... > Diamond Software Group ... > Diamond Sports Gems ...
    (comp.databases.paradox)
  • Re: Accessing a paradox table from a C# application...
    ... SELECT TOP 1 * FROM ModelSer ORDER BY Timestamp ... How much faster is the query if you strip off the PX? ... The ODBC driver that I am using is the Microsoft Paradox ...
    (comp.databases.paradox)
  • Re: sql question
    ... the criteria row of the relevant column in the query. ... Paradox that I want to do in Access. ... Basically 7 different work schedules with 7 ... myLongDate = longInt;converts the date to a long integer ...
    (microsoft.public.access.formscoding)
  • Accessing a paradox table from a C# application...
    ... First off, I am very new to using Paradox tables, so I am stumped as ... SELECT TOP 1000 * FROM ModelSer ... the query runs fairly well ... timestamp set as the primary key. ...
    (comp.databases.paradox)