Joerg Fernow
going with the flow Posts:48
|
12-06-2011 04:01 AM |
|
Hi,
We have a form with 3 completion events. Events 1 and 2 are dynamic sql-statements and completion event 2 generates some values using IDENT_CURRENT('tablename'). This value holds the ID of the inserted record set.
Is there a way to use this value for a dynamic mail? I would like to mail the ID of the inserted record set.
Thanks
Jörg |
|
|
|
|
Chad Nash Posts:5260
|
12-06-2011 04:07 PM |
|
Jörg, There are new features that we are adding into the latest release and plan to have a tutorial added. Something where you can always reference the Previous SQL or HTTP Post event "Returned Value" in the net event or SQL post. You could always use one SQL Event Select Scope_Identity() Are you familiar with this? Thanks, Chad |
|
|
|
|
Joerg Fernow
going with the flow Posts:48
|
12-08-2011 09:57 PM |
|
Hi Chad,
thank your for your support. Yes, that's the way, I solved this. But it would be nice to have this feature inside the module, as a token or parameter.
Best,
Jörg |
|
|
|
|
Chad Nash Posts:5260
|
12-09-2011 11:41 AM |
|
Hi, Yes we have actually added this feature now but hope to have this showcased in a new demo / user guide we are working on. Thanks, Chad
|
|
|
|
|