>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.

Weird trigger in the DB ?