PRB: Cannot Use Macro Substitution in Remote Views (136774)
The information in this article applies to:
- Microsoft Visual FoxPro for Windows 3.0
This article was previously published under Q136774 SYMPTOMS
you can't use macro substitution within a remote view. This means that the
following code is invalid:
whereclause = "authors.au_lname = 'RINGER'"
CREATE SQL VIEW test REMOTE CONNECT myconnect AS ;
SELECT * FROM authors WHERE &whereclause
RESOLUTION
To limit the result set of a view, consider using View Parameters. For
information about view parameters, please see the "Creating Multi-Table
Views" chapter of the Visual FoxPro "Developers Guide," under the heading
"Limiting the Scope of a View."
STATUS
This behavior is by design.
Modification Type: | Major | Last Reviewed: | 2/15/2000 |
---|
Keywords: | KB136774 |
---|
|