Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Variable name Cursor
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00524217
Message ID:
00524290
Views:
11
Excellent! Thanks

Tommy

>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
Tommy Tillman A+ NetWork+ MCP
Previous
Reply
Map
View

Click here to load this message in the networking platform