Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Strange Index Error
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01571265
Message ID:
01571370
Vues:
39
>>>>So....... someting in VFP 9.0 Service Pack 1 fails in the Index Tag if you use DTOC
>>>>against a datetime field.... also, there is a built in filter with the tag too....
>>>>"status = 5" for the filter. If it helps in understanding this error.
>>>
>>>MS changed the behavior of indexes to not allow potentially variable length keys.
>>>DTOC() can potentially have a variable length depending on how SET CENTURY
>>>is set.
>>
>>So THAT IS the answer!
>>Thanks!!!
>
>
>Tommy, were you getting the error on use (add/edit)? Or on the creation of the initial INDEX? I thought you were getting it occasionally on the INDEX ON command itself.

The error would always occur on the line of code that would assign the value of 5 to 'status' of the new record in ss_io.

The record was created new by an APPEND BLANK, then values were assigned to various fields, then when we got to 'status',

BOOOM

everytime.

Thanks!
Tommy Tillman A+ NetWork+ MCP
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform