Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Variable name Cursor
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00524217
Message ID:
00524237
Vues:
23
This message has been marked as a message which has helped to the initial question of the thread.
Hilmar is right, you cannot use a number as the first character of the name.

Even more, you probably don't need to use a random name. When you do SELECT...INTO CURSOR MyCursor, MyCursor is the alias of the cursor to be created (not the name of the table where VFP will store it.) VFP automatically will chose a name for the table.

Try this
SELECT * FROM master INTO CURSOR MyCursor
? alias()
? dbf()
>Hi again!
>
>I was trying to code up a SQL Select that outputs to a Cursor whose name changes each time you use it.. (like in a report, so as to eliminate collisions when used in a group environment.)
>
>(I'm using FPW 2.6 for this one)
>
>How to do it? I tried....
>
>lcCursor1 = SYS(3)
>
>SELECT * FROM master INTO CURSOR (lcCursor1)....
>
>or....
>
>SELECT * FROM master INTO CURSOR &lcCursor1
>
>and get a SYNTAX ERROR on the use or () or & on the lcCursor1 name.
>
>Any ideas?? Thanks in advance!!
>
>Tommy
Hector Correa
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform