[fpc-pascal]SQLite and NULL Strings...

[James Mills]

On Tue, Jul 15, 2003 at 08:35:44AM -0700, Alan Mead wrote:
> 
> --- James Mills <prologic at daisy.ods.org> wrote:
> 
> > My program relies on the fact that some fields (which are string
> > types)
> > are null. I'm not sure what to say next so I'll leave it at that :P
> 
> If your database never contains an empty string, then your program
> can rely on the empty strings you retrieve being NULL values in the
> database.

This case is true and the database will never contain empty strings only
NULL values. The program has strict ways of doing this, unless of course
you modify the databases externally, then bam (you're right as per
below)...

cheers
James

> 
> But if an empty string ever crept into a database field, then your
> program would think the field is null when it's not.  If this would
> cause a grevious error, then you should find a better way.
> 
> -Alan
> 
> 
> __________________________________
> Do you Yahoo!?
> SBC Yahoo! DSL - Now only $29.95 per month!
> http://sbc.yahoo.com
> 
> _______________________________________________
> fpc-pascal maillist  -  fpc-pascal at lists.freepascal.org
> http://lists.freepascal.org/mailman/listinfo/fpc-pascal

-- 
-
- James Mills
Zero Defect Software Engineers Group - ZDSEG