>I have a rather complex SQL query run against several VFP tables that involves three UNIONs, each of which, as well as the main SELECT, refer to the parameter. It runs just fine as a SQL query. However, I want to make a view based on the query, and I cannot seem to figure out how to write it with the four references to the parameter. I have tried a ? before each reference, before the first, the last, etc., but I always get an error saying "Column
not found".
>
>Can anyone tell me how to do this?
>
>Thanks.
>
>Jim
Odd. A ? before each should do the trick.
I'm assuming that you aren't using the view designer to do this, since you've got the UNIONs.
Could you post the code for the view?
Insanity: Doing the same thing over and over and expecting different results.