FiveTech Support Forums

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

Regards Maurizio

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

Regards Maurizio

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

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 ?

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.

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

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

andreab wrote: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 wrote:

andreab wrote: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,

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 Linares wrote: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 wrote:Only one record (the first one) is copied ??? none should be there

Richard Chidiak wrote:Again the header of the original file where we delete is corrupted.

Antonio Linares wrote:

Richard Chidiak wrote:Only one record (the first one) is copied ??? none should be there

Have you checked if that record is marked as deleted ?

Richard Chidiak wrote: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.

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

Otto,

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