Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Fun with SET EXACT
Message
From
16/02/2021 11:58:21
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01678259
Message ID:
01678282
Views:
44
>>>>>>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.
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord

Weeks of programming can save you hours of planning.

Off

There is no place like [::1]
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform