🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.ado
Article #1114

Refresh error in ADOQuery

#1114
From: Eduardo Jauch
Date: Tue, 04 Jan 2005 12:03
34 lines
2143 bytes
Hello to all!

I have a problem in an application that i am working.
This application must transfer the content of a
paradox table, to a DBF (dbaseIII) table.
I just can't perfoirme a simple conversion with
a converter program, because each table have specific
layouts, and i need information of many other's tables.
Problem's of different filosofies os the applications
that use each tabla.

I have to include new data missing in the DBF, and
update the existing data.

Unfortunally, If i try to append a new record on the DBF, and
after, i try to change another record, i receive an error
that the content was change and the row canot was found.

If i try to refresh the DBF, I receive an error related with
Key index...

I receive this error too when i try to refresh an acess table,
and it don't have an key index...

If i first append all new records and after update all records,
all work well. But this don't like an elegant way to do the job.

Exist some other way to do thi?
Can i do a temporary key index to the dbf table, for do not get an error 
while refreshing?

Thanks.

Eduardo Jauch.
Technical Details
Message-ID: <41da84cf$1@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!proxad.net!213.200.89.82.MISMATCH!tiscali!newsfeed1.ip.tiscali.net!border2.nntp.ams.giganews.com!border1.nntp.ams.giganews.com!nntp.giganews.com!pe2.news.blueyonder.co.uk!blueyonder!news-peer-test!btnet!newsfeed.bt.es!caladan.landsraad.net!newsgroups.borland.com!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Thread: 10698b,9e15cb769b64fb13,start
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
Date: Tue, 04 Jan 2005 10:03:02 -0200
From: Eduardo Jauch <sistemas@palletbrasil.com.br>
User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206)
X-Accept-Language: pt-br, pt
MIME-Version: 1.0
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Refresh error in ADOQuery
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 200.146.84.188
Message-ID: <41da84cf$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1104839887 200.146.84.188 (4 Jan 2005 03:58:07 -0800)
Lines: 34
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!proxad.net!213.200.89.82.MISMATCH!tiscali!newsfeed1.ip.tiscali.net!border2.nntp.ams.giganews.com!border1.nntp.ams.giganews.com!nntp.giganews.com!pe2.news.blueyonder.co.uk!blueyonder!news-peer-test!btnet!newsfeed.bt.es!caladan.landsraad.net!newsgroups.borland.com!not-for-mail