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 call a change made at UniData 5.2 in June of 2000 as 'news'. :-)

Wally Terhune
Technical Support Engineer
Rocket Software
4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA
t: +1 720 475 8055 **e: wterh...@rocketsoftware.com **w: u2.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.

However, is there a way to utilize two indexes with the SELECTINDEX command in 
Unibasic?

Sincerely,
David Laansma
IT Manager
Hubbard Supply Co.
Direct: 810-342-7143
Office: 810-234-8681
Fax: 810-234-6142
www.hubbardsupply.com
"Delivering Products, 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 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 processing a 
statement containing selection criteria.Note: You cannot use an alternate index 
with a LIKE clause when the comparative attribute is numeric.

Wally Terhune
Technical Support Engineer
Rocket Software
4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA
t: +1 720 475 8055 **e: wterh...@rocketsoftware.com **w:
u2.rocketsoftware.com



-----Original Message-----
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Farmer
Sent: Wednesday, November 07, 2012 7:35 AM
To: U2 Users List
Subject: [U2] Multiple UniData Indexes in same select

Good morning, 

I should know this, but as the gray gets thicker, some of the old knowledge 
seeps away.

If you have indexes on multiple attributes on a file in UniData AND you include 
both of those indexed attributes in the same Select statement, how does UniData 
know which index to use? Does it use both? Neither?

Thanks in advance,

Doug
--------------------------------------------------------

This e-mail is for the use of the intended recipient(s) only. If you have 
received this e-mail in error, please notify the sender immediately and then 
delete it. If you are not the intended recipient, you must not use, disclose or 
distribute this e-mail without the author's prior permission. We have taken 
precautions to minimize the risk of transmitting software viruses, but we 
advise 
you to carry out your own virus checks on any attachment to this message. We 
cannot accept liability for any loss or damage caused by software viruses. Any 
views and/or opinions expressed in this e-mail are of the author only and do 
not 
represent the views of Epicor Software Corporation or any other company within 
its group.


This message has been scanned for malware by Websense. www.websense.com 
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

 
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Reply via email to