Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Upgrade VFP6 to VFP9 under test
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01254358
Message ID:
01254384
Vues:
9
This message has been marked as the solution to the initial question of the thread.
Result returned by dtoc(invoice_dt)) can have different format and size depending on some SET settings. There's function specifically designed to be used for indexing - DTOS() or DTOC(,1).
upper(accountno+client+DTOS(invoice_dt))
>
>Seems to work ok until I run the following code
>
>
>Select Invoicestack
>Scan
>replace client with clients.client
>endscan
>
>I get the error 'Error building key for index'
>l:\global\account\invoicestack.cdx tag Invoiceget
>
>Invoiceget is indexed on upper(accountno+client+dtoc(invoice_dt))
>
>Do I need to rebuild all indexes in VFP9 before continuing?
>
>Colin
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform