Actually, the NULL character is a true character. Specifically, it is CHR$(0) <---zero. It is an actual character in ASCII and other sets.
Alternatively, NULL is used in databases, Java, C, others to describe certain situation. Java: Null pointer is a pointer which has a value of zero and therefore is an invalid reference and you'll get an exception. C: Same thing, you'll get a seg fault or similar. Databases: If the datatype is defined can be null, then the absence of any value is NULL. It is completely possible to have a VARCHAR and not allow null and have a string stored with CHAR(zero) in it. It is a NULL character and not the NULL situation. The lack of any string is a NULL situation and not a NULL character. Usually, the absence of assigning a variable a value will result in a NULL situation, not a NULL character. Make sure you've got it correct or confusing results will follow. -Fernando ---------- Original Message ----------- From: "Rodney Rundstrom" <[email protected]> To: "'mailing list for gambas users'" <[email protected]> Sent: Mon, 20 Apr 2009 10:56:29 +1200 Subject: Re: [Gambas-user] Catch NULL character > As the NULL character is not a true character just a place holder you should > use ISNULL( ) > > Ie if ISNULL(NULL) Then print "GOT it" > Just change NULL for your variable > > Rodney Rundstrom > > -----Original Message----- > From: CelticBhoy [mailto:[email protected]] > Sent: Sunday, 29 March 2009 9:26 a.m. > To: [email protected] > Subject: Re: [Gambas-user] Catch NULL character > > Thanx again for the help. I will have a look at your advice and try and > implement it in my code. This is my first crack at programming since way > back in the QuickBasic days, so I appreciate the help. > -- > View this message in context: > http://www.nabble.com/Catch-NULL-character-tp22751957p22760874.html > Sent from the gambas-user mailing list archive at Nabble.com. > > ---------------------------------------------------------------------------- > -- > _______________________________________________ > Gambas-user mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/gambas-user > > ------------------------------------------------------------------------------ > Stay on top of everything new and different, both inside and > around Java (TM) technology - register by April 22, and save > $200 on the JavaOne (SM) conference, June 2-5, 2009, San Francisco. > 300 plus technical and hands-on sessions. Register today. > Use priority code J9JMT32. http://p.sf.net/sfu/p > _______________________________________________ > Gambas-user mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/gambas-user ------- End of Original Message ------- ------------------------------------------------------------------------------ Stay on top of everything new and different, both inside and around Java (TM) technology - register by April 22, and save $200 on the JavaOne (SM) conference, June 2-5, 2009, San Francisco. 300 plus technical and hands-on sessions. Register today. Use priority code J9JMT32. http://p.sf.net/sfu/p _______________________________________________ Gambas-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/gambas-user
