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 ?
>>>
>>>Probably a bug. You may want drop the index yourself.
>>
>>Can't drop the index - existing code would blow up. I'm just going to content myself with keeping the field length below the 240 limit ......
>
>I meant before changing the length, change the length, then restore the index (within the allowed length).
If the change is within the allowed length then it doesn't drop the index anyway.....
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