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