Alaska Software Inc. - Lexical and Seek
Username: Password:
AuthorTopic: Lexical and Seek
Edgar Borger Lexical and Seek
on Wed, 07 Jan 2009 11:37:53 -0200
Hello,

Using Set Lexical On and SetLexRule() I get different behavior for seek 
in 1.82 and 1.90.
I 1.82 if I seek a partial key (less chars then the hole key) I get a 
match (found), but in 1.90 I get not found.
Same dbf/cdx, same prt just recompiled with 1.82 or 1.90.

if I turn set lexical off than seek gets found like it should.

Any advice ?

Regards,
Edgar
James Loughner Re: Lexical and Seek
on Wed, 07 Jan 2009 10:46:04 -0500
Set lexical effects the order that indexes are created. ie if you change
it or the rules you need to rebuild the indexes to do proper seeks. Also
in general I'd recommend always rebuilding the indexes after a major
version upgrade.

Jim

Edgar Borger wrote:
> Hello,
> 
> Using Set Lexical On and SetLexRule() I get different behavior for seek
> in 1.82 and 1.90.
> I 1.82 if I seek a partial key (less chars then the hole key) I get a
> match (found), but in 1.90 I get not found.
> Same dbf/cdx, same prt just recompiled with 1.82 or 1.90.
> 
> if I turn set lexical off than seek gets found like it should.
> 
> Any advice ?
> 
> Regards,
> Edgar
Edgar Borger Re: Lexical and Seek
on Wed, 07 Jan 2009 15:55:23 -0200
James,

thanks, but I did it, the program is being used a long time ago, so Lex 
rules where in effect already, the did not change, the only change as 
alaska version, and yes I rebuilt the indexes, so it's not the case.
I build a small smaple program that I can send you if you want.

Regards,
Edgar


James Loughner escreveu:
> Set lexical effects the order that indexes are created. ie if you change
> it or the rules you need to rebuild the indexes to do proper seeks. Also
> in general I'd recommend always rebuilding the indexes after a major
> version upgrade.
> 
> Jim
> 
> Edgar Borger wrote:
>> Hello,
>>
>> Using Set Lexical On and SetLexRule() I get different behavior for seek
>> in 1.82 and 1.90.
>> I 1.82 if I seek a partial key (less chars then the hole key) I get a
>> match (found), but in 1.90 I get not found.
>> Same dbf/cdx, same prt just recompiled with 1.82 or 1.90.
>>
>> if I turn set lexical off than seek gets found like it should.
>>
>> Any advice ?
>>
>> Regards,
>> Edgar
Edgar Borger Re: Lexical and Seek
on Wed, 07 Jan 2009 16:09:07 -0200
just found pdr 6061.


Edgar Borger escreveu:
> Hello,
> 
> Using Set Lexical On and SetLexRule() I get different behavior for seek 
> in 1.82 and 1.90.
> I 1.82 if I seek a partial key (less chars then the hole key) I get a 
> match (found), but in 1.90 I get not found.
> Same dbf/cdx, same prt just recompiled with 1.82 or 1.90.
> 
> if I turn set lexical off than seek gets found like it should.
> 
> Any advice ?
> 
> Regards,
> Edgar