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?