Hi, Raza!
>>
but in TABLE1 the records stay deleted.
<<
Sound like Table1 doesn't take part in connection "gnc"!
>>
I tried your code.
<<
BTW: Use the tags < p r e > and < / p r e > (without any blanks <s>) to encapsulate your source code to produce lines like this:
...
IF AllIsOk
WAIT WINDOW NOWAIT
ENDIF
...
SeBaFlu