A "[" or "]" is used in a VFP8 SP1 memo field, and that memo field is used to UPDATE a remote view SQL table's column that has a TEXT datatype. If the SQL table does not already have a "[" or "]" in that TEXT datatype column, the UPDATE will work.

However, if either a "[" or "]" already exists in the remote view's SQL table's column that has a TEXT datatype, the UPDATE will fail.

Removing all references to "[" and "]" in the VFP8 SP1 memo field allows the UPDATE to be successful.

Does anyone know a work around for this?