If you're using MS SQL Server, just set up your key field as an identity
type. That will give you the same functionality as the Access autoincrement
data type.
Rey...
Certified Allaire Instructor
Member of Team Allaire
"A browser's beauty, at its heart, is its usefulness as a *TOOL*."
----- Original Message -----
From: "Randy Adkins" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 12, 2000 11:15 AM
Subject: SQL ID
> Anyone know how to input a unique id within an SQL database?
> I have a field called Client_ID as uniqueidentifier and do NOT allow NULLS
>
> but it will not insert the ID as MS Access does.
>
> Thanks in advance.
>
>
> --------------------------------------------------------------------------
----
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
