Re: UPDATE Statement


[ Follow Ups ] [ Post Followup ] [ Signature.net Forum ]

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.


Follow Ups:



Post a Followup

Name:
E-Mail:

Subject:

What is the name of the main Signature System's Product?  

Comments:

Optional Link URL:
Link Title:
Optional Image URL:

You may attach up to 5 files to your followup (see below):





Each file can be a maximum of 1MB in length Uploaded files will be purged from the server on a regular basis.


[ Follow Ups ] [ Post Followup ] [ Signature.net Forum ]