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 09:27:25
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
01/10/2005 06:34:23
General information
Forum:
Visual FoxPro
Category:
Visual FoxPro Beta
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP1
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01055213
Message ID:
01055232
Views:
10
>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?

Thanks God,
I couldn't reproduce:) However scared to think there might be a way to reproduce it.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform