check the IDENTITY box of the column you wish to autonumber while in Design
Mode. The first number after that is the seed value and the second is the
step value
___________________________________________
Bryan Love
Director of Development
[EMAIL PROTECTED]
MarketMatrix Inc.
810 3rd Ave
Seattle WA, 98104
206~343~9445
marketmatrix.com
___________________________________________
-----Original Message-----
From: Randy Adkins [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 12, 2000 8:15 AM
To: [EMAIL PROTECTED]
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.
