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

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

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

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