Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Indexing problem
Message
 
 
To
02/11/2005 11:41:03
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01064524
Message ID:
01064528
Views:
20
If the collating sequence is not set to MACHINE then index key length is limited to 120 characters.

>I got into this problem :
>I want to create a table programmatically and also create an index,
>I got the error invalid key lenght but if I create the index via builder
>it's ok. How come ? I try to create the table as free and also belonging to a dbc but without success.
>I tried with the command create table
>I tried with create table and then alter table
>i tried with create table followed by the command index on
>
>nothing to do.
>
>here is my source
>
>
>Create Table (xpath + 'Myform') free (nomeform c(20),controllo c(200),
default c(60), field1 c(60), field2 c(60), field3 c(60), field4 c(60), field5 c(60))
>
>index on nomeform + controllo tag 'chiave'
>
>
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform