Re: Non-Unique Index For An SQL Table File -- MIDRANGE-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

Hey Robert

Look for the word PRIMARY or UNIQUE in the CREATE TABLE documentation for constraints - that's how you get an unique index - preferable to use PRIMARY. Name can be generated, as you don't really care, probably.

HTH
Vern

RWMunday wrote:

Greetings from the sunny beaches of Florida.

Our prime directive in creating files at the client site is to use SQL
Tables and SQL Indexes. I was presented with a change to some programs
which made it necessary for me to have a key on an SQL Table originally
built without a key. A separate SQL Index over the SQL table works great
and prevents duplicate key errors. For that reason I cannot key the
original file. I have found no viable option for specifying a non-unique
key inside of an SQL table.

Is there a way to build a keyed table with a non-unique key? I tried
IGNORE_DUP_KEY without success. There has to be a combination which works
within the SQL table. My key consists of two fields in which identical data
can appear in the file multiple times.

Thanks,

Robert Munday
Munday Software Consultants
Montgomery, AL
on assignment in Jacksonville, FL

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.