>I ran into the same situation and originally wrote a small routine that used SPT that issued an update setting the memo field to ''. The issue seemed to only occur when the memo field allowed NULL, and was updating the NULL value. I presume it is a problem in the ODBC driver, as the update is instantaneous with SPT.
>
>My second solution proved a little more practical as I defined the memo fields as NOT NULL with a DEFAULT '' clause. This solved the problem for me.
Brad,
THANK YOU! It is really a good feeling to know that I am not alone with the problem.
It is odd. My memo(text) fields on the server are all set as NOT NULL. I also defined a DEFAULT as ''. This default is bound to all the memo(text) fields. Still I have the problem. What else do you think? If it is possible, I would really wish to avoid the modification of my framework.
I am wondering if other people also face the same problem. Thank you again.
Chen
Chen Nan