Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select all except
Message
 
 
To
20/11/2007 12:28:51
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01269471
Message ID:
01270224
Views:
33
>Thanks for clarification - it was me then who didn't know that on time :).
>
>Now I've looked at the error 1115 - Invalid operation for the cursor (if that was what he got), and it says "An attempt was made to use the PACK command on a cursor.", which can still be a wrong error... or maybe not, if Alter Table does a PACK behind the scenes. Does it? Or did it do so in some versions? It shouldn't, but it does perform similarly to PACK (create a new table, append, kill the old), the difference being that it appends deleted records as well, and preserves their deleted() status.
>
>So I wonder what could have caused 1115 and I can't find any other error with similar text.

The error 1115 description never got updated. Since VFP7 ALTER TABLE generates that error when cursor has long field names. In VFP6 and earlier the field names were silently truncated to 10 characters.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform