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 g.jeurink@charter.net 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]