If this happens doing an update, then you will have to do a tablerevert() first. This is why I quit using remote views. Using sqlexec() I trap this type of error and then try and reconnect and run the sql again if the reconnect works.


>We are using MySQL over Internet and sometime we are losing the connection with the remote open table.
>
>When that append we can trap the error "1526, connectivity error [MySQL] [ODBC 3.51 driver] mysqld-4.1.12-log] MySQL server has gone away" but we have no way to quit VFP. When we try to quit the error come back. The only thing we can do is an End task.
>
>Since this is a robot running on a server I need a better way.
>
>How can I quit VFP when that append?