Change DBF

[sashaDG]

Hi everyone.
I solve the problem: there is a dirn dbf file (without indexes, not connected to the database), this file needs to be edited (add records from other files, change records, delete, save).

I want to do it this way: I create SELECT * FROM dirnn INTO CURSOR Tmpdir NOFILTER. Then I plan to use cursorsetprop (buffering) and TABLEUPDATE. Am I moving in the right direction?

This application should be shared, Thank you!

 

[sashaDG]

Chris Miller, thank you for the extensive and helpful answer!!! I wouldn't have figured it out without you.

But once you use view or CA, which both query data of a DBF into a cursor, at start you always have no deleted records in them and you can use modulo 2 of the record number to alternate between 0 and 1, for example.

This moment is not very clear to me, I understand what is mod(2).

PAСK in multi-user mode works fine?

 

[Chris Miller]

PACK in shared mode, no? I said " in a [highlight #FCE94F]maintenance[/highlight] over night from time to time", when you get the necessary exclusive access. ANd said "3. You PACK DBFs as [highlight #FCE94F]maintenance[/highlight]."

I should perhaps have made clear that maintenance of a database is what is an administrative process that you run with the goal of exclusive access, perhaps in a scheduled task done by an always running server at night. In a smaller network where you don't run a server it's still something done separtely when no user uses the software and thus the data.

Chriss

 

[sashaDG]

can you please tell me if I can call the This from my own function without getting the text: This can only be used within a method? I have to create new methods in the form.

 

[Mike Lewis]

Sasha,

Please start a new thread for your question about using THIS. It has nothing to do with updating DBFs.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads