>I was just notified of a very strange behavior of the Select command and the Select() function, by Maharastra Kolhapur on Foxite. What he told me, and which I didn't know, was that Select() also performs an implicit Select command "behind the scene" when you supply a work area that is actually used. And even "worse", VFP makes no distinction between Select(myWorkArea) and Select (myWorkArea), note the space, they both are treated as Functions!
>
>Here is a small, slightly modified, excerpt from my message on Foxite. Please read carefully, the impact may be bigger than you immediately think.
>myWorkArea = 'myTable'
>1. ?Select(myWorkArea)
>2. ?Select (myWorkArea)
>3. Select (myWorkArea)
>
>Note that the only difference between 1 and 2 is the space. I would expect an error on 2.
>And that the only difference between 2 and 3 is the question mark.
>Since we have the "option 3", maybe it's a good thing that Select() also performs an implicit Select command?
>
>I am really grateful for your discovery, which I will keep in mind. Luckily we have the debugger.
The space between select and the left parenthesis is insignificant space which the lexer does not pass to the parser
When select is not the first word, it's a function otherwise a command. The parser has some rules to determine whether it's a select command or an sql select
Gregory