Re: [sqlite] columnb = upper(columna)

2010-06-23 Thread Nick Shaw
>> Ian Hardingham wrote: >>> I'm just getting around to this. Can I do: >>> >>> ALTER TABLE userTable ADD upperName = upper(name) TEXT >>> >>> Will this retroactively and for all future inserts work? >> >> This is not a valid syntax, so it won't work - neither retroactively, in the present, no

Re: [sqlite] columnb = upper(columna)

2010-06-23 Thread Simon Slavin
On 23 Jun 2010, at 12:53pm, Igor Tandetnik wrote: > Ian Hardingham wrote: >> I'm just getting around to this. Can I do: >> >> ALTER TABLE userTable ADD upperName = upper(name) TEXT >> >> Will this retroactively and for all future inserts work? > > This is not a valid syntax, so it won't work

Re: [sqlite] columnb = upper(columna)

2010-06-23 Thread Igor Tandetnik
Ian Hardingham wrote: > I'm just getting around to this. Can I do: > > ALTER TABLE userTable ADD upperName = upper(name) TEXT > > Will this retroactively and for all future inserts work? This is not a valid syntax, so it won't work - neither retroactively, in the present, nor in the future. I

[sqlite] columnb = upper(columna)

2010-06-23 Thread Ian Hardingham
Hey guys. I'm just getting around to this. Can I do: ALTER TABLE userTable ADD upperName = upper(name) TEXT Will this retroactively and for all future inserts work? Thanks, Ian ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org: