I am writing a powerbuilder app that needs a second transaction object.
The connect string is supplied via an ini file.
The Transaction object works fine until I add code to update a datawindow that belongs to the SQLCA object that has been modified in a prior script. I need to update this datawindow before I can do the work associated with the following transaction object.
If the datawindow update code is commented out, the creation of the trans obj works fine.
The code dies in "of_init" by returning the -1 from the following ----
if IsNull (as_inifile) or IsNull (as_inisection) or &
Len (Trim (as_inifile))=0 or Len (Trim (as_inisection))=0 or &
(not FileExists (as_inifile)) then return -1
The offending code looks like this ----
ll_save_dw_return = dw_fix_names.update() <-- This belongs SQLCA and was modified in a prior script
If ll_save_dw_return <> 1 Then
MessageBox("Error",'Changes to names failed because ' + sqlca.SQLErrText )
NameDB = Create n_tr
ls_inifile = gnv_app.Of_GetAppIniFile( )
If NameDB.Of_Init(ls_inifile, "NameBase") = -1 THEN
li_messagebox_response = MessageBox('Transfer File', 'The connection to the Name DataBase Failed -- Notify Systems!')