>>
>> I am trying to REQUERY() my VIEW using a PARAMETERIZED VIEW. I need to set
>> this up on my WHERE clause,
>> but my WHERE clasue is a string of conditions.
>> example.. m_filter = 'lastname = thisform.lastname'
>> m_filter = m_filter + 'acctnum = thisform.acctnum'
>>
>> SELECT *;
>> FROM table;
>> WHERE &m_filter
>>
>> How can I PARAMETERIZED the WHERE clause?
>
>Hi,
>I don't know what you want to do, if you know all conditions you want to
>make a view, or user is going to put them.
>If you don't know them, you would need a form to have conditions you
>need and then put in one string.
>something like:
>user wants to see all records where acct = '222222' and lstname 'qwewe'
>I'd have a form and in lostfocus every textbox I'd put something like
>my_cond = my_cond + ' and this_field = ' + value
>
>&& value should be a part of string
>
>is this what you want?
>hth
>
>--
thanks for your answer. I found my answer. You just...
SELECT *;
FROM table
WHERE &?string
string = your WHERE string
use my view
thanks again - Rob