Thanks Simon, The response I am giving here is to assist others in deciding whether they can use SQlite. I understand Triggers reasonably well as I am using it continuously very successfully. The 1200 tables in the SQlite database has no impact on performance as every transaction executed on a small device like the Trimble is sub-second. The storage space is also no problem as the database is stored on SSD.
I do understand the terms "table" and "row" etc quite well, but must admit I need more good references to sites for valuable and RELIABLE information and EXAMPLES of MORE COMPLEX SQL. Please exclude the www.SQlite.org as I am aware of that site. Hopefully I will still receive more comments and suggestions on the possibilities of "Indirect Referencing" within SQlite. Bertus > That is one aspect. I also want to use minimal triggers to identify > certain abnormalities and perform certain processes. This I want to keep > Central and not writing triggers for all 1200 tables. So key to a > solution I was thinking of is to store table names and field names in a > central table and then reference those tables and those fields > identified as problem areas during the capture process. You will not be able to get SQLite to run triggers stored in tables automatically. And any database which includes 1200 tables will probably work slowly and take up a lot of storage space. I'm not sure you properly understand the SQL terms 'table' and 'row'. It may be that the best thing you can do now is read a beginner's book about SQL just so you understand how it works. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users This email has been scanned for viruses and malware, and automatically archived by Mimecast SA (Pty) Ltd, an innovator in Software as a Service (SaaS) for business. Mimecast Unified Email Management UEM) offers email continuity, security, archiving and compliance with all current legislation. To find out more,contact Mimecast. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
