General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Parameterised Queries
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only