Information générale
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Network:
Windows 2008 Server
>>Hi,
>>
>>Is this a known issue (not mentioned in the docs AFAICS):
>>
>>I'm issuing the following:
>>
>>ALTER TABLE Printers ALTER COLUMN DeviceName C(250)
>>
>>There's a regular index on this field (which initially has a length of 40)
>>
>>I get an 'Invalid key length' message box but the field length is altered and *the index is dropped* !
>>
>>Surely it should completely reject the change ?
>
>
>In SQL, it should. In VFP, the max length of the index is 240 with machine collate, 120 with other collation sequences.
>
>In a way it makes sense, but I'm as surprised as you are.
I realized the problem lay with the max index length. But I *don't* think it makes sense to allow the field length change but drop the index.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement