×
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.
Basically, a non-unique Key implies that there is no real way to retrieve a
specific record, if duplicate keys exist. The way I like to think of it is
that if you have 2 records with the exact same keys, one had to have been
added to the file before the other. So why isn't there a timestamp (or a
sequence number) to make a uniue key? All the functionality is still in
place, but now every record can be retrieved specifically.
Bill
-----Original Message-----
From: Jeff Crosby [
mailto:jlcrosby@xxxxxxxxxxxxxxxx]
Sent: Thursday, July 05, 2007 2:49 PM
To: 'Midrange Systems Technical Discussion'
Subject: RE: SQL Table with non-unique key - possible?
That's the way the DDS file was created.
If it can't be done in SQL, then I'll create a nonkeyed table, along with an
non-unique keyed index.
I just thought it odd that it could not be done in SQL. But I did a lot of
searching and came up with no examples.
midrange.com
