Re: [sqlite] fill in blank fileds

2010-12-23 Thread Simon Slavin
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

[sqlite] fill in blank fileds

2010-12-23 Thread Mark
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

[sqlite] fill in blank fileds

2010-12-22 Thread CDN Mark
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

Re: [sqlite] fill in blank fileds

2010-12-22 Thread Igor Tandetnik
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

[sqlite] fill in blank fileds

2010-12-22 Thread CDN Mark
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

Re: [sqlite] fill in blank fileds

2010-12-22 Thread Igor Tandetnik
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

Re: [sqlite] fill in blank fileds

2010-12-22 Thread Simon Slavin
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

[sqlite] fill in blank fileds

2010-12-22 Thread CDN Mark
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