A fellow programmer passed this link on to me. It was helpful in the
migration to SQL server.
http://www.pinpub.com/foxtalk/ft9902i/ft99b20.html
It actually compares Fox Pro dbases w/ SQL server (I came from Access too),
but it is helpful nonetheless. Although I don't think it answered your
original question, but I believe Jon Hall already did. A little elaboration:
Datatype: Int, Identity Seed: 1, Identity Increment: 1, and of course,
Identity checked as Jon pointed out.
That will do it. The only other parameters you may want to adjust are the
length and precision. I'm actually not certain the difference when it comes
to INT types, since precision doesn't really apply, but someone else may be
able to answer that one.
Rgds.
-Bill
/intraget
----- Original Message -----
From: AustralianAccommodation.com Pty. Ltd.
<[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Saturday, October 28, 2000 11:50 PM
Subject: New To Sql From Access
> How do I set up sql field names to be equivalent to autonumber field names
> in access
>
>
> Kind Regards
>
> Claude Raiola (Director)
> AustralianAccommodation.com Pty. Ltd.
> Website: www.AustralianAccommodation.com
> Email: [EMAIL PROTECTED]
>
> --------------------------------------------------------------------------
----------------------
> Archives: http://www.mail-archive.com/[email protected]/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
>
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
