FP98: IDC Query Returns No Records If Field Name Has Space

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