Invalid constant value entered. Please enter a constant that is a valid Number.

Problem

You get this error when attempting to create a WHERE clause in the Add WHERE Clause dialog:

Missing or incorrect information

This can occur when the data access code for the database table or view you have selected in your WHERE clause is not part of your application, typically because no other pages refer to the table or view.

Solution

Select the "Allow insert, update, and delete" option in the Databases tab for the appropriate database table or view. This forces Iron Speed Designer to create the Data Access Layer code for the table or view.