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&#34, & ","
sql = sql & Request.Form("txtRegion&#34, & ","
sql = sql & Request.Form("txtFormat&#34 & &#34"

Any suggestion would be appreciated

Jason

jxiao@sirokygroup.com