> At the point where I generate the billing, the index I want in place would > not allow an insert command to duplicate a billing for that > student/class/session. I just assumed unique meant only 1 allowed per > table. > > It's a common misunderstanding. CANDIDATE and PRIMARY keys only allow unique values. UNIQUE are an old remnant of a quirky FoxPro behavior and should NEVER be used.
There's a difference between UNIQUE index in VFP and the SQL standard for a unique index. Here's the latter:
http://stackoverflow.com/questions/487314/primary-key-or-unique-index Maybe that's what Gary is thinking of? Ken Dibble www.stic-cil.org _______________________________________________ Post Messages to: ProFox@leafe.com 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/5.2.1.1.1.20130425211751.01fe7...@pop-server.stny.rr.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.
