FP98: IDC Query Returns No Records If Field Name Has Space (194440)
The information in this article applies to:
- Microsoft FrontPage 98 for Windows
This article was previously published under Q194440 For a Microsoft FrontPage 97 version of this article, see 167862.
SUMMARY
When you use the Microsoft Internet Database Connector (IDC) features
to query a data source table that has a space in the field name, the
query returns no records found.
When you create a new IDC query to retrieve data from a field that
contains a space in the field name, you can rename the field for the
results set by using the SQL reserved word 'AS'. The following example
shows how this would be used when your table contains a field called
"Last Name":
SELECT "Last Name" AS LastName FROM Employees
| Modification Type: | Major | Last Reviewed: | 10/3/2001 |
|---|
| Keywords: | kbinfo KB194440 |
|---|
|