Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
HOWTO: Passing Variables to SELECT-SQL w/o Using Macro Substitution
Article ID: 114670 - View products that this article applies to.
This article was previously published under Q114670
When you are passing variables to a SELECT - SQL command, you may have to call the command and programmatically pass criteria to it rather than coding such criteria directly. In many such instances, you may not want to use macro substitution.
The programs below show how to pass variables to a SELECT - SQL command without using macro substitution.
The programs below are provided as an example of calling a FoxPro SELECT - SQL command with the selection criteria contained in variables. They employ name expressions and the EVALUATE function instead of macro substitution.
FoxPro 2.x Example
Visual FoxPro Example
The output will contain records where the contents of the field whose name is contained in variable x are equal to the contents of variable y.
Article ID: 114670 - Last Review: February 22, 2005 - Revision: 2.2