Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Fun with SET EXACT
Message
De
16/02/2021 12:24:51
Mike Yearwood
Toronto, Ontario, Canada
 
 
À
16/02/2021 12:15:16
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01678259
Message ID:
01678285
Vues:
49
>>>>>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.
>
>When the index is created, it takes the length of the value as the length of the index. So depending on what's in the first record at that moment you get different lengths and then for other records the tag value is stored in that length. Perhaps you accidentally had one in the command window which evades the error, and another one when running the code?

Perhaps Lutz did, yet.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform