>In Delphi i am used parameterised Queries in order to create Queries
>Which i used in a masterdetail form.
>
>A parameterized query is one that permits flexible row/column selection
>using a parameter in the WHERE clause of a SQL statement.
>The Params property allows replacable parameters in the predefined SQL statement.
>A parameter is a placeholder for a value in the WHERE clause,
>defined just before the query is opened.
>
>At design-time i use the Object Inspector to set the SQL property as follows:
>
>Query.SQL := 'SELECT * FROM detailstable WHERE type =: masterID'
>
>In the object inspector i set as database property the mastertable. So the MasterID-parameter is being retrieved out of the Mastertable.
>
>I would like to know wether this is possible in Foxpro. If yes HOW???
>
>Greetings
>
>Harry O
FoxPro 2.x doesn't support views - with or without parameters.
VFP does.
Use a parameter that starts with a question mark "?". This is in the third page of the view designer.
HTH, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)