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?
_______________________________________________ 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/[email protected] ** 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.
