hi guys,
im using SPT updatable cursor to update mysql database backend.
updating is working fine. but i have issue with memo fields.
in mysql, i have field: narration varchar(500).
using SQLEXEC(), this field converts to memo field in vfp cursor as it's more than 254 chars.
to update backend i have this command : *fheader is linked to table in server via SPT
sele fheader
append blank
gather name (oObj) memo
if the field is empty its becomes NULL in backend.
how to make it as empty string if blank instead of NULL
hope i have explain it clearly.
anyone could help. greatly appreciated!
Vie
im using SPT updatable cursor to update mysql database backend.
updating is working fine. but i have issue with memo fields.
in mysql, i have field: narration varchar(500).
using SQLEXEC(), this field converts to memo field in vfp cursor as it's more than 254 chars.
to update backend i have this command : *fheader is linked to table in server via SPT
sele fheader
append blank
gather name (oObj) memo
if the field is empty its becomes NULL in backend.
how to make it as empty string if blank instead of NULL
hope i have explain it clearly.
anyone could help. greatly appreciated!
Vie