FP97: IDC Query Returns No Records If Field Name Has Space
Article ID: 167862
Article Last Modified on 11/8/2001
APPLIES TO
- Microsoft FrontPage 98 Standard Edition
- Microsoft FrontPage 97 Standard Edition
- Microsoft FrontPage 1.0 for Macintosh
This article was previously published under Q167862
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
Additional query words: 97
Keywords: kbinfo kbusage KB167862