Patent ID: 8396848
Filing Date: 2013-03-12
Classification: G06F

Abstract:
1. A computer-implemented method for providing a user interface for entering parameters associated with a database query statement, the method comprising: generating a database query statement for retrieving data from a database that is displayed within a data view; wherein the data view comprises a view of the data retrieved from the database; sending the query statement to a database engine for execution; the database engine determining that the query statement is not executable as received, and in response, returning a parameter request that requests entry of at least one additional parameter; and accessing a property list to determine when a customized parameter form exists to receive entry of the at least one additional parameter, wherein the customized parameter form is a custom designed form that is created for entry of the at least one additional parameter by receiving an entry of a customization of a prompt for the at least one additional parameter that is different from a default prompt displayed with a general parameter form to receive entry of the at least one additional parameter; determining when to display the general parameter form to receive entry of the at least one additional parameter and when to display the customized parameter form to receive the entry of the at least one additional parameter; in response to determining that the customized parameter form does not exist, displaying the general parameter form and a control generated on the form for entry of the at least one additional parameter and displaying the general parameter form to receive entry of the at least one additional parameter when the property list indicates that a customized parameter form does not exist to receive the at least one additional parameter and is not associated with the data view; in response to determining that the customized parameter form exists, displaying the customized parameter form to receive entry of the at least one additional parameter when the property list indicates that the customized parameter form exists for entry of the at least one additional parameter; wherein the customized parameter form includes values obtained from the database relating to the data view, wherein the values obtained from the database are used as default values to receive the at least one additional parameter and wherein prompts of the customized parameter form are modified based on the values; and executing the query statement with a modified value of the parameter.