Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement