>>I am getting this error message....
>>Program Error
>>Command contains unrecognized phrase/keyword
>>Here is my code...
>> set safety off
>> set database to qc
>> dele view mainview
>> create sql view mainview as select * from qc_table where &m_filter
>> use mainview
>>Does anybody know what it can be?
>
>What is inside m_filter? Add messagebox before Create SQL ... and check the value, if for some reason you don't want to use 'Debug'.
Hi Ed - m_filter was empty - I should of checked... thanks :)))))