Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
BUG? Error when Alter table cursor in SP1-beta
Message
From
01/10/2005 06:34:23
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Visual FoxPro Beta
Title:
BUG? Error when Alter table cursor in SP1-beta
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP1
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01055213
Message ID:
01055213
Views:
55
Hi all,

I have used this code for many years
SELECT * FROM prislist WHERE .f. INTO CURSOR curpris READWRITE 
Alter table curpris add column familie c(15)
Alter table curpris add column variant c(2)
Alter table curpris add column pinner n(2)
With SP1 beta, I get error 1115 "Invalid operation for the cursor", on line 2. 3 and 4. According to Help, this error means "An attempt was made to use the PACK command on a cursor." I do NOT try to pack the cursor, and I don't have any long field names, which may cause problems according to help. As far as I can see, this must be a bug which has been introduced in the Beta for SP1.

I do realize that I can simplify my code, and replace all the four lines with
SELECT *, Space(15) as familie, Space(2) as variant, 00 as pinner FROM prislist WHERE .f. INTO CURSOR curpris READWRITE
or
SELECT *, Cast("" as c(15)) as familie, Cast("" as c(2))  as variant, Cast(0 as n(2)) as pinner FROM prislist WHERE .f. INTO CURSOR curpris READWRITE
but, I use the same construct many,many places.

I have investigated more, and I get even more confused. I tried to select from another table, and I did NOT recieve any error. I also USEd my prislist table, copied it to another name by Copy stru to xxx with cdx, and SELECTed from xxx, and got no error when I tried Alter table. So it is obvious that this error only happens under certain conditions, but I am not able to see which. CPDBF() and CPCURRENT() are identical.

Comments please?
Next
Reply
Map
View

Click here to load this message in the networking platform