Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to use Parameterized views in a forms DE
Message
 
To
16/07/1999 16:46:52
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00242522
Message ID:
00242588
Views:
20
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!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform