Boomer-Goonies
|
Posted: 02/17/2004, 4:34 AM |
|
How to get the autoincremented value in to my Variable "Nyservicenr"
In my OPERATION METHOD i will add the "Nyservicenr" to my redirect, but i cant get the value.
If PressedButton = "Button_Insert" Then
If NOT Button_Insert.OnClick() OR NOT InsertRow() Then
Redirect = ""
Else
'KHO Add/Changes
Redirect = "servicenew_maint.asp?servicenr=" & Nyservicenews
I want to go to the recordform with the newly entered data, insted of going to the "normaly" records list.
THX for any help.
|
|
|
DonB
|
Posted: 02/17/2004, 2:23 PM |
|
The connection that does the insert will have the value available for you to
retrieve with a second query. Here's the how-to:
http://www.gotodon.com/ccbth/Features/Kbase.asp?find=autonumber
--
DonB
http://www.gotodon.com/ccbth
"Boomer-Goonies" <Boomer-Goonies@forum.codecharge> wrote in message
news:640320a5335578@news.codecharge.com...
> How to get the autoincremented value in to my Variable "Nyservicenr"
>
> In my OPERATION METHOD i will add the "Nyservicenr" to my redirect, but i
cant get the value.
>
> If PressedButton = "Button_Insert" Then
> If NOT Button_Insert.OnClick() OR NOT InsertRow() Then
> Redirect = ""
> Else
> 'KHO Add/Changes
> Redirect = "servicenew_maint.asp?servicenr=" & Nyservicenews
>
> I want to go to the recordform with the newly entered data, insted of
going to the "normaly" records list.
>
> THX for any help.
>
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|