- Louis Arena
- PowerServer
- Friday, 30 December 2022 05:18 PM UTC
Has anyone noticed that the Debug in Powerserver is a little wonky? I just upgraded to the latest release build 1892 and I am still having the same issue. I am trying to debug a weird problem I am having so I setup a quick test event for me to debug. See the code below.
integer i
Transaction SQLCC
SQLCC = Create Transaction
f_copy_tran(sqlcc) /* copies all transaction parameters */
SQLCC.logid = 'sa'
SQLCC.autocommit=TRUE
SQLCC.logpass = [sa password]
DISCONNECT USING SQLCC;
CONNECT USING SQLCC;
// must grant the user access to login functions so they can change their password on SQL 2008 and above 2014-12-30
// this procedure must exist in the MASTER database because server permissions can only be set there
i = pos(SQLCC.DBParm, "Database")
SQLCC.DBParm = left(SQLCC.DBParm, i - 1)
SQLCC.DBParm = SQLCC.DBParm + "Database='master'"
SQLCC.database='master'
DISCONNECT USING SQLCC;
CONNECT USING SQLCC;
In debug I want to see if SQLCC connects properly. However in debug for Powerserver I do not see the SQLCC transaction! Before you ask, yes SQLCC is defined in advance section of the Database tab for the my cloud project. Additionally, the original code does work for SQLCC, it is just when I try and change databases that I am having a problem and therefore wanted to debut it.
Thanks
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.