Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Upgrade VFP6 to VFP9 under test
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01254358
Message ID:
01254384
Views:
10
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--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform