Win a copy of Cross-Platform Desktop Applications: Using Node, Electron, and NW.js this week in the JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

WMB ESQL and DB question  RSS feed

Alexander Johnson
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am intentionally trying to insert on top of a previously entered
row to see how to handle exceptions

I sent the following command in ESQL

This works the first time, but the second time through the code
throughs an exception, and goes out the Failure terminal, where I
can see it in the Trace node

When I UN-CHECK the "Throuw exception on Database error", the flow
no longer throws an error, the output routes through the "Out" terminal

The first time through (on an empty table, successfull insert, the
trace shows:

On the second time through (bad insert cmd trying to overwrite a record),
it agains goes through the 'out' terminal, and the trace node shows:

In the first case I see a local env, but not the "Ret" I was trying to
write to

In the second case I do not see a local env of any sort

SInce both cases do not show a RET, I can not test ret inside of ESQL to
determine if the INSERT completed successfully

How can I do this ?
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!