Re: Update Paradox table with TADODataSet

Brian Bushay TeamB wrote:

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


Yes you have perfectly right! I drop the idea with ADO and switched to BDE

Thanks Brian
.

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)