Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
BUG? Error when Alter table cursor in SP1-beta
Message
De
01/10/2005 09:27:25
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
01/10/2005 06:34:23
Information générale
Forum:
Visual FoxPro
Catégorie:
Visual FoxPro Beta
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP1
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
01055213
Message ID:
01055232
Vues:
14
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform