How to Update/Insert on Page Activation

 

Using Begin/End in the SQLExec will get you past the normal PT limitation.

   SQLExec("BEGIN UPDATE PS_PTIAUSERTGTSELS SET DBNAME = '" | &dbName | "' WHERE USERID ='" | %UserId | "'; END;");

     SQLExec("BEGIN INSERT INTO PS_PTIAUSERTGTSELS(USERID, DBNAME) VALUES ('" | %UserId | "', '" | &dbName | "'); END;");