Thanks Pete, I received some advice off list that convinced me to not risk pushing the bounds of SQLite in this fashion, but URI filenames should be part of the updated SQLite support, nonetheless.
Michael On 3/11/14, 1:02 PM, "Peter Haworth" <[email protected]> wrote: >Hi Michael, >I just verified that URI filenames don't work in LC v6.6 and have filed >bug >report # 11919. > >Pete >lcSQL Software <http://www.lcsql.com> >Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and >SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html> > > >On Tue, Mar 11, 2014 at 7:41 AM, Michael Gruenthal ><[email protected]>wrote: > >> I¹m interested in having a small (<20) number of users simultaneously >> connected to an sqlite DB on a shared network drive as an alternative to >> hosting on a server. I found some old (2010) discussions about this >>without >> a clear answer. I¹m wondering if sqlite share-cache mode will permit >>this. >> I >> have a very rudimentary understanding of SQL so perhaps I¹m >> misunderstanding >> what shared-cache mode does, but I¹m hoping that the upgraded sqlite >> support >> in LC 6.6 in combination with shared-cache mode will allow at least a >> limited number of concurrent connections. >> >> If so, does anyone know if there¹s a way to use revOpenDatabase() to >>open a >> connection with shared-cache mode enabled? If I understand correctly it >>is >> disabled by default. Thanks. >> >> Michael >> >> >> _______________________________________________ >> use-livecode mailing list >> [email protected] >> Please visit this url to subscribe, unsubscribe and manage your >> subscription preferences: >> http://lists.runrev.com/mailman/listinfo/use-livecode >> >_______________________________________________ >use-livecode mailing list >[email protected] >Please visit this url to subscribe, unsubscribe and manage your >subscription preferences: >http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
