Placeholder control for updating database object
First Claim
1. A method of updating a database object in a relational database, the method comprising:
- updating a recordset schema associated with the database object;
loading or activating the database object;
finding a new field to be added to the database object in response to a change in the recordset schema, including;
determining whether a recordset schema has changed, the recordset schema being associated with the database object and being associated with a collection of records made available to the database object,comparing the updated recordset schema to a previous recordset schema associated with the database object to determine whether the updated recordset schema includes a new field not in the previous recordset schema, andcomparing each field in the updated recordset schema to each field in the previous recordset schema to determine whether each field in the updated recordset schema has a matched field in the previous recordset schema, wherein determining whether each field in the updated recordset schema has a matched field in the previous recordset schema comprises determining, for each field, whether there is at least one of a plurality of bound controls for the field in the updated recordset schema, wherein the plurality of bound controls comprise controls placed on the database object for entering, displaying and editing field data, wherein a field in the updated recordset schema having no matched field indicates the field to be a new field not in the previous recordset schema;
positioning the new field to a determined place in the database object;
displaying a database visualization in the database object associated with the new field; and
positioning the new field to a place determined by a placeholder control, the placeholder control comprising a label and text box pair with a keyword in a placeholder control tag, the tag comprising a string placeholder which is added to the label and the text box, the string placeholder enabling interaction with the label and the text box.
2 Assignments
0 Petitions
Accused Products
Abstract
Updating a graphical database object in a database via a placeholder control is provided. After a database recordset schema or schema is updated, a determination is made as to whether anew field is to be added to the graphical database object in response to the recordset schema or schema change. If a new field is to be added, the new field is automatically added to the graphical database object. The new field may be positioned to a place in the graphical database object as directed by a user or editor of the database object. The graphical database object may be displayed with the new field as positioned based on the recordset schema or schema change.
-
Citations
18 Claims
-
1. A method of updating a database object in a relational database, the method comprising:
-
updating a recordset schema associated with the database object; loading or activating the database object; finding a new field to be added to the database object in response to a change in the recordset schema, including; determining whether a recordset schema has changed, the recordset schema being associated with the database object and being associated with a collection of records made available to the database object, comparing the updated recordset schema to a previous recordset schema associated with the database object to determine whether the updated recordset schema includes a new field not in the previous recordset schema, and comparing each field in the updated recordset schema to each field in the previous recordset schema to determine whether each field in the updated recordset schema has a matched field in the previous recordset schema, wherein determining whether each field in the updated recordset schema has a matched field in the previous recordset schema comprises determining, for each field, whether there is at least one of a plurality of bound controls for the field in the updated recordset schema, wherein the plurality of bound controls comprise controls placed on the database object for entering, displaying and editing field data, wherein a field in the updated recordset schema having no matched field indicates the field to be a new field not in the previous recordset schema; positioning the new field to a determined place in the database object; displaying a database visualization in the database object associated with the new field; and positioning the new field to a place determined by a placeholder control, the placeholder control comprising a label and text box pair with a keyword in a placeholder control tag, the tag comprising a string placeholder which is added to the label and the text box, the string placeholder enabling interaction with the label and the text box. - View Dependent Claims (2, 3, 4, 5)
-
-
6. A method of updating a graphical database object in a database, the method comprising:
-
updating a recordset schema in the database; finding a new field to be added to the graphical database object in response to the updated recordset schema, wherein the act of finding a new field to be added for the graphical database object comprises; determining whether a recordset schema has changed; comparing the updated recordset schema to a previous recordset schema to determine whether the updated recordset schema includes a new field not in the previous recordset schema; and comparing each field in the updated recordset schema to each field in the previous recordset schema to determine whether each field in the updated recordset schema has a matched bound control in the previous recordset schema, wherein determining whether each field in the updated recordset schema has a matched bound control in the previous recordset schema comprises determining, for each field, whether there is at least one of a plurality of bound controls for the field in the updated recordset schema, wherein the plurality of bound controls comprise controls placed on the graphical database object for entering, displaying and editing field data, wherein a field in the updated recordset schema having no matched bound control indicates the field to be a new field not in the previous recordset schema; automatically adding the new field to the graphical database object; positioning the new field to a determined place in the graphical database object; displaying the graphical database object with the new field; and positioning the new field to a place determined by a placeholder control, the placeholder control comprising a label and text box pair with a keyword in a placeholder control tag, the tag comprising a string placeholder which is added to the label and the text box, the string placeholder enabling interaction with the label and the text box. - View Dependent Claims (7, 8, 9, 10, 11, 12)
-
-
13. A system for updating a graphical database object in a database, the system comprising:
-
a memory for storing executable program code; and a processing unit, functionally coupled to the memory, the processor being responsive to computer-executable instructions contained in the program code and operative to; utilize a schema update module programmed to update a database schema in the database; and utilize a graphical database object update module programmed to update the graphical database object in response to detecting a database schema change, wherein the graphical database object update module comprises a find module programmed to find a new field to be added for the graphical database object due to the database schema change, wherein finding a new field comprises; determining whether the database schema has changed; comparing the updated database schema to a previous database schema to determine whether the updated database schema includes a new field not in the previous database schema; and comparing each field in the updated database schema to each field in the previous database schema to determine whether each field in the updated database schema has a matched bound control in the previous database schema, wherein determining whether each field in the updated database schema has a matched bound control in the previous database schema comprises determining, for each field, whether there is at least one of a plurality of bound controls for the field in the updated database schema, wherein the plurality of bound controls comprise controls placed on the graphical database object for entering, displaying and editing field data, wherein a field in the updated database schema having no matched bound control indicates the field to be a new field not in the previous database schema, wherein the graphical database object update module further comprises; a positioning module programmed to position the new field to a place in the graphical database object, wherein the positioning module comprises a placeholder control to determine where to position the new field in the graphical database object, the placeholder control comprising a label and text box pair with a keyword in a placeholder control tag, the tag comprising a string placeholder which is added to the label and the text box, the string placeholder enabling interaction with the label and the text box; a display module programmed to display the graphical database object with the new field; a user option module programmed to provide a user an option to determine whether to add the new field to the graphical database object; and an auto-update module programmed to automatically add the new field to the graphical database object. - View Dependent Claims (14, 15, 16, 17, 18)
-
Specification