Setting up SQLite

Das Goravani goravanis at
Thu Sep 3 22:02:37 EDT 2020

I haven’t done anything with paths Mike or I’d pass it along. I put it right with my library and for me the path never changes. Its always sys(11) or some variation of it. I make the path ahead of time like as below

Do $root.$sessions.SLSESSION.$logoff()
Do $root.$sessions.SLSESSION2.$logoff()

Calculate lSessionName as 'SLSession'
Calculate lHostname as replace(low(sys(10)),'.lbs','_SL.db')
Calculate lUsername as ''
Calculate lPassword as ''
Do $ctask.tsessobj.$opencreate.$assign(kTrue) Returns #F
Do $ctask.tsessobj.$logon(lHostname,lUsername,lPassword,lSessionName) Returns lflag
Do $ctask.tsessobj.$newstatement('SLStaObj') Returns $ctask.tstaobj

lHostname holds the path and you can make that however you want as you can see I am doing… seems to me you ought to be able to make that path anything you want it to be. 

Maybe I’m not understanding the problem. 

> On Sep 3, 2020, at 4:23 PM, Mike Rowan <michael.rowan3 at> wrote:
> Another easy question.
> Am attempting to set up a small SQLite database to store startup data on
> each workstation.
> But SQLite seems to demand an absolute posix path which will be different
> for each machine/user.
> Can I include square-bracket stuff in the proposed path? Doesn't seem to
> work for me.
> Thanks, anyone.
> _____________________________________________________________
> Manage your list subscriptions at
> Start a new message -> mailto:omnisdev-en at 

More information about the omnisdev-en mailing list