Hi,
looking for help please. Database is a db3, fields are varchar. The problem
is that a necessary updating service for this database looks for 'blank'
fields, of which there are many, and if there are any, updates ALL the info for
that record. The problem is that I want to update with cor
Hi Simon,
ran the first example, came back with lots of lines, second test with the just
the 10 returned
9 lines as 0: the second line as 2:3832, don't understand the purpose/meaning
of this
Hi Igor,
not checking for, want to fill in/replace blank or null fields with at least
one character
_
Hi Igor,
worked using SQLite Database browser/execute SQL but didn't work using an .sql
file which is the way I would be doing it. Tried it again and it did work
using sql file, thanks for your help
___
sqlite-users mailing list
sqlite-users@sqlite.
Hi Simon,
ran the first example, came back with lots of lines, second test with the just
the 10 returned
9 lines as 0: the second line as 2:3832, don't understand the purpose/meaning
of this
Hi Igor,
not checking for, want to fill in/replace blank or null fields with at least
one character
On 22 Dec 2010, at 11:55pm, CDN Mark wrote:
> I tried using a statement
> UPDATE Aircraft SET CN = "*" where CN = "";
> as a test which worked, but not for all records. I don't know if the blank
> fields are empty or null
Do a
SELECT length(CN),hex(CN) FROM Aircraft
if that produces too many
On 12/22/2010 6:55 PM, CDN Mark wrote:
> I tried using a statement
> UPDATE Aircraft SET CN = "*" where CN = "";
> as a test which worked, but not for all records. I don't know if the blank
> fields are empty or null
I'm not sure I understand the problem. If you are asking how to check
both for
On 12/22/2010 7:25 PM, CDN Mark wrote:
> Hi Igor,
>
> not checking for, want to fill in/replace blank or null fields with at least
> one character
So, does the statement I've shown not do this? Here it is again:
UPDATE Aircraft SET CN = '*' where CN = '' or CN is null;
In what way does it fail
On 23 Dec 2010, at 12:19am, Mark wrote:
> ran the first example, came back with lots of lines, second test with the
> just the 10 returned
> 9 lines as 0: the second line as 2:3832, don't understand the
> purpose/meaning of this
If that's 2 in the first column then those fields which you thi
8 matches
Mail list logo