Ian Hardingham <[email protected]> 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. It's not even clear to me what you are trying to achieve here. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
