how to create a unique Id?
Hi,
my sql command run on NT-based webserver, Sybase is in UNIX. User does not enter "ID", how do I let system to create unique id (ID) when add ( insert ) new data into a table?
====
sql = "INSERT INTO super (" &_
"ID, " &_
"Datevintage, " &_
"Region, " &_
"MapFormat) " &_
" VALUES("
sql = sql & ??? ( read from system, ?? )
sql = sql & Request.Form("txtDateVintage"), & ","
sql = sql & Request.Form("txtRegion"), & ","
sql = sql & Request.Form("txtFormat") & ")"
Any suggestion would be appreciated
Jason
jxiao@sirokygroup.com