HP3000-L Archives

December 2005, Week 2

HP3000-L@RAVEN.UTC.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Bruce Collins <[log in to unmask]>
Reply To:
Bruce Collins <[log in to unmask]>
Date:
Wed, 14 Dec 2005 15:08:35 -0500
Content-Type:
text/plain
Parts/Attachments:
text/plain (26 lines)
Walter Murray was the first to point out:
> The original poster asked how to generate a "null item" in an IMAGE
> field.
>
> I think some of the responses have played fast and loose with the term
> "null item".  The first thing you have to do is define exactly what you
> mean by that.

<snip>

>On a character field, such as type X, I think QUERY reports
> "NULL ITEM" if ALL characters in the field are the ASCII character NUL,
> that is, the character with the numeric value of 0.

That's what I would think of as a "NULL" item, but I don't think it is what 
QUERY is reporting as "NULL ITEM". I think you see this reported if ANY of 
the characters are NULL (or maybe just non-printable). At a site where I 
once worked they had a distressing tendency to redefine a few bytes here and 
there in IMAGE character items as integers. IMAGE will gladly store them and 
retrieve them fine, but in QUERY all that you would ever see is "NULL ITEM".

Bruce 

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

ATOM RSS1 RSS2