Wrox Programmer Forums
|
ASP E-commerce As of Oct 5, 2005, this forum is now locked. No posts have been deleted. Please use "Classic ASP Professional" at: http://p2p.wrox.com/forum.asp?FORUM_ID=56 for discussions similar to the old ASP Pro Code Clinic or one of the other many remaining ASP and ASP.NET forums here.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP E-commerce section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old October 8th, 2003, 12:09 PM
Registered User
  
Join Date: Oct 2003
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default Chapter 3 - Database Table
In Chapter 3, Creating the Table - Page 70 - Step 6
The book mentions setting the Identity property to YES and leaving the Identity Seed and Identity Increment as default value 1...

My option for all three is grayed out... I can't edit these properties...

Can you help?


Stinky
 
Old October 8th, 2003, 05:08 PM
planoie's Avatar
Friend of Wrox
  
Join Date: Aug 2003
Posts: 5,407
Thanks: 0
Thanked 16 Times in 16 Posts
Default
In order for a column to be an identity column, it must be a numeric data type, usually an integer.

Peter
 
Old October 8th, 2003, 06:38 PM
Registered User
  
Join Date: Oct 2003
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default
Yes... Peter, thank you... That was it, I mistakenly had the Data Type as "char" not "int" as the book specifies...

Thank You

Stinky





Similar Threads
Thread Thread Starter Forum Replies Last Post
Copying Table From one Database To Anoter Database jayanth_nadig VB Databases Basics 1 June 19th, 2006 02:39 PM
chapter 4 Table 2 alvinsimon BOOK: Beginning PHP, Apache, MySQL Web Development ISBN: 978-0-7645-5744-6 0 November 1st, 2005 10:34 AM
Make Table query : table in Another Database marnik Access 1 March 19th, 2005 12:39 PM




Contact Us - Wrox - Privacy Statement - Top

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.