On 08/11/12 00:47, dennis bartlett wrote:
Once again (I'm a fan of these) the answer is to create a file of composite
keys (FldA * FldB etc) and index that...
The bummer is that the xref file will always be out unless one adds a
'trigger' to each 'to be indexed' file
Are you SURE?
Itypes
It will never use both.
Usually the first index command possible will be used.
Although I believe an EQ will override an index with GE.
David A. Green
(480) 813-1725
DAG Consulting
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
From the Using UniData manual:
Alternate Indexes in UniQuery Statement
Prior to UniData 5.2, only one index was used in the selection criteria of a
UniQuery statement, even if the selection criteria contained more than one
indexed attribute. UniQuery now uses all available indexes when
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally Terhune
Sent: Wednesday, November 07, 2012 11:47 AM
To: U2 Users List
Subject: Re: [U2] Multiple UniData Indexes in same select
From the Using UniData manual
UniData Indexes in same select
From the Using UniData manual:
Alternate Indexes in UniQuery Statement
Prior to UniData 5.2, only one index was used in the selection criteria of a
UniQuery statement, even if the selection criteria contained more than one
indexed attribute. UniQuery now uses all
.rocketsoftware.com
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma
Sent: Wednesday, November 07, 2012 9:54 AM
To: U2 Users List
Subject: Re: [U2] Multiple UniData Indexes in same select
Excellent news
The first one
-Original Message-
From: Doug Farmer dfar...@epicor.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Wed, Nov 7, 2012 6:35 am
Subject: [U2] Multiple UniData Indexes in same select
Good morning,
I should know this, but as the gray gets thicker, some of the
What about Universe?
-Original Message-
From: Wally Terhune wterh...@rocketsoftware.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Wed, Nov 7, 2012 9:05 am
Subject: Re: [U2] Multiple UniData Indexes in same select
No on UniBasic SELECTINDEX statement.
Not sure I'd
, Services and Innovative Solutions
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally Terhune
Sent: Wednesday, November 07, 2012 11:47 AM
To: U2 Users List
Subject: Re: [U2] Multiple UniData Indexes in same select
From
and Innovative Solutions
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally Terhune
Sent: Wednesday, November 07, 2012 11:47 AM
To: U2 Users List
Subject: Re: [U2] Multiple UniData Indexes in same select
...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists
Sent: Thursday, 8 November 2012 3:00 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Multiple UniData Indexes in same select
On 07/11/12 17:18, Wjhonson wrote:
What about Universe?
imho, it just doesn't make
Once again (I'm a fan of these) the answer is to create a file of composite
keys (FldA * FldB etc) and index that...
The bummer is that the xref file will always be out unless one adds a
'trigger' to each 'to be indexed' file
Itypes can then be created to XLATE the data from the specific files.
12 matches
Mail list logo