Okay. Thank you everyone for the suggestions given thus far. I am SQLite
version 3.15.2 if that's of import.
Know all that the whole database project is on-line here: ky8d.net/sql
As for the suggestion to 'normalize' my four tables to one ... yes, I
could do that ... but it would make for a LOT of redundant data
duplicated in plural columns, which seems to me in my doubtless ignorant
newbie status, as missing the point for a database. Wouldn't that would
make it just one big flat file? As countries have a name, a 2-letter ISO
code and a 3-letter UN code, that would be 50 redundant column entries
for the USA, 31 for Mexico and 16 for Canada. So from the start, I
thought to make it an exercise in avoidance of ANY redundant storage
wherever I possibly can. So that's my reason, such as it is.
Anyhow, Ryan Smith's reply is most to the point. Thank you, Ryan,
especially in that regard. That answer touches on areas of SQLite which
I am wanting to learn. I'd really like to get it working.
I do get a syntax error near CASE in the trigger from Ryan's example. It
is curious, as I have before tried using CASE in triggers and always
they seem to flag syntax errors. Might someone have a clue on that?
--
Mistera Sturno - Rarest Extinct Bird
<(+)__ Ĝan Ŭesli Starling
((__/)=- Holland, MI, USA
`||`
++ http://starling.us
http://esperanto.us
http://ky8d.net
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
