Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ALTER TABLE dropping index
Message
From
24/04/2014 07:17:27
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
ALTER TABLE dropping index
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01598940
Message ID:
01598940
Views:
59
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 ?
Next
Reply
Map
View

Click here to load this message in the networking platform