Hi List, Thanks for the responses. I don't think TCL will work for me - I want to use less languages, not more.
As to the structure - I am considering using ATTACH as a method, but haven't gotten to the point where I need to decide which of the three options (keys in tables, table sets, or separate ATTACHed databases) to use. I think personally I prefer the logical separation of the ATTACH method but haven't fully looked into it yet. Cheers, Jonathan On 30 July 2014 07:00, Noel Frankinet <noel.franki...@gmail.com> wrote: > There a tcl binding to sqlite, maybe it could help you ? > > Noël > > > On 30 July 2014 08:44, Sylvain Pointeau <sylvain.point...@gmail.com> > wrote: > > > It is called parameterized view in sqlserver. > > Actually it is extremely useful in order to have a good reusability in > the > > code. > > I was actually missing it in Oracle, although I found a workaround of > using > > the pipelined functions. > > > > Unfortunately, it is missing in sqlite, as well as the merge statement, > > also very useful (insert or replace has just to be avoided) > > > > What I used to make is to use a shell script, and to use sed to replace > my > > variable before executing the script... Far from ideal but it worked ok, > it > > is just annoying because we have to prepare the file first. > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > > > -- > Noël Frankinet > Strategis sprl > 0478/90.92.54 > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- This transmission is intended for the named addressee(s) only and may contain confidential, sensitive or personal information and should be handled accordingly. Unless you are the named addressee (or authorised to receive it for the addressee) you may not copy or use it, or disclose it to anyone else. If you have received this transmission in error please notify the sender immediately. All email traffic sent to or from us, including without limitation all GCSX traffic, may be subject to recording and/or monitoring in accordance with relevant legislation. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
