>>>>>>>Revoked
>>>>>>
>>>>>>Set exact is no fun anymore.
>>>>>
>>>>>Odd error in FoxBin2Prg - but my assumption on SET EXACT was not right.
>>>>>
>>>>>I have a INDEX expression
>>>>>

>>>>>INDEX ON SYS(2007,UPPER(CALIAS))+SYS(2007,UPPER(FIELD_NAME)) TAG _FIELD COLLATE "MACHINE" ASCENDING
>>>>>

>>>>>This fails inside a TRY CATCH. the code stops in the CATCH (SET STEP TO)
>>>>>Issued there in Command window, it runs.
>>>>>
>>>>>The code above returns strings of different length, so it might not be the best ever, but why from command line and not from prg?
>>>>
>>>>Padding the length doesn't help?
>>>
>>>Shure it does. To figure out where is even not that big a trick.
>>>
>>>The question is, why does it work the first place. Or why does it stop there.
>>
>>Because you just add two numbers.
>>INDEX ON 8234445+7263482 TAG ...
>>And with that sum you can have many values that are the same,
>
>nope, its INDEX ON '8234445'+'7263482' TAG ...,
>sys(2007 returns a string
>the problem is, the string is not of constant length, and this should not work as index.

The index always accepted variable length strings. In cases where the function, like sys(2007) returns variable length, you have to pad it out, as I understand it.