Sorry about the confusion. Yes the " were in there (the view designer kept putting them in, that thing is a little funny).
Here is the select now:
SELECT *;
FROM workman!addressbook;
WHERE Addressbook.ab_id = ?thisform.curid
Now I get a operator/operand mismatch when the form runs.
>Hi Roi ----
>
>Change the word "filter" to "parameter"...it's confusing. Anyway, are the double-quotes in the parameter of the view. If so, that would be the cause. It should be
>
>SELECT * FROM table WHERE curid = ?THISFORM.curid
>
>>I have a prop on the form - CurId.
>>
>>I changed the filter to "thisform.curid" and ?"thisform.id" but the view doesn't contain any data. If I change it back to a var - lcCurId - it works.
>>
>>Should the filter be something else?
Roi
'MCP' Visual FoxPro
In Rome, there was a poem.
About a dog, who found two bone.
He lick the one, he lick the other.
He went pyscho, he drop dead!