Can I get access to the Sage Session object? (2 replies)
Django, the Sage Session object is only open during the execution of the Sage300 connector (all connectors, irrespective of the application work this way).
At the termination of transform the session is closed....further is you're dynamically targeting the company (using the Company ID/COID field), sessions get opened & for each unique company in the dataset.
I knew that the session object would be closed up. I was just thinking that a script could be run from within the integration to call my VB stub program and inherit your session for a few moments while my macro runs and then let the integration continue once my macro was done.
Mostly I'm trying really hard to avoid tying up lanpaks so IMan and I aren't fighting.
I may just go a step further and set up an Orchid Extender script on a table that I'll have IMan populate at the end of the integration. The script would then run my macro (or re-write my macro as a python script) and I should be able to avoid the lanpak issue that way.
In my quest to find a way to run macros in an automated fashion I've found that using the session object I can create a session handle. Using that session handle I can pass that to a VB program. That VB program can open a session object and inherit the session associated with the session handle.
I figure that if I can get access to that session object and generate that handle then I can pass that off to a VB program to run my code.
Any thoughts?