Summary

When configuring Quick Fields 8's Lookup process to query most databases, you must specify a username and password to authenticate to the database. If the default database schema assigned to the specified user does not contain the table you want to query, Quick Fields may return an "invalid object name" error.

Note: This issue does not apply to all database management types.

Resolutions

Try one or more of the following:

• Reconfigure the user's default schema to include the table, or assign the user a different default schema that already includes the table.
• Write a custom SQL query that specifies the table's full name, including the schema. For example, the following SQL query returns all rows in the MyColumn column, which is inside the MyTable table, which is inside of the MySchema schema: SELECT * from MySchema.MyTable.MyColumn.