jose isaias cabrera wrote:
sqlite> select * from LSOpenJobs where id = '166';
166|166|1172158922388||us|MER|3.0 Cards|Technical|
Project|2007-02-21|2007-02-21|2007-02-22|318||en2es,en2br||karina|||klmLD|D:\Projects\166||||||c
the last column is the status, which has the value c and the previus
column is notes,
which is empty or null.
This is the heart of your problem, empty is *not* the same a null.
Null is an unknown or unspecified value, an empty string is a very well
defined string with a length of zero.
The command line shell displays null values as empty strings by default.
You can have the shell display an arbitrary string for null values to
make then visible. Try this before your command
.nullvalue '<null>'
now you can see the difference between null values and empty strings
select 'test', '', null;
test||<null>
After you have convinced yourself that your database contains empty
strings, you can use the same techniques discussed previously to update
the empty strings with your desired values.
HTH
Dennis Cote
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------