How would you determine if there are data that are missing? Do you have sequential key? Also, you should use a conditional TableUpdate if it is successful or not. This method is very important in a network environment because of table locks which are common in a multi-user system.
BEGIN TRANS
IF TABLEUPDATE(.T.,'yourtable')
END TRANS
ELSE
ROLLBACK
ENDIF
>my program is store at Novell Lan Server, all workstations are
>access f:\MYSYS\OAMAIN.FXP to run it.
>
>i open all database in "Buffering", 5 mode.
>**********
>SELE 1
>USE OABUYER ORDER 1 ALIAS BUYER
>=CURSORSETPROP("BUFFERING",5)
>**********
>Q1. Sometime my client told me some of data had lost.
> but i had check the system many time. the code is
> correct to store the data while the use click "SAVE" button.
>
>Q2. is it everytime access "=TABLEUPDATE" & "=TABLEREVERT",
> we need to run "FLUSE" to force the system to store
> into basedata then do next line.
>
>Q3. sometime i open the OABUYER file in normal mode,
> for my checking data. BUT another users are open it
> at "BUFFERING,5". i will append or delete some records.
> is it the reason for missing record as Q1.
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net
CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."