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 _______________________________________________ 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/[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.

