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
   * this is very important code
   WAIT WINDOW NOWAIT
ENDIF
...