We have a system which was built by an outside consultant using Visual Maxframe. I know little about the framework and exactly how it builds its cursors. We have come across a wierd situation and I hope somebody can point to a reason for this behavior and what could be done to fix it. The data is being pulled from a MySql database.

I SET STEP ON in a command button on the screen without doing any of the normal processing. I then do something like

GOTO 5
REPLACE stepno WITH stepno
GOTO 11
REPLACE stepno WITH stepno
GOTO 15
REPLACE stepno WITH stepno
GO TOP
? TABLEUPDATE(.T.,.T.,"myCursor") ---> .T.
BROWSE

RECNO() is now 16 and records 5,11, and 15 are marked as DELETED().

I realize that's an artificial construction, but the results are consistent. For example...

SELECT myCursor
lnStep = stepno
REPLACE ALL stepno WITH IIF(stepno >= lnStep,stepno - 1,stepno)
? TABLEUPDATE(.T.,.T.,"myCursor") ---> .T.

will result in all records where stepno is less than lnStep being deleted

SELECT myCursor
lnStep = stepno
REPLACE ALL stepno WITH stepno - 1 FOR stepno >= lnStep

will result in all records where stepno is less than lnStep being deleted

All input gratefully appreciated.