email parsing automation

Email Parser

Extract data from emails and automate your workflow

The forum is now read only. Please, go to the the main Email Parser website if you need help.
Post here if you experience problems or get unexpected errors.
is there a way to grab a number from an SQL database, put it in a variable and then add 1 (so I get the next number to write back into the database)?

I can grab the number with a select....where statement but how to proceed from there. Tried the static fields but they give me "number +1" literately.

You mean something like this?

Select coalesce(Max(erecid),0)+1 as wrecid from emlfxa7.temlmsg

wrecid is static field...

yes that is what I'm looking for! Thanks!