Problem with dbdelete() and pack

[Maurizio]

I use DBFCDX RDD
the command dbdelete() and pack
don't work correctly

Regards Maurizio

[Richard Chidiak]

I use DBFCDX RDD
the command dbdelete() and pack
don't work correctly

Regards Maurizio

Maurizio

Do you have

SET DELETE ON

Richard

[Daniel]

We have same problem, only in real pocket pc.

In PC with harbour or xharbour work ok. Also in emulator is ok.

PACK and ZAP not delete records, only mark it except the first record that recall delete.

We do not use index.

And we use SET DELETED ON

If PACK is not used all records mark deleted correctly.

*

USE FALLIN
GO TOP
DO WHILE .not. Eof()
DELETE
SKIP 1
ENDDO
PACK
CLOSE

USE FALLIN
GO TOP
IF .not. Eof()
MsgInfo("Hay Datos","Atencion")
ENDIF
CLOSE

Regards

[Antonio Linares]

Daniel,

Yes, it is working ok on the emulator but it isn't on the pocket pc. Very strange. They should work the same.

Do other FWPPC users have noticed the same ? Any workaround ?

[Antonio Linares]

A first idea to use as a workaround it may be to create a temporary DBF and copy the non deleted record only to it.

Then remove the first DBF file, and rename the temporary as the good one.

[Maurizio]

I try on Windows CE.NET and on pocket pc
with the same problems
Maurizio

[andreab]

I think that problem is dbf path.
I have oher problems' with this...
but not with emulator....
Use path for open dbf...

My two cents
regard's
andrea bruni

[Richard Chidiak]

I think that problem is dbf path.
I have oher problems' with this...
but not with emulator....
Use path for open dbf...

My two cents
regard's
andrea bruni

It is not the path but probably the header of the dbf for the first record.

Antonio, i tried the test.prg that you have in samples dir and tried to open the dbf file (after program execution) on my laptop pc. My dbf editor (cdbfw) did not want to open it mentionning dbf header is not correct. Once corrected, it shows that 2nd and third are deleted.

Richard

[Richard Chidiak]

I think that problem is dbf path.
I have oher problems' with this...
but not with emulator....
Use path for open dbf...

My two cents
regard's
andrea bruni

It is not the path but probably the header of the dbf for the first record.

Antonio, i tried the test.prg that you have in samples dir and tried to open the dbf file (after program execution) on my laptop pc. My dbf editor (cdbfw) did not want to open it mentionning dbf header is not correct. Once corrected, it shows that 2nd and third are deleted.

Richard

Forgot to say, execution did occur on pocket pc and file was copied to laptop afterwards

[Antonio Linares]

Richard,

I have tested it on the emulator and works ok. Then I modified the DBF path (SD card) and tested it again on the real pocket pc and the problem then happens.

I guess we need to create a zapDbf() function that does what I described on a previous msg. Also we could try COPY TO ... FOR ... command too.

[Richard Chidiak]

Richard,

I have tested it on the emulator and works ok. Then I modified the DBF path (SD card) and tested it again on the real pocket pc and the problem then happens.

I guess we need to create a zapDbf() function that does what I described on a previous msg. Also we could try COPY TO ... FOR ... command too.

Antonio

I tried COPY TO on pocket pc

Only one record (the first one) is copied ??? none should be there

Again the header of the original file where we delete is corrupted.

Richard

[Antonio Linares]

Only one record (the first one) is copied ??? none should be there

Have you checked if that record is marked as deleted ?

Again the header of the original file where we delete is corrupted.

How do you know this ? Do you get an error when you try to open it ? What tool are you using to open it ? Thanks.

[Richard Chidiak]

Only one record (the first one) is copied ??? none should be there

Have you checked if that record is marked as deleted ?

Again the header of the original file where we delete is corrupted.

How do you know this ? Do you get an error when you try to open it ? What tool are you using to open it ? Thanks.

Antonio,

The only record left (first one) is "not" quoted as DELETED

After execution on my pocket pc, i remove the sd card and put it on a sd card reader connected to my computer, then i can open the file on my laptop.

I use cdbfw for browsing any dbf, this product is just magic, and cdbfw informs me that the header is corrupted.

Richard

[Otto]

Hello,
What is the status on ZAP and PACK.
Is ZAP and PACK working now?
Thanks in advance
Otto

[Antonio Linares]

Otto,

As we are using a recent Harbour build with FWPPC, those RDD functions should be working fine.