ahingeveld
|
| Posted: 05/02/2003, 6:20 AM |
|
I've modified my insert stored procedure to return the auto-incrment primary key of the new record I've inserted. Is there a quick way to use the RETURN_VALUE from a CCS stored procedure parameter list to redirect to a new page? I've noticed that comments regarding RETURN_VALUE use are relatively old and on CCS' wish list.
Array("RETURN_VALUE", "urlRETURN_VALUE", adInteger, adParamReturnValue, 0, 0, 10, Empty, Empty), _
|
|
|
 |
Hamilton
|
| Posted: 05/02/2003, 6:44 AM |
|
In the after insert event for the record place the following code:
Dim NewID
NewID = CCDLookUp("@@IDENTITY", "TableName", "id=@@IDENTITY", DBIntranet)
|
|
|
|
ahingeveld
|
| Posted: 05/02/2003, 11:26 AM |
|
Thanks, that worked great.
|
|
|
|
Robert O'Donnell
|
| Posted: 06/16/2003, 7:40 PM |
|
Anyone know how to do this in VB.NET with SQL Server?
|
|
|
|
|
