>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.
Hi Tore,
you can see the first VFP's parser step with NORMALIZE()
? NORMALIZE("Select (myWorkArea)")