Support for the AS Clause in RQBE (101592)
The information in this article applies to:
- Microsoft Visual FoxPro for Windows 3.0
- Microsoft FoxPro for Windows 2.5
- Microsoft FoxPro for Windows 2.5a
- Microsoft FoxPro for MS-DOS 2.0
- Microsoft FoxPro for MS-DOS 2.5
- Microsoft FoxPro for MS-DOS 2.5a
This article was previously published under Q101592 SUMMARY
There currently is no direct support for the AS clause in RQBE.
However, you can use the AS clause in RQBE by using the field
expression builder and using the following syntax:
[<alias>.]<select_item> AS <column_name>
NOTE: Whatever is placed in the quotation marks to the right of the AS
expression cannot contain any spaces; otherwise, it will generate an
error and/or undesired results. Instead of spaces, you can use
underscores.
| Modification Type: | Major | Last Reviewed: | 12/3/2003 |
|---|
| Keywords: | KB101592 |
|---|
|