$sessions

Hi,

> My old timer application consists of multiple libs connecting to multiple native data files. It has grown a lot and I am thinking to go the SQL route.That being said I am already stuck at the very beginning. I can logon to datas and create $sessions :
>
> Do iSessObj.$logon(“Almacen Avila:Data Pruebas:Estu 2008-09.DF1″,,,”DATALICEO2009”) Returns #F
> OK message {[#F]}
> Do iSessObj.$logon(“Almacen Avila:Data Pruebas:Estu 2016-17.DF1″,,,”DATALICEO2016”) Returns #F
> OK message {[#F]}
>
> I can also make a list of the sessions like:
>
> Set current list temp_list
> Calculate #S1 as $sessions.$appendlist(temp_list,$ref.$name,$ref.$pathname,$ref.$shared)
>
> But if I look at the sessions with the SQL Browser, only the second sessions is shown unless I use the open sessions command in the SQL Browser. Can not find the notation nor a command to open and close sessions. Anybody help please.
>
> I also wonder if I am going in the right direction.

Being in about the same position for about 6 years ago, I can share my experience:

SQL is a very smart way to talk to a database. But using OmnisSQL talking to native datafile is adding unnecessary complexity and just delivering the same answer much slower.

If the goal is to increase speed, security, concurrency and expansion. Postgresql etc is the path.

No easy path. But probably the right path.

IMHO

/Mats

_____________________________________________________________
Manage your list subscriptions at lists.omnis-dev.com