[sqlite] fill blank fields

= '*' where (CN = '' or CN is null) and AT='xyz';mtia Mark CDN Mark wrote: > what I need to do is replace blank fields in a specific row, sort of > a double where where statement as in: > > UPDATE Aircraft SET CN = '*' where CN = '' or CN is null where (primary key) > is xyz UPDATE

[sqlite] fill blank fields

hi there, thanks Simon and Igor for your help on this a few weeks ago, but I need an addition to UPDATE Aircraft SET CN = '*' where CN = '' or CN is null; what I need to do is replace blank fields in a specific row, sort of a double where where statement as in: UPDATE Aircraft SET CN = '*'

[sqlite] fill in blank fileds

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] fill in blank fileds

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

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

[sqlite] database question

Hi, newbie question, what I'd like to do is improve/add columns for a sadly lacking database for a commercial proramme. What I'd like to know is it possible to add columns to an existing database without causing problems, add extra info into these columns, and then somehow create a viewer of

[sqlite] append sql file

thanks Igor, that works, but without the period at the end, as in */ Mark ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] append sql file

Hi, was wondering if there was a way to have extra text on the end of an sql file, after the COMMIT; ? I'd like to combine two functions onto the one file, the text would be read by another programme, but how can I tell SQLite to ignore what's after the COMMIT mtia Mark

Re: [sqlite] output problem

priveledges they may not > be able to write to the root of C: drive. > > Michael D. Black > Senior Scientist > Northrop Grumman Mission Systems > > > ____ > > From: sqlite-users-boun...@sqlite.org on behalf of CDN Mark > Sent: Wed 6/2/2010 6:4

Re: [sqlite] output problem

thanks Simon, that worked, why is this? and if I wanted to send this to someone else and it had the // would it NOT work for them? Mark - Original Message - From: "Simon Davies" To: "General Discussion of SQLite Database"

[sqlite] not all delete commands completed

Hi there, am trying to run an sql file of DELETE commands, but not totally successful. Of the 43, only 30 deleted from the database on the first try, second time 10 more, third time 2 more, one wouldn't delete. Was wondering if the format mattered in that the commands were in 43 continous