Re: auto_increment not incrementing

2001-07-12 Thread Mike Mike
ke" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, July 12, 2001 5:18 > Subject: auto_increment not incrementing > > > > Hello, > > When I submit data it will not submit data into > the > > database unless I put some kind of num

RE: auto_increment not incrementing

2001-07-11 Thread Chris Bolt
What error did you get? Did you try using NULL for the id, or leaving the auto_increment column out of the insert (insert into table (PartNumber, ..., StatusQtyWorked) values (...))? > Hello, > When I submit data it will not submit data into the > database unless I put some kind of number in the

Re: auto_increment not incrementing

2001-07-11 Thread Rolf Hopkins
In what way doesn't it work? Works fine for me. - Original Message - From: "Mike Mike" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, July 12, 2001 5:18 Subject: auto_increment not incrementing > Hello, > When I submit data it will no

auto_increment not incrementing

2001-07-11 Thread Mike Mike
Hello, When I submit data it will not submit data into the database unless I put some kind of number in the ID field. This is not supose to be. Here is what my schema looks like. CREATE TABLE Parts( PartNumber INT(6) NOT NULL, QtyOnHand INT(2) NOT NULL, QtyOnOrder INT(2) NOT NULL, DateNextQtyCo