Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Parameterised Queries
Message
From
26/11/2001 04:00:50
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Parameterised Queries
Miscellaneous
Thread ID:
00585643
Message ID:
00585643
Views:
38
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
Map
View

Click here to load this message in the networking platform