Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Re: [TheStone] Primary Key

Quote Reply
Re: [TheStone] Primary Key In reply to
When you say double check on field and table name..what do u mean? Well, I went online to check if the command syntax was correct and everything looks good. I also checked if I am inserting the correct field and table name and that looks good also

ALTER TABLE customerCases CHANGE recordno recordno INT NOT NULL AUTO_INCREMENT

...but still getting the same message.

Rows affected: -2

Is there any other way to do this?
Reena
Subject Author Views Date
Thread; hot thread Primary Key jai 12037 Mar 4, 2002, 4:04 AM
Thread; hot thread Re: [jai] Primary Key
Paul 11822 Mar 4, 2002, 6:36 AM
Thread; hot thread Re: [RedRum] Primary Key
jai 11852 Mar 4, 2002, 3:42 PM
Thread; hot thread Re: [jai] Primary Key
604 11862 Mar 4, 2002, 3:54 PM
Thread; hot thread Re: [TheStone] Primary Key
jai 11812 Mar 4, 2002, 4:51 PM
Thread; hot thread Re: [jai] Primary Key
604 11777 Mar 4, 2002, 4:58 PM
Thread; hot thread Re: [TheStone] Primary Key
Reena0330 11466 Aug 9, 2002, 1:48 PM
Thread; hot thread Re: [Reena0330] Primary Key
604 11551 Aug 9, 2002, 1:59 PM
Post; hot thread Re: [TheStone] Primary Key
Reena0330 11506 Aug 9, 2002, 2:10 PM
Thread; hot thread Re: [TheStone] Primary Key
Reena0330 11483 Aug 9, 2002, 2:19 PM
Thread; hot thread Re: [Reena0330] Primary Key
604 11518 Aug 9, 2002, 2:33 PM
Thread; hot thread Re: [TheStone] Primary Key
Reena0330 11467 Aug 9, 2002, 2:45 PM
Thread; hot thread Re: [Reena0330] Primary Key
604 11472 Aug 9, 2002, 2:55 PM
Thread; hot thread Re: [TheStone] Primary Key
Reena0330 11460 Aug 9, 2002, 3:20 PM
Thread; hot thread Re: [Reena0330] Primary Key
604 11464 Aug 9, 2002, 3:27 PM
Thread; hot thread Re: [TheStone] Primary Key
Reena0330 11536 Aug 9, 2002, 3:32 PM
Thread; hot thread Re: [Reena0330] Primary Key
604 11458 Aug 9, 2002, 3:37 PM
Thread; hot thread Re: [TheStone] Primary Key
Reena0330 11437 Aug 9, 2002, 3:52 PM
Thread; hot thread Re: [Reena0330] Primary Key
604 11501 Aug 9, 2002, 4:14 PM
Post; hot thread Re: [TheStone] Primary Key
Reena0330 11444 Aug 12, 2002, 11:02 AM