Hi Fred, I agree with you but I think that a specific rule could be added in the parser in order to deal with an identifier containing dots only when it is used after a "using" in a "create virtual table" statement... Am I wrong? Anyway, this is not a very big issue :-)
Aladdin > Date: Mon, 5 May 2008 09:59:52 -0500 > From: [EMAIL PROTECTED] > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Virtual tables declaration statements > > Don't think that will happen. "Dot" notation is used as in > "databasename.tablename" and is therefore a restricted use notation. > > Fred > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Aladdin Lampe > Sent: Monday, May 05, 2008 8:57 AM > To: sqlite-users@sqlite.org > Subject: [sqlite] Virtual tables declaration statements > > > > Hi list! > > I've just finished a set of sqlite3 virtual tables and I would like to name > them with a "dot notation", ie "data.source1", "data.source2" created like > that: > sqlite3_create_module(db, "data.source1", &dataModule1, 0); > sqlite3_create_module(db, "data.source2", &dataModule2, 0); > > ... and then use the following calling convention: > create virtual table tab1 using data.source1(arg1, arg2); > create virtual table tab2 using data.source2(arg1, arg2, arg3); > > ... but the parser claims a syntax error near "." :-( > > Note that the following three notations just work, but I find them a bit > weird and not very user-friendly: > create virtual table tab1 using 'data.source1'(arg1, arg2); > create virtual table tab1 using "data.source1"(arg1, arg2); > create virtual table tab1 using [data.source1](arg1, arg2); > > Is there any chance that this would be solved in a future version of SQLite, > ie considering adding the "." to the authorized characters in an identifier > following the key word "using"? > > BTW, I do not see lots of virtual tables out there. I find it's a really > great and distinctive feature and I think that, following the recent > tutorial ideas, our SQLite community should set up a sharepoint with users > contributions (just like the "/contrib" area, but in a more user friendly, > collaborative and "visible" way). Same thing for user-defined functions, > aggregates, collations... > That would help people starting with sqlite and allow us to build some > useful tools/examples that everybody could use or inspire of... > > Have a nice day, > Aladdin > > _________________________________________________________________ > Retouchez, classez et partagez vos photos gratuitement avec le logiciel > Galerie de Photos ! > http://www.windowslive.fr/galerie/ > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _________________________________________________________________ Avec Hotmail, vos e-mails vous suivent partout ! Mettez Hotmail sur votre mobile ! http://www.messengersurvotremobile.com/?d=hotmail _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
