>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?


Hi Rixon,

It looks like the problem is limited to the symbol '[' only, the ']' doesn't cause any problems for me.
To work-around the problem either change WhereType to not include modified fields or change CompareMemo to .F. .

For example:

DBSETPROP("testView","VIEW","WhereType",1)

or

DBSETPROP("testView","VIEW","CompareMemo",.F.)

Thanks,
Aleksey.