Re: [U2] SELECTINDEX problem Universe 11.1.11

Use BSCAN command. instead of SELECTINDEX.
SELECTINDEX gets exact matches, whereas BSCAN gets you to a starting 
point , then you go forward from there.   You'd BSCAN for MACKE, then 
loop with additional BSCANs until you are past what you care about.

Or execute a SELECT statement:
      SELECT . . . WITH NAME LIKE "MACKE..."
or
      SELECT . . . WITH NAME = "MACKE]"
to get a select list based on the index.     I assume RetrieVe 
effectively does BSCAN behind the curtain.

It depends on whether you want readability or efficiency.
cds
> From: mbeggs [via U2 (UniVerse & UniData)] Subject: SELECTINDEX problem Universe 11.1.11
>
>
>     We are currently running UV 11.1.11 and have come across a problem with SELECTINDEX.  For example if I enter in MACKE for a name should all names starting with MACKE display, including MACKENZIE.  This does not appear to be working properly.  According to Rocket they say there was a bug in 11.1.2 for this problem, and was corrected, but appears to still be a problem.  Does anyone have any suggestions?


_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users