Why not add field, fill in keys them set index and add index ----- Original Message ----- From: "Stephen Russell" <[email protected]> To: "ProFox Email List" <[email protected]> Sent: Thursday, December 02, 2010 2:56 PM Subject: Re: VFP9 - Duplicates
> On Wed, Dec 1, 2010 at 5:39 PM, Sytze de Boer <[email protected]> > wrote: >> I have a client who has asked me to add a field to a table >> The app is very old, but works a charm >> (I think they are using sql to access the free standing table) >> >> They have asked for a Character field, 32 chars >> THE FIELD MUST NOT ALLOW DUPLICATES > --------------- > > After you put in the new column they will all be dupes. empty() > What are you going to do to stop that so you can index for uniqueness? > > > > -- > Stephen Russell > > Sr. Production Systems Programmer > CIMSgts > > 901.246-0159 cell > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/a87f75db5958407d9d3bf9224ffba...@jerrylaptop ** 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.
