Posted by Les Toeplitz on June 01, 2012 at 03:22:39:
In Reply to: Re: UPDATE Statement posted by jim guerber on May 30, 2012 at 08:23:03:
I figured out the problem and it may have been an issue since the beginning of time. The UPDATE command will not allow you to clear a string field using null. You must use blanks to clear the field. The WRITE function works fine with nulls. The phenomena occurs in both C32 and C16. It may be by design. I just never noticed it. I can write around it.
Assume a string variable A$ declared to a length of 4
This will not work: read (2,1234) key= '1234' / A$ = "" / update (2,1234) key= '1234'
This will work: read (2,1234) key= '1234' / A$ = " " / update (2,1234) key= '1234'
Hope this helps.
Each file can be a maximum of 1MB in length Uploaded files will be purged from the server on a regular basis.