|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
October 8th, 2003, 01:39 PM
|
|||
|
|||
Unique ID
Unique Id
I need help with some asp code that would allow me to grab the last record id and add one to it for the new record being inserted. I am new to asp and have been banging my head up against the wall trying to get this to work. I am currently using Visual FoxPro 6 for my database. The SQL statement I am trying to use is: strSQL = "SELECT Max(contact_id) FROM CustomerContact;" Any help would be wonderful
|
|
#2
October 8th, 2003, 07:24 PM
|
|||
|
|||
|
hi jsteiner87,
i'm not sure if your VF6 has an autonumber field, if it has then u set your contact_id as autonumber. that wud b easier.
__________________
Hope this helps. Mike Royal Selangor Pewter "I have not failed. I've just found 10,000 ways that won't work." - Thomas Alva Edison (1847-1931)
|
|
| Viewing: Dev Shed Forums > Programming Languages - More > ASP Programming > Unique ID |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
