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