$sessions

Hi Juan,

It looks like you are trying to change the way you talk to your Omnis datafiles into SQL.
I assume that your plan is to go through the application, changing all the Omnis DML commands like ‘Find’, ‘Next’, etc into SQL.
I can see that this would be a massive task if your application is large.
You will have multiple Omnis SQL sessions, each one to a separate datafile.
When you move to SQL, will you still want multiple SQL sessions?
Would you prefer to end up with a single SQL database, containing all your data, and for your application to have a single session to it?

Regards,
Gav

> On 26 Aug 2017, at 01:30, Juan Bofill <juanbofillaba@gmail.com> wrote:
>
> Hi all
>
> 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.
>
> Thanks in advance!
> _____________________________________________________________
> Manage your list subscriptions at lists.omnis-dev.com

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