Re: [sqlite] Date and age calculations

you Igor for pointing out my redundant nested SELECT statement. Craig Smith cr...@macscripter.net ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Date and age calculations

hose ages are between 11 and 12. Is there any way I can make the SELECT more precise? Thank you very much, Craig Smith cr...@macscripter.net ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Schema design and/or SELECT construction

gt; thinking it also breaks First Normal Form. > > Besides, you can't do database operations on comma separated lists. > If you need a one-to-many (one pic to many keywords) then do it right > and build an actual one-to-many relationship between two tables.

[sqlite] Schema design and/or SELECT construction

hoping to have it all figured out BEFORE I load up the tables with data. (I am actually still scanning images at this stage, but trying to prepare for the next phase.) Thank you very much for your time and consideration. Craig Smith cr...@macscripter.net

Re: [sqlite] Deleting duplicate records

ant, and if so, what is its purpose? Thank you to all the responders; you are the nicest internet contacts I have ever made. Craig Smith cr...@macscripter.net ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Deleting duplicate records

ria of the records now in dup_killer, and then INSERT the records from dup_killer back into talks before DROPPING dup_killer. At this point, I am stuck. Is there an efficient method to do this with SQLite, or should I just use a shell script? Craig Smith cr...@macscripter.

Re: [sqlite] INTEGER PRIMARY KEY and Triggers

on of the odd behavior I am observing. > > >> Does anyone have a solution that both provides AUTOINCREMENT (or a >> reasonable facsimile) to a PRIMARY KEY field and allows the usage of >> triggers on those tables? >> >> Thank you very much. >> >> Craig Smit

Re: [sqlite] INTEGER PRIMARY and Triggers

want the startup table so that the database file can move from machine to machine, and my app will always have the same data and setup. The file will eventually reside on a flash drive, although for development purposes, right now I am keeping it on my desktop(s). Thank you again.

[sqlite] INTEGER PRIMARY KEY and triggers

much. Craig Smith ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users