>>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 ?
Thanks for the reply
No triggers that I know of. The records in the database are not deleted. Only the ones in the local cursor.