[fpc-pascal]SQLite and NULL Strings...
Alan Mead
cubrewer at yahoo.com
Tue Jul 15 17:35:44 CEST 2003
--- 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.
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
More information about the fpc-pascal
mailing list