Re: [U2] Multiple UniData Indexes in same select

2012-11-08 Thread Wols Lists
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

Re: [U2] Multiple UniData Indexes in same select

2012-11-07 Thread David A. Green
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

Re: [U2] Multiple UniData Indexes in same select

2012-11-07 Thread Wally Terhune
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

Re: [U2] Multiple UniData Indexes in same select

2012-11-07 Thread Dave Laansma
-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

Re: [U2] Multiple UniData Indexes in same select

2012-11-07 Thread Israel, John R.
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

Re: [U2] Multiple UniData Indexes in same select

2012-11-07 Thread Wally Terhune
.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

Re: [U2] Multiple UniData Indexes in same select

2012-11-07 Thread Wjhonson
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

Re: [U2] Multiple UniData Indexes in same select

2012-11-07 Thread Wjhonson
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

Re: [U2] Multiple UniData Indexes in same select

2012-11-07 Thread Doug Farmer
, 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

Re: [U2] Multiple UniData Indexes in same select

2012-11-07 Thread Wols Lists
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

Re: [U2] Multiple UniData Indexes in same select

2012-11-07 Thread Adrian Halid
...@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

Re: [U2] Multiple UniData Indexes in same select

2012-11-07 Thread dennis bartlett
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.