General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>It doesn't matter whether you use the cursoradapter or not. You can access VFP tables directly.
>
>I need to dig into my old code to see which SYS settings it is that fixes this. It's either Sys(3051) or Sys(3052) or something else (I think it's something else).
>
>The sys function I'm thinking about requires that VFP locks all three files (dbf, fpt, and cdx) before it makes changes.
>
>I'll be back!
Ok, it is Sys 3051 and sys 3052 as well as Set Reprocess and On Error. Hopefully, you already have some kind of error handling in place.
So, read about these sys settings and reprocess.
Here's the code I always used when working with DBFs.
* Below is prevent corrupt data; get record locks on .dbf, .cdx, .fpt for updates
sys(3052,1,.t.)
sys(3052,2,.t.)
sys(3051,500) &&333 is default - avoids a network storm
set reprocess to 20
set reprocess to 20 system
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only