Quick guess is that you do not have auto increment set on your table. When you do that your insert need not send the value for the PK.
Translation is you probably already have a 0 as an ID in the table and you are trying to add another one. On Mon, Apr 11, 2016 at 1:24 PM, Gary <[email protected]> wrote: > For 10 plus years you guys coached me along and everything works well. Then > I took off 3 or so years dabbling with html, php, and mysql. You guys got > me > over the hump trading data between fox-pro and mysql. Somewhere in that > time > I upgraded from VFP-6 to 9 and most everything worked without a burp. Today > I tried to build a new table and I feel like I've forgotten everything... > I'm trying to set up a gradebook for my athletes and my new table won't let > me enter a new record because the field athNo is a Primary index. I am > manually inserting records using ctrl+Y, typing in a unique number and when > I try to leave that record it keeps saying that the index is violated. Very > frustrated... I can change the index to [reg] and it allows append but why > can't I insert a record if the athNo is unique the other way? > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAJidMYKTcbnbEAT6tXLnKUzmqfqDB2zJDpKcdbz=2sS=mvk...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
