Database application navigation

• US 8,312,048 B2
• Filed: 05/19/2009
• Issued: 11/13/2012
• Est. Priority Date: 05/19/2009
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Greenberg, Steven Miles, Selca, Vitore, Miller, Andrew Robert, Lesser, Stephen, Covington, Clinton Dee, McMinn, Ryan, Karimov, Pavel R., Tupaj, Konrad, Grewal, Amarinder Singh, Cooper, Robert Scott
• Primary Examiner(s): Woo, Isaac M
• Application Number:
  US12/468,067
• Publication Number:
  US 20100299347A1
• Time in Patent Office: 1,274 Days
• Field of Search: 707600-899
• US Class Current: 707/791
• CPC Class Codes: G06F 16/248 Presentation of query results
• CPC Class Codes: G06F 16/9566 URL specific, e.g. using aliases, detecting broken or misspelled links
• CPC Class Codes: G06F 16/972 Access to data in other repository systems, e.g. legacy data or dynamic Web page generation

Abstract

A database server application program is provided that is configured to provide a programmable interface into a database application by way of database services uniform resource locators (URLs). A database services URL utilized by the database application can be updated programmatically by program code executing within or under control of the database server application program. A macro action for use in conjunction with a database server application that provides functionality for displaying a database object, such as a form or report, in-place in a Web browser is also disclosed.

Claims

1. A computer storage medium having computer-executable instructions stored thereupon which, when executed by a computer, causes the computer to:

receive a request for a database object, the request comprising a uniform resource locator (URL) having a first parameter identifying a path to a target subform control that loads the requested database object, a second parameter identifying a name of the database object, and a third parameter identifying a type for the database object;

in response to receiving the request for the database object, identify the database object using the parameters of the URL and cause the requested database object to be displayed in the subform control;

receive a request to execute a macro action; and

in response to receiving the request to execute the macro action, update the URL to reflect execution of the macro action.

2. The computer storage medium of claim 1, wherein the URL further comprises a fourth parameter identifying a page of the database object that should be made a current page.

3. The computer storage medium of claim 2, wherein the URL further comprises a fifth parameter identifying a data mode for the database object.

4. The computer storage medium of claim 3, wherein the data mode comprises an add mode, an edit mode, or a read-only mode.

5. The computer storage medium of claim 3, wherein the database object comprises a database form or a database report, and wherein the third parameter identifies whether the database object is a database form or a database report.

6. The computer storage medium of claim 3, wherein the URL further comprises a sixth parameter specifying a where condition for a record source of the database object.

7. The computer storage medium of claim 3, wherein:

the macro action comprises a macro action for opening a form; and

the instructions which, when executed by the computer, cause the computer to, in response to receiving the request, update the URL to reflect the execution of the macro action, comprise instructions which, when executed by the computer, cause the computer to update the URL to reflect opening of the form.

8. The computer storage medium of claim 3, wherein:

the macro action comprises a macro action for opening a report; and

the instructions which, when executed by the computer, cause the computer to, in response to receiving the request, update the URL to reflect the execution of the macro action, comprise instructions which, when executed by the computer, cause the computer to update the URL to reflect opening of the report.

9. The computer storage medium of claim 3, wherein:

the macro action comprises a macro action for showing a record; and

the instructions which, when executed by the computer, cause the computer to, in response to receiving the request, update the URL to reflect the execution of the macro action, comprise instructions which, when executed by the computer, cause the computer to update the URL to reflect displaying of the record.

10. The computer storage medium of claim 3, wherein:

the macro action comprises a macro action for browsing to a database object in-place; and

the instructions which, when executed by the computer, cause the computer to, in response to receiving the request, update the URL to reflect the execution of the macro action, comprise instructions which, when executed by the computer, cause the computer to update the URL to reflect displaying of the database object in-place.

11. The computer storage medium of claim 3, having further computer executable instructions stored thereupon which, when executed by the computer, cause the computer to:

receive a request from a user interface control to display a database object; and

in response to the receiving the request from the user interface control, to cause the database object to be displayed and to update the URL to reflect the displaying of the database object.

12. The computer storage medium of claim 11, wherein the user interface control comprises a navigation control.

13. A computer-implemented method for displaying a database object in-place, the method comprising performing computer-implemented operations for:

receiving a request to execute a macro action for displaying a database object in-place, the request comprising a uniform resource locator (URL) having a first parameter identifying a path to a target subform control that loads the requested database object, a second parameter identifying a name of the database object, and a third parameter identifying a type for the database object; and

in response to receiving the request for the database object, identifying the database object using parameters, causing the requested database object to be displayed in-place in the subform control, and updating the URL to reflect the displaying of the database object.

14. The computer-implemented method of claim 13, wherein the request further comprises a fourth parameter identifying a page of the database object that should be made a current page when the database object is displayed in-place in the subform control.

15. The computer-implemented method of claim 14, wherein the request further comprises a fifth parameter identifying a data mode for the database object.

16. The computer-implemented method of claim 15, wherein the data mode comprises an add mode, an edit mode, or a read-only mode.

17. The computer-implemented method of claim 16, wherein the database object comprises a database form or a database report, and wherein the third parameter identifies whether the database object is a database form or a database report.

18. The computer-implemented method of claim 17, wherein the request further comprises a sixth parameter specifying a where condition for a record source of the database object.

19. A computer system, comprising:

a processor; and

a memory in communication with the processor, the memory comprising instructions which, when executed by the processor, cause the processor to

receive a request for a database object, the request comprising a uniform resource locator (URL) having a first parameter identifying a path to a target subform control that loads the requested database object, a second parameter identifying a name of the database object, and a third parameter identifying a type for the database object,

in response to receiving the request for the database object, identify the database object using the parameters of the URL and cause the requested database object to be displayed in the subform control;

receive a request to execute a macro action; and

in response to receiving the request to execute the macro action, update the URL to reflect execution of the macro action.

20. The computer system of claim 19, wherein:

the macro action comprises a macro action for opening a form, a macro action for opening a report, a macro action for showing a record, or a macro action for browsing to a database object in-place; and

the instructions which, when executed by the processor, cause the processor to, in response to receiving the request, update the URL to reflect the execution of the macro action, comprise instructions which, when executed by the processor, cause the processor to

if the macro action comprises the macro action for opening the form, update the URL to reflect opening of the form,

if the macro action comprises the macro action for opening the report, update the URL to reflect opening of the report,

if the macro action comprises the macro action for showing the record, update the URL to reflect showing the record, and

if the macro action comprises the macro action for browsing to the database object in-place, update the URL to reflect displaying of the database object in-place.