Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #12584
| From | Stefan Dietl <info@sdsoft.it> |
|---|---|
| Newsgroups | comp.lang.clipper.visual-objects |
| Subject | Re: Copy 2 dbf (dbfcdx) into one |
| Date | 2019-08-07 23:28 +0200 |
| Message-ID | <gr0u33F6hkjU1@mid.individual.net> (permalink) |
| References | <gqm8s5Fr7brU1@mid.individual.net> <qi5bbr$t96$1@gioia.aioe.org> <qi5brh$uj6$1@gioia.aioe.org> <gqq5jcFm40mU1@mid.individual.net> <qia9g6$hr0$1@gioia.aioe.org> |
Thank You Norbert! On dbf's with few fields it works perfect. I have a dbf with many fields (81) and there the calculation of the header length is wrong by one byte. So I have to do nPos-=1 before appending data of the second file. (The result of nPos in my file is something over 1500) Stefan Am 06.08.2019 um 00:10 schrieb nk: > Hello Stefan, > I'm sorry, but it was a little bit late. > Here the new version. I hope the function is now correct. > > Best regards > Norbert > > FUNCTION Start() > // Kopiert 2 DBF-Dateien mit der exakt gleichen Struktur > // in eine neuen Datei zusammen. > > LOCAL cDb01 AS STRING > LOCAL cDb02 AS STRING > LOCAL cDb12 AS STRING > LOCAL cTemp AS STRING > LOCAL nPos AS DWORD > LOCAL nLen1 AS DWORD > LOCAL nLen2 AS DWORD > LOCAL nSatz1 AS DWORD > LOCAL nSatz2 AS DWORD > LOCAL nSatz AS DWORD > LOCAL ptr01 AS PTR > LOCAL ptr02 AS PTR > LOCAL ptr12 AS PTR > > // Dateien > cDb01 := "D:\wrk\Vo28\Test\Test01.dbf" > cDb02 := "D:\wrk\Vo28\Test\Test02.dbf" > cDb12 := "D:\wrk\Vo28\Test\Test12.dbf" > > // Dateien öffnen > ptr01 := FOpen(cDb01) > ptr02 := FOpen(cDb02) > ptr12 := FCreate(cDb12) > > // Dateilängen ermitteln > nLen1 := DWORD(FSeek(ptr01, 0, FS_END)) > nLen2 := DWORD(FSeek(ptr02, 0, FS_END)) > > // Anzahl der Sätze der 1. Datei ermitteln > cTemp := " " > FSeek(ptr01, 4, FS_SET) > FRead(ptr01, @cTemp, 1) > nSatz1 := Asc(cTemp) > FRead(ptr01, @cTemp, 1) > nSatz1 += Asc(cTemp)*2^8 > FRead(ptr01, @cTemp, 1) > nSatz1 += Asc(cTemp)*2^16 > FRead(ptr01, @cTemp, 1) > nSatz1 += Asc(cTemp)*2^24 > > // Beginn des 1. Datensatzes ermitteln > FRead(ptr01, @cTemp, 1) > nPos := Asc(cTemp) > FRead(ptr01, @cTemp, 1) > nPos += Asc(cTemp)*2^8 > > // Anzahl der Sätze der 2. Datei ermitteln > FSeek(ptr02, 4, FS_SET) > FRead(ptr02, @cTemp, 1) > nSatz2 := Asc(cTemp) > FRead(ptr02, @cTemp, 1) > nSatz2 += Asc(cTemp)*2^8 > FRead(ptr02, @cTemp, 1) > nSatz2 += Asc(cTemp)*2^16 > FRead(ptr02, @cTemp, 1) > nSatz2 += Asc(cTemp)*2^24 > > // 1. Datei bis auf das Dateiendezeichen Chr(26) > // komplett in die Ergebnisdatei übertragen > cTemp := Space(nLen1-1) > FSeek(ptr01, 0, FS_SET) > FRead(ptr01, @cTemp, SLen(cTemp)) > FWrite(ptr12, cTemp, SLen(cTemp)) > > // Nur die Daten der 2. Datei übertragen > cTemp := Space(nLen2-nPos) > FSeek(ptr02, nPos, FS_SET) > FRead(ptr02, @cTemp, SLen(cTemp)) > FWrite(ptr12, cTemp, SLen(cTemp)) > > // Anzahl der neuen Datensätze eintragen > nSatz := nSatz1 + nSatz2 > cTemp := CHR(_AND(nSatz, 0b11111111)) > cTemp += CHR(_AND(nSatz >> 8, 0b11111111)) > cTemp += CHR(_AND(nSatz >> 16, 0b11111111)) > cTemp += CHR(_AND(nSatz >> 24, 0b11111111)) > > FSeek(ptr12, 4, FS_SET) > FWrite(ptr12, cTemp, SLen(cTemp)) > > // Dateien schließen > FClose(ptr01) > FClose(ptr02) > FClose(ptr12) > > RETURN NIL >
Back to comp.lang.clipper.visual-objects | Previous | Next — Previous in thread | Find similar | Unroll thread
Copy 2 dbf (dbfcdx) into one Stefan Dietl <info@sdsoft.it> - 2019-08-03 22:24 +0200
Re: Copy 2 dbf (dbfcdx) into one nk <norbert.k@chello.at> - 2019-08-04 03:11 +0200
Re: Copy 2 dbf (dbfcdx) into one nk <norbert.k@chello.at> - 2019-08-04 03:19 +0200
Re: Copy 2 dbf (dbfcdx) into one Stefan Dietl <info@sdsoft.it> - 2019-08-05 09:53 +0200
Re: Copy 2 dbf (dbfcdx) into one nk <norbert.k@chello.at> - 2019-08-06 00:10 +0200
Re: Copy 2 dbf (dbfcdx) into one Stefan Dietl <info@sdsoft.it> - 2019-08-07 23:28 +0200
csiph-web