FW: Any concerns with using NUL char with PowerHouse

[Darren Reely]

Blue,

Richard isn't talking NULL.  He is talking about ascii value zero, NUL. 
Being an ascii character, it should take up space in a database if the
database doesn't object.  Surprisingly, quiz prints an empty string for it,
and it can be used in concatenation without the side effect of creating a
NULL string.

I'm still trying to understand what he really wants to do with it.

;On Sun Solaris
define my_nul_num INT*3 UNS SIZE 1 = 0
define my_nul CHAR*1 = CHAR(my_nul_num)
define my_NULL char*1 = NULL
define result_is_null char*20 = 'mystring' + my_NULL
define result_is_mystring char*20 = 'my' + my_nul + 'string'

Darren


"Edis, Bob" wrote:
> 
> G'day Richard
> 
> I've had problems in the past where an index used from primary file
> retrieval in a screen contained a null.  The results were unpredictable but
> often records could not be viewed even though a user had just entered them.
> These were NOT the records that contained the NULL.  Removing the NULLs from
> the index column eliminated the problem.
> 
> Regards,
> Blue
> 
> -----Original Message-----
> From: Richard Sheehan [mailto:sheerich@isu.edu]
> Sent: Thursday, January 17, 2002 5:01 PM
> To: PowerHouse List
> Subject: Any concerns with using NUL char with PowerHouse
> 
> Hello,
> 
> Does anyone know of any undesirable side effects of storing the acsii(0)
> NUL in a field in an Image Dataset?  And for the ?inevitable? future,
> how about any other DB's for that matter?
> 
> How might this affect any PowerHouse applications?
> 
> Initial testing seems to show no side effects. Size() and Index() seem
> to work properly on the test data.  Printing also seems unaffected.
> 
> I'm looking to use it or another ascii character as a logical separator
> in free form text entry, when no space occurs in the text, such as in a
> URL string.
> 
> TIA,
> 
> --
> Richard Sheehan,
> Administrative Systems - IT Programmer Analyst
> Idaho State University Computing & Communications
> Campus Box 8037, Pocatello, ID 83209-8037
> Phone: 208.282.3861 - Fax: 208.282.3673
> Email: sheerich@isu.edu
> 
> = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Mailing list: powerh-l@lists.swau.edu
> Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
> Unsubscribe: "unsubscribe" in message body to
> powerh-l-request@lists.swau.edu
> http://lists.swau.edu/mailman/listinfo/powerh-l
> This list is closed, thus to post to the list you must be a subscriber.
> 
> = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Mailing list: powerh-l@lists.swau.edu
> Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
> Unsubscribe: "unsubscribe" in message body to powerh-l-request@lists.swau.edu
> http://lists.swau.edu/mailman/listinfo/powerh-l
> This list is closed, thus to post to the list you must be a subscriber.