Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Why does select from cursor cause error
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Why does select from cursor cause error
Versions des environnements
Visual FoxPro:
VFP 6 SP5
OS:
Windows 2000 SP4
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
01054048
Message ID:
01054048
Vues:
50
Same problem exists in version 8.0.
1.  select * from aliasname
2.  select * from dbf('aliasname')  
We have a method which is passed a cursor name. It appears in that if the cursor was created using the "Create Cursor" command you would use #1. But, if it was created from a "Select ... Into Cursor " command it needs #2. However, our method does not know how the cursor was created, its name was passed to the method as a parameter.

How does the method know which format below to use to select from the cursor?

Note: #1 above used to work in all cases for us until we did some Microsoft Patches recently. Code that had been working for years is now expecting the "dbf(' ')" function - but only sometimes. It does not seem to be consistent.

The error message you get if the cursor was created from another SELECT ... INTO CURSOR statement is:
"'cursorname' must be selected with SELECT ... INTO TABLE"
Extreme Programming = Plan -> Design -> Code -> Test
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform