Re: [sqlite] Indirect Referencing

2011-11-01 Thread Stander, Bertus (Pretoria)
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

Re: [sqlite] Indirect Referencing

2011-11-01 Thread Stander, Bertus (Pretoria)
and no one is waiting for the IT guys and there is no end in sight for enhancement requests! Does it sound familiar? Bertus On 1 Nov 2011, at 10:25am, Stander, Bertus (Pretoria) wrote: > If I create a table as illustrated below. > > CREATE TABLE Testing ( > > ID INTE

[sqlite] Indirect Referencing

2011-11-01 Thread Stander, Bertus (Pretoria)
Good day to you all, I am very inexperienced with SQlite and any help will be appreciated. I want to know if I can use indirect referencing within the SQL language as per SQlite standards. I will give an example. If I create a table as illustrated below. CREATE TABLE Testing ( ID INTEGER