Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Parameterised Queries
Message
De
26/11/2001 04:00:50
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Parameterised Queries
Divers
Thread ID:
00585643
Message ID:
00585643
Vues:
39
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
Fil
Voir

Click here to load this message in the networking platform