V4MD <NULL> vs ""

Ruslan Zasukhin sunshine at public.kherson.ua
Wed Jan 28 17:31:14 CST 2004


on 1/28/04 10:30 AM, Roland Hildebrandt at r.hildebrandt at sbt.fr wrote:

Hi Roland,

> I get some strange things when retrieving some data from varchar fields or
> text fields :
> 
> The records has been created using importascii and the problematic fields has
> from time to time no value associated.
> 
> The problem is the following when retrieving the data from records where some
> varchar fields or text fields has no value :
> 
> When I use getcolumn or getrecord(s) then it returns <NULL> for these fields.
> Where as when I use getfield it returns "".
> 
> Is there an explanation for this ? or should it always return <NULL> or "" ?

Deal is that getfield() must be always prefixed by call getIsNull() to check
if value is NULL.

And only if it is not null, call getfield().


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------



More information about the Valentina mailing list