Troubleshooting Tables

This section describes problems you might encounter when creating and testing tables in the Design Tool.



Executing an SQL query results in no records found


If you execute an SQL query against a table and do not find any records even though they exist, the Design Tool is unable to resolve your query into a valid procedure: You need to create one or more procedures that can access the table data.



A valid procedure returns no data


It's possible that a post-fetch filtering operation removed the data you were trying to retrieve. Table data is case sensitive: Be sure you are using the correct case when trying to retrieve data.