Well it seems as if VFP was having a problem with the data that was held in the sql text field that it was about to update. For some reason that data was preventing vfp from updating it in a remote view. All is well now after I deleted that data. Thanks for the help.