OK, a lot of threads out there deal with this issue. I think I've looked at all of them. My problem is that my code works most of the time. Here's the code:
IF !USED("v_myview")
SELECT 0
USE v_myview
ENDIF
SELECT v_myview
=CURSORSETPROP("BUFFERING",5)
SCATTER MEMVAR BLANK
m.field1 = data
m.field2 = data
m.field3 = data
SELECT v_myview
APPEND BLANK
GATHER MEMVAR
=TABLEUPDATE(.T.,.T.)
Basically, that's it. Not much more going on. There are only three users that will ever access this view. Two will write to the table and the third will extract data for printing reports. One data entry person never has a problem, but the other one seems to be unsuccessful maybe 10-15% of the time. In some of the instances, I know for a fact, that neither of the other two users are accessing this table. Oh, and yes, MULTILOCKS is ON. Any suggestions?
Thanks,
Steve
IF !USED("v_myview")
SELECT 0
USE v_myview
ENDIF
SELECT v_myview
=CURSORSETPROP("BUFFERING",5)
SCATTER MEMVAR BLANK
m.field1 = data
m.field2 = data
m.field3 = data
SELECT v_myview
APPEND BLANK
GATHER MEMVAR
=TABLEUPDATE(.T.,.T.)
Basically, that's it. Not much more going on. There are only three users that will ever access this view. Two will write to the table and the third will extract data for printing reports. One data entry person never has a problem, but the other one seems to be unsuccessful maybe 10-15% of the time. In some of the instances, I know for a fact, that neither of the other two users are accessing this table. Oh, and yes, MULTILOCKS is ON. Any suggestions?
Thanks,
Steve