Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Indexing problem
Message
 
To
23/08/2002 15:20:42
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00693110
Message ID:
00693123
Views:
24
This message has been marked as the solution to the initial question of the thread.
Because there is 100 length restriction for IDX files.
"The length of an index key for an .idx index must be between 1 and 100 characters". field_name is 128-length.
Try another index expression or create CDX file, like
index on field_type tag hello





>Hi all,
>
>I'm having a problem creating an index on the resulting extended structure table when done within a code.
>
>
>close database all
>create cursor test (f1 i, f2 d)
>select test
>copy structure extended to testx
>use testx in 0 exclusive
>select testx
>index on field_name to testx && invalid key length
>
>
>However, I can use the Data Session window to create the index without problem.
Previous
Reply
Map
View

Click here to load this message in the networking platform