>>Does a parameterized CREATE SQL VIEW have to take the form shown
>>in VFP Help and MSDN Library:
>>
>>Value = "Value"
>>CREATE SQL VIEW lvTable ;
>> AS SELECT Fields ;
>> FROM Table ;
>> WHERE Field = ?Value
>>
>>or can it be in this form:
>>
>>Condition = "Field = 'Value'"
>>CREATE SQL VIEW lvTable ;
>> AS SELECT Field1, Field2 ;
>> FROM Table ;
>> WHERE ?Condition
>
>No, the view will not work this way.

Darn.  What's the best alternative?  Would you suggest:

[build m.Condition]
CREATE SQL VIEW lvTable ;
    AS SELECT t1.*, t2.Descript, t3.Name ;
    FROM Table t1, Codes t2, Names t3 ;
    WHERE t2.ID = t1.CodeID AND t3.ID = t1.NameID
SET FILTER TO &Condition

Thanks,
Rich.

Rich Addison, Micro Vane, Inc., Kalamazoo, MI
Relax, don't worry, have a homebrew.
  - Charlie Papazian, The New Complete Joy of Home Brewing