grivers
Posts: 28
|
Posted: 08/26/2009, 3:41 AM |
|
Hi,
I am trying to insert a new record in a form and then immediatley update the same record on the next page. To do this I assume I need to insert some code to retrieve the record ID after an insert and then somehow pass it to the new update form on the next page.
Do you know how I can retrive the ID of the record when entering a new record on a form?
Then retrive it so straight away to edit the form?
|
|
|
Oper
Posts: 1195
|
Posted: 08/26/2009, 3:21 PM |
|
grivers,
every database have his way to get teh last id etc LAST_ID() lastRecordPointer(), etc
that easy way an work for all database without any posible fail in multi enviroment
during the insert, insert also a field named like UNIQUECODE
and assign a know value like DATE-USERID-Random(10) ej: "20090826141859-1-019982
and just get that record with that code back.
we have used that approach always.
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
grivers
Posts: 28
|
Posted: 08/27/2009, 1:12 AM |
|
Thanks.
|
|
|
TamaraLG
Posts: 8
|
Posted: 10/13/2009, 11:00 AM |
|
Could you explain how and where you would enter the unique code? How would you recall the code on the next page if it is unique?
|
|
|
|