PDox Table not getting updated

Butch

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

PDox Table not getting updated

I am currently working with a paradox table and Delphi 4 and I have all
the components hooked up properly to support editing of the results of my
query.

My problem is that I call Applyupdates on the query and none of the values
actually get passed on into the db tables. I DO have cached updates set
to true, I have an updatesql object set up with the sql statements
generated. After I call applyupdates, I try query1.close followed by
query1.open to test that the data is there, but it reverts to the original
contents that existed before I edited them.

Any ideas? I can give more details as needed . . .

Butch Istook
ist...@cs.byu.edu

Reid Roma

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:PDox Table not getting updated

Try issuing a COMMIT TRANSACTION with the TDatabase component.

Does that work?

RKr

Quote

Butch wrote:

> I am currently working with a paradox table and Delphi 4 and I have all
> the components hooked up properly to support editing of the results of my
> query.

> My problem is that I call Applyupdates on the query and none of the values
> actually get passed on into the db tables. I DO have cached updates set
> to true, I have an updatesql object set up with the sql statements
> generated. After I call applyupdates, I try query1.close followed by
> query1.open to test that the data is there, but it reverts to the original
> contents that existed before I edited them.

> Any ideas? I can give more details as needed . . .

> Butch Istook
> ist...@cs.byu.edu

--
\|||/
/'^'\
( 0 0 )
--------------oOOO--(_)--OOOo--------------
. Reid Roman .
. Delphi Programmer / Analyst .
. TVisualBasic:=class(None); .
. May the Source be With You .
-------------------------------------------
. Auto-By-Tel (http://www.autobytel.com) .
. Irvine, CA U.S.A .
. E-Mail : rkroman (at) pacbell (dot) net .
. or reidr (at) autobytel (dot) com .
-------------------------------------------

Other Threads

1. Help!. Getting Pdox message when accessing dbase tables

2. Do cached updates use Pdox- or Inmemory-Tables?

3. Change table type Pdox 4 to Pdox 7

4. Batch Update - Not Updating Table

5. Paradox : Changes Not Getting Updated

6. How specify pdox table version when creating a table with TTable

7. Getting User Name for a Pdox based system

8. ADOTable is not getting field properties from Access table

9. Getting rid of the dreaded pdox...net files

10. Cached Updates QUESTION: Sorting table of updated and non-updated records