MX Kollection Forum :: custom trigger update after insert

This thread was displayed: 0 times


Starting with 17th May 2007, Adobe Systems will stop offering support for any version of the discontinued InterAKT products. As a result, we will not answer to new support incidents starting with May 17th, 2007. Pending support incidents will still be followed in order to be closed. The product forums will remain open and be transformed in user-to-user forums. The general forums will be made read-only and not allow new posts or comments.

For more information about the affected products visit: www.interaktonline.com/Support/

View Threaded Show descending
Doug R.
01-20-2009 22:12:50 GMT +2

Scenario: The user fills out form one of four. on the first form, I use the insert into two tables wizard, inserting all values plus the userid, while getting the identity of that record using a custom trigger, and then inserting the userid and the identity into the second table. that works fine.

On the second form, i need to insert a record into a new table including the userid, get the identity as before, and then UPDATE the record created in the second table during step one with the identity of the second insert.

So what would my custom update code for the second table look like using asp vbscript on the second step?

Back | Reply | Quote | Top
© Adobe Systems Romania. All rights reserved.