Re: [sqlite] fill blank fields

2011-01-10 Thread Igor Tandetnik
On 1/10/2011 5:04 PM, CDN Mark wrote: > using this exampleUPDATE Aircraft SET CN = '*' where (CN = '' or CN is null) > and MyPrimaryKey='xyz';can you substitute another column name iso MyPrimaryKey You can substitute any logical combination on any set of columns in Aircraft table. -- Igor Tande

[sqlite] fill blank fields

2011-01-10 Thread CDN Mark
using this exampleUPDATE Aircraft SET CN = '*' where (CN = '' or CN is null) and MyPrimaryKey='xyz';can you substitute another column name iso MyPrimaryKey if the column you wantedto reference to wasn't the primary key, for example the field in a column named AT,as in:UPDATE Aircraft SET CN = '*

Re: [sqlite] fill blank fields

2011-01-09 Thread Igor Tandetnik
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 Aircraft SET CN = '*' where (CN = '' or CN is null) and MyPrimaryKey='x

Re: [sqlite] fill blank fields

2011-01-09 Thread Jean-Christophe Deschamps
>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 = '*' whe

[sqlite] fill blank fields

2011-01-09 Thread CDN Mark
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 = '*' whe