Connect to database.
Call a special stored procedure that will set some database session variables that are required
do what we need to do...
Disconnect from database.
When I run that exact same app on Powerserver Web (Or Mobile), it do not work in certain area
specially when a datawindow access a store procedure. I found out that the variables set by the
special store procedure mention earlier are now NULL for some reason. The only thing I can think
of is that even if I connect to the database on my own Powerserver seem to disconnect and re-connect
within my transaction and because of this the session variable are lost and my functions and
procedures within the database now collapse.
I made sure that the following was configure:
PowerServer toolkit configuration
Application profile (configuration)
The check box for 'Start transaction when executing stored procedures' is OFF/Disabled
Can anybody point me in the right direction/documentation...