Database inserts and updates

Aruna_Tata

 Hi,

I have a program that inserts a row into a (custom) database table when it begins to execute. When it finishes execution, it goes and updates this row with some information.

During execution, if someone tries to run the program again, it checks the db to see if it is already running. If it is, then it displays an error message to the user.

My problem is this - the debugger shows that the row was inserted successfully but I am not able to see it in the database.  I can also see the error message telling me that the program is already running - how is this possible? What am i missing here?

We are currently running LL9.7.1 on an oracle database. Is there a commit that I need to execute on inserting the row?

Please advise.

Thanks,

Aruna

Keit Kivisild

Hello,

i use start transaction and end transaction functions

Boolean ok = true

if !dbConnect.StartTrans()
  ok = FALSE
  echo( [WebNode_ErrMsg.CouldNotStartATransactionToCreateThe1Item] )
end

if ok
  
  dbResults = CAPI.Exec( LLConnect, insertStmt )
   
  dbConnect.EndTrans( ok )

end

But you have to be careful ending transaction if you use existing program context. May be there are other calls before and after your call. Some times it makes sence to create own db connection.

regards,

keit