Article View: borland.public.cppbuilder.database.ado
Article #1114Refresh error in ADOQuery
From: Eduardo Jauch
Date: Tue, 04 Jan 2005 12:03
Date: Tue, 04 Jan 2005 12:03
34 lines
2143 bytes
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-mailShow 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