JP7260813B2 - Program, control method and information processing device - Google Patents

Description

The present invention relates to a program , control method, and information processing apparatus for building an application.

2. Description of the Related Art In recent years, in information processing apparatuses, there is a mechanism for arranging components on a screen and constructing an application. In addition, there is also a mechanism of a service in which a development user constructs an application on a network such as the Internet using this mechanism, and an end user uses the constructed application.

Patent Literature 1 describes an application development support device for constructing an application including a GUI with a simple operation. Further, in Patent Document 1, a copy button is arranged on an application screen, and the user can create new data by copying desired data using the copy button.

JP 2004-102886 A

However, the system of Patent Document 1 has a problem that even if the copy source data is updated, the copy destination data created by copying is not updated. For example, if the copy source is master data and the copy destination is transaction data, even if the master data is updated, the part copied to the transaction data will not be updated while the value is old. is no longer available.

SUMMARY OF THE INVENTION Accordingly, it is an object of the present invention to provide a mechanism for constructing an application that easily maintains consistency between copy source data and copy destination data generated by using the application.

selection receiving means for receiving a selection of an item to be used for new data to be registered using the registered data as a reference from items included in the registered data, and for the item selected by the selection receiving means. setting receiving means for receiving a setting as to whether or not to update new data registered with said registered data as a reference when the value of said item of said registered data is updated; Control means for controlling whether or not to update registered data using the updated registered data according to the update of the registered data, based on the settings received by the setting receiving means. program to make it work .

According to the present invention, it is possible to provide a mechanism for constructing an application that easily maintains consistency between copy source data and copy destination data generated by using an application.

A diagram showing an example of the configuration of an information processing system 100 according to the present embodiment. 1 is a diagram showing an example of the hardware configuration of an information processing apparatus 101 and a server 102 according to this embodiment; FIG. 1 is a block diagram showing an example of functional configurations of an information processing apparatus 101 and a server 102 according to the present embodiment; FIG. A diagram showing an example of a table managed by the server 102 of this embodiment. Flowchart showing an example of screen creation processing according to the first embodiment Flowchart showing an example of screen utilization processing according to the first embodiment FIG. 4 is a diagram showing an example of a screen for creating a screen displayed by the information processing apparatus 101 according to the first embodiment; FIG. FIG. 4 is a diagram showing an example of a screen for setting component attributes of a screen displayed by the information processing apparatus 101 according to the first embodiment; FIG. 4 is a diagram showing an example of a screen for registering master data using a created screen in the information processing apparatus 101 of the first embodiment; FIG. 4 is a diagram showing an example of a screen for registering transaction data using a created screen in the information processing apparatus 101 of the first embodiment; FIG. 4 is a diagram showing an example of a screen for editing master data using a created screen in the information processing apparatus 101 of the first embodiment; FIG. 4 is a diagram showing an example of a screen that displays transaction data using a created screen in the information processing apparatus 101 of the first embodiment; A diagram showing an example of a reflection trigger created by the server 102 of the first embodiment. Flowchart showing an example of screen creation processing according to the second embodiment FIG. 11 is a diagram showing an example of a screen for setting component attributes of a screen displayed by the information processing apparatus 101 according to the second embodiment; FIG. A diagram showing an example of a reflection trigger created by the server 102 of the first embodiment. Flowchart showing an example of screen utilization processing according to the second embodiment FIG. 10 is a diagram showing an example of a screen displaying master data using a created screen in the information processing apparatus 101 of the second embodiment; FIG. 11 is a diagram showing an example of a screen displaying relationships of data reflection in the information processing apparatus 101 according to the second embodiment; FIG.

[First Embodiment]
Hereinafter, embodiments of the present invention will be described in detail with reference to the drawings.
FIG. 1 is a diagram showing an example of the configuration of an information processing system 100 of this embodiment.

As shown in FIG. 1, an information processing system 100 has a configuration in which an information processing apparatus 101 and a server 102 are communicably connected via a network 103 . The information processing apparatus 101 is a terminal such as a desktop PC, a mobile phone, a smart phone, a tablet terminal, a notebook PC, and a PDA terminal. The image is displayed on the display device 210 using an installed application such as a browser.

The server 102 searches for information in response to a request from the information processing apparatus 101 and returns the search result. The communication between the information processing apparatus 101 and the server 102 may be an HTTP request/response, or a request/response used for a web service using SOAP or the like.

In this embodiment, the web application using the browser of the information processing apparatus 101 is used, but the application is not limited to the web application, and may be an application using technologies other than the web.

In the present embodiment, the information processing system 100 is a system in which the information processing device 101 searches for data in tables stored in the storage device of the server 102. However, the information processing system 100 is not limited to this. Any mechanism may be used as long as the device 101 displays the search result of the information stored in the storage device.

An example of a hardware configuration applicable to the information processing apparatus 101 and the server 102 shown in FIG. 1 will be described below with reference to FIG.
In FIG. 2, reference numeral 201 denotes a CPU that controls devices and controllers connected to a system bus 204 in an integrated manner. The ROM 203 or the external memory 211 also stores a BIOS (Basic Input/Output System), which is a control program for the CPU 201, an operating system program (hereinafter, referred to as OS), and functions necessary for realizing the functions executed by each server or each PC. various programs are stored.

A RAM 202 functions as a main memory, a work area, and the like for the CPU 201 . The CPU 201 loads programs and the like necessary for executing processing from the ROM 203 or the external memory 211 to the RAM 202, and executes the loaded programs to realize various operations.

An input controller 205 controls input from the input device 209 or the like. A video controller 206 controls display on a display device 210 such as a liquid crystal display. The display device is not limited to a liquid crystal display, and may be a CRT display or the like. These are used by clients as needed.

A memory controller 207 is connected via an adapter to a hard disk (HD), a flexible disk (FD), or a PCMCIA card slot for storing boot programs, various applications, font data, user files, edit files, and various data. It controls access to an external memory 211 such as a compact flash (registered trademark) memory that is

A communication I/F controller 208 connects and communicates with an external device via the network 103, and executes communication control processing in the network. For example, communication using TCP/IP is possible.

Note that the CPU 201 enables display on the display device 210 by, for example, rasterizing outline fonts to a display information area in the RAM 202 . The CPU 201 also allows the user to issue instructions using a mouse cursor (not shown) on the display device 210 .

Various programs that operate on the hardware are recorded in the external memory 211 and are executed by the CPU 201 by being loaded into the RAM 202 as necessary.
It should be noted that not all devices are equipped with these configurations, and it is sufficient if they are equipped with necessary components.

FIG. 3 is a block diagram showing an example of functional configurations of the information processing apparatus 101 and the server 102. As shown in FIG.
The application screen information generation unit 301 is a functional unit that generates screen information of an application screen including data selection components for selecting registered data registered in the database.

The data registration unit 302 uses the values of the registered data selected by using the data selection components included in the screen information of the application screen generated by the application screen information generation unit 301, and registers them in the database as new data. It is a functional part.
The determination unit 303 is a functional unit that determines whether registered data has been updated.

The update setting management unit 304 is a functional unit that manages the setting as to whether or not to update the new data registered by the data registration unit 302 when the determination unit 303 determines that the registered data has been updated. .

If the determination unit 303 determines that the registered data has been updated and the update setting management unit 304 manages to update the new data, the control unit 305 updates the new data. On the other hand, when the update setting management unit 304 manages to prevent the new data from being updated, the function unit performs control so that the new data is not updated.

When the determination unit 303 determines that the registered data has been updated, the update setting management unit 304 updates each item included in the new data among the new data registered by the data registration unit 302. This is a functional unit that manages the setting of whether or not to
When the determination unit 303 determines that the registered data has been updated, the control unit 305 updates the value of the item managed as being updated among the new data by the update setting management unit 304. , and on the other hand, for items managed as not to be updated among new data by the update setting management unit 304, the value of the item is controlled not to be updated.

The following is an example of the functional configuration of an information processing apparatus that uses an application built by arranging components using the layout editing screen.
The data selection component placement unit 311 is a functional unit that places a data selection component for selecting registered data registered in the database on the layout editing screen.

The selection unit 312 is a functional unit that selects data from registered data using the data selection component arranged by the data selection component arrangement unit 311 displayed on the constructed application screen.
The data registration requesting unit 313 is a functional unit that uses the value of the registered data selected by the selecting unit 312 to request registration in the database as new data.
The determination unit 314 is a functional unit that determines whether or not the registered data selected by the selection unit 312 has been updated.

The update setting reception unit 315 is a functional unit that receives a setting as to whether or not to update the new data registered according to the data registration request unit 313 when the determination unit 314 determines that the registered data has been updated. .

If the determining unit 314 determines that the registered data has been updated and the update setting receiving unit 315 has received a setting to update new data, the control unit 316 requests updating of the new data. On the other hand, when the update setting receiving unit 315 receives a setting not to update new data, it is a functional unit that controls not to request updating of the new data.

When the determination unit 314 determines that the registered data has been updated, the update setting reception unit 315 determines whether or not to update each item included in the new data registered according to the data registration request unit 313. accepts the setting of

When the determination unit 314 determines that the registered data has been updated, the control unit 316 updates the value of the item for which the update setting reception unit 315 has received a setting to be updated among the new data. On the other hand, the update setting receiving unit 315 controls not to update the values of the items for which the update setting receiving unit 315 has received a setting not to update.

The application screen display unit 321 is a functional unit that displays an application screen including a data selection component for selecting registered data registered in the database, constructed using a layout editing screen.

The data selection unit 322 is a functional unit that selects data from registered data using data selection components displayed on the application screen displayed by the application screen display unit 321 .

The data registration request unit 323 is a functional unit that uses the value of the registered data selected by the data selection unit 322 to request registration in the database as new data.
The first data update request unit 324 is a functional unit that requests update of the value of registered data selected by the data selection unit 322 .

The second data update request unit 325 updates the value of new data whose registration is requested by the data registration request unit 323 when the first data update request unit 324 requests update of the value of the registered data. is a functional part that requires

When the first data update requesting unit 324 requests to update the value of the registered data, the second data update requesting unit 325, among the new data requested to be registered by the data registration requesting unit 323, Request to update the value of the item included in the new data according to the setting of whether to update defined for each item included in the new data.

FIG. 4 is an example of a table managed by the server 102 of this embodiment.
The screen table 410 is a table for managing screens, and has columns of "screen ID (primary key)" and "screen name". When a screen is created on the layout creation screen 700 (FIG. 7) for creating the screen layout of the application, a record is registered in the screen table 410 .

The screen component table 420 is a table for managing components arranged on the screen, and includes “screen ID”, “component ID”, “x coordinate”, “y coordinate”, “component type”, “component name”, “number of characters”, “essential”, “component It has columns of attribute 1, part attribute 2, and so on. A record is registered in the screen component table 420 when screen components are arranged on the layout creation screen 700 for creating the screen layout of the application and the save button 719 is pressed.

The "x-coordinate" and "y-coordinate" stores the position where the component is arranged, and the "component type" stores the type of the component such as a text box, radio button, select box, and the like. Also, "part attribute 1", "part attribute 2", and so on can have different attribute values for each "part type". Note that the component IDs of the components 825 to 828 on the copy source screen 823, the component IDs of the components 829 to 832 on the copy destination screen 821, and the values of reflection check boxes 833 to 836, which will be described later, are also included in this "component attribute n". Remember.

Each of the customer master table 430, product master table 440, and sales transaction table 450 stores records registered on created screens (customer master registration screen 720, product master registration screen 730, and sales transaction registration screen 1010). table.
The customer master table 430 is a master table for managing customer information, and has columns of "customer ID (primary key)", "customer name", "address", "telephone", and "mail".
The product master table 440 is a master table for managing product information, and has columns of "product ID (primary key)", "product name", and "unit price".

The sales transaction table 450 is a transaction table for managing sales details, and includes "sales number (primary key)", "sales date", "product ID", "product name", "quantity", "unit price", "subtotal", "customer ID", " It has columns of customer name, address, telephone, and email.

In the case of a normal database, the sales transaction table 450 normalizes data by subordinating the customer master table 430 and the product master table 440 with the "product ID" and "customer ID" as foreign keys. However, in the case of the mechanism of creating transaction data by copying the master data as in this embodiment, the data is not normalized and duplicated with the customer master table 430 and the product master table 440, the sales transaction table 450 also has columns of "product name", "quantity", "unit price", "subtotal", "customer name", "address", "telephone", and "mail". The reason why the data is duplicated in the database in this way is that the association between the screen layout and the data is emphasized rather than the normalization of the data.

FIG. 7 is a diagram showing an example of a screen for creating a screen displayed by the information processing apparatus 101 according to the first embodiment. The layout creation screen 700 consists of a screen parts section 701 and a parts arrangement section 702 .

Icons (buttons) of screen components to be arranged on the screen are displayed in the screen component section 701 . By dragging these icons and dropping them onto the component arrangement section 702 , screen components can be arranged on the screen. can. The screen components include a text 711 (called a label, etc.) that displays characters, a text box 712, a text area 713, a radio button 714, a check box 715, a select box 716, and another screen data copy that refers to the data value of another screen. 717 (called lookup, etc.), button 718, and the like.

By placing a screen component in the component placement section 702 and pressing a save button 719 , information about the placed screen component is transmitted to the server 102 and stored in the screen component table 420 .

FIG. 5 is a flowchart illustrating an example of screen creation processing according to the first embodiment. Processing for creating a screen will be described with reference to FIG.
In step S501, the CPU 201 of the information processing apparatus 101 accepts login of a user who creates a screen.
In step S502, the CPU 201 of the information processing apparatus 101 receives an operation for creating a screen. Specifically, pressing of a screen creation button is accepted from a displayed menu (not shown).
In step S<b>503 , the CPU 201 of the information processing apparatus 101 transmits a screen creation request to the server 102 .
In step S504, the CPU 201 of the server 102 receives a screen creation request.
In step S505, the CPU 201 of the server 102 generates screen information for screen creation.
In step S<b>506 , the CPU 201 of the server 102 transmits the generated screen information to the information processing apparatus 101 .
In step S507, the CPU 201 of the information processing apparatus 101 receives screen information for screen creation.
In step S508, the CPU 201 of the information processing apparatus 101 uses the received screen information to display the layout creation screen 700 (FIG. 7).

In step S<b>509 , the CPU 201 of the information processing apparatus 101 receives a screen creation operation and makes a determination. If the part has been placed, the process proceeds to step S510; if the set button has been pressed, the process proceeds to step S511; if the save button has been pressed, the process proceeds to step S518.

In step S<b>510 , the CPU 201 of the information processing apparatus 101 displays the screen component dragged from the screen component section 701 at the drop position of the component placement section 702 . Here, it is assumed that screen components (721 to 728) are arranged as shown in 720 in FIG. 7 as the layout of the customer master registration screen. Similarly, assume that screen components (731 to 737) are arranged as shown in 730 in FIG. 7 as the layout of the sales transaction registration screen.

It should be noted that the screen component for the product ID 731 and the customer ID 734 in FIG. 7 is the other screen data copy 717 . The other screen data copy 717 can refer to and copy the data of the other screen by pressing the select button when the screen is executed. When the selection button 732 is pressed during execution of the screen, the data of the product master table 440 can be referenced, and when the selection button 735 is pressed during execution of the screen, the data of the customer master table 430 can be referenced and copied. That is, step S510 is a step showing an example of processing for arranging a data selection component for selecting registered data registered in the database on the layout editing screen.

In step S511, the CPU 201 of the information processing apparatus 101 displays attribute setting screens (810 and 820 in FIG. 8) of the arranged screen components. For example, when the setting button 723 in FIG. 7 is pressed, the attribute setting screen 810 is displayed, and when the setting button 736 in FIG. 7 is pressed, the attribute setting screen 820 is displayed.

In step S<b>512 , the CPU 201 of the information processing apparatus 101 receives an input for component attribute settings. That is, step S512 is a step showing an example of a process of receiving a setting as to whether or not to update each item included in registered new data when it is determined that the registered data has been updated. is. Specifically, the attribute setting screen 810 accepts input of a component name 812 , number of characters 813 , mandatory check box 814 , and pressing of a completion button 815 . Also, the attribute setting screen 820 accepts input of a component name 822 .

In step S513, the CPU 201 of the information processing apparatus 101 determines whether or not the component is another screen data copy component. In the case of the attribute setting screen of the other screen data copy component, the process proceeds to step S514, and in the case of the attribute setting screen other than the other screen data copy component, the process proceeds to step S517.

In step S514, the CPU 201 of the information processing apparatus 101 accepts selection of the screen name 823 and the part name 824 of the other screen to be copied. By setting 823 and 824 in FIG. 8, when executing the sales transaction registration screen 1010, by selecting the customer ID of the data registered on the customer master registration screen (that is, the customer master table 430), it is copied to the customer ID 1027. be able to

Specifically, when the selection button 1028 is pressed during execution of the sales transaction registration screen 1010, the customer master search screen 1050 is displayed. , closes the customer master search screen 1050, acquires the value of "customer ID" of the selected data, and displays it in the "customer ID 1027" text box.

Similarly, when the sales transaction registration screen 1010 is executed, if the selection button 1022 is pressed, the product master search screen 1040 is displayed. The master search screen 1040 is closed, the value of the "product ID" of the selected data is obtained, and displayed in the "product ID 1021" text box.

In step S<b>515 , the CPU 201 of the information processing apparatus 101 accepts selection of copying to another part as the copy destination. Specifically, selection of components 825 to 828 on the copy source screen 823 and components 829 to 832 on the copy destination screen 821 is accepted. By setting 825 to 832 in FIG. 8, when executing the sales transaction registration screen 1010, by selecting the customer ID of the data registered on the customer master registration screen (that is, the customer master table 430), other than the selected record The values of the columns (825-828) can now be copied to the parts 829-832 of the copy destination screen.

Specifically, when the selection button 1028 is pressed during execution of the sales transaction registration screen 1010, the customer master search screen 1050 is displayed. , close the customer master search screen 1050, acquire the values of "customer name", "address", "telephone number", and "mail" of the selected data, 1032" text boxes.

Similarly, when the sales transaction registration screen 1010 is executed, if the selection button 1022 is pressed, the product master search screen 1040 is displayed. The master search screen 1040 is closed, and the values of "product name" and "unit price" of the selected data are acquired and displayed in the text boxes of "product name 1023" and "unit price 1025", respectively.

In step S<b>516 , the CPU 201 of the information processing apparatus 101 receives a selection as to whether or not to reflect the value update of the copy source to other parts of the copy destination. That is, step S516 is a step showing an example of a process of receiving a setting as to whether or not to update new registered data when it is determined that the registered data has been updated.

Specifically, selection of reflection check boxes 833 to 836 is accepted. When the value of the part name 824 on the copy source screen 823 is updated by the settings of 833 to 836 in FIG. You can decide whether to In other words, among the reflection check boxes 833 to 836, the values of the copy source are reflected to the copy destination components for the components that are checked, and the values of the copy source are not reflected to the copy destination components for the unchecked components. can be set as

As a result, when the value of the copy source is updated, it is possible to set whether or not to reflect it on the copy destination for each part. For example, for information such as urgent contact information such as "telephone" and "email", update the customer master (copy source) is reflected in other transactions (copy destination), such as "customer name", "address", etc. For information that you want to keep as a record at the time of transaction registration, it is possible to operate flexibly such that the update of the customer master (copy source) is not reflected in other transactions (copy destination).

In step S<b>517 , the CPU 201 of the information processing apparatus 101 stores in the RAM 202 the screen components arranged in the component placement section 702 and the attributes set on the attribute setting screen.
In step S<b>518 , the CPU 201 of the information processing apparatus 101 acquires the created screen information from the RAM 202 and transmits it to the server 102 .
In step S519, the CPU 201 of the server 102 receives the created screen information.

In step S520, CPU 201 of server 102 stores the received screen information. Specifically, the screen name included in the received screen information is stored in the screen table 410 . Also, the information of the placed screen components (placement position, component type, number of characters, essential check boxes, and other component attributes (for example, 823 to 836 in FIG. 8)) are stored in the screen component table 420. FIG.

In step S521, the CPU 201 of the server 102 determines the presence or absence of reflection. Specifically, if one of the reflection check boxes 833 to 836 is checked, the process proceeds to step S522, and if not checked, the process proceeds to step S524.

In step S522, the CPU 201 of the server 102 generates a reflection trigger according to the values of the components 825 to 828 of the copy source screen 823 and the components 829 to 832 of the copy destination screen 821 corresponding to the checked reflection check boxes 833 to 836. create. For example, as shown in 820 in FIG. 8, if 835 and 836 of the reflection check boxes 833 to 836 are checked, the CPU 201 of the server 102 creates a DB trigger such as the reflection trigger 1301 (FIG. 13). do.

Note that the UPDATE statement in the second half of the reflection trigger 1301 corresponds to the checked reflection check boxes 833 to 836, and describes such as "part name of copy destination screen 821=part name of copy source screen 823". As a result, the value of the data of the copy source screen can be reflected in the data of the copy destination screen according to the value of the reflection check box.

In step S523, the CPU 201 of the server 102 sets the reflection trigger 1301 created in step S522 in the database. That is, step S523 is a step showing an example of processing for managing settings as to whether or not to update new registered data when it is determined that registered data has been updated. Further, in step S523, when it is determined that the registered data has been updated, among the registered new data, for each item included in the new data, the setting of whether or not to update is managed. It is a step showing an example of

When the data of the copy source screen 823 (customer master table 430) is updated by this reflection trigger 1301, the updated value can be reflected in the data of the copy destination screen 821 (sales transaction table 450). .

In this embodiment, the value of the updated data of the copy source screen 823 is reflected in the data of the copy destination screen 821 by the DB trigger. By generating a program such as JavaScript (registered trademark) that produces the same result as , and including this program in the screen information of the copy source screen 823, when the information processing apparatus 101 executes the copy source screen 823, it is displayed on the screen. By executing this program in the information processing apparatus 101 triggered by the fact that the stored data has been updated (step S611), the information processing apparatus 101 requests the data of the copy destination screen 821 to be updated (step S613). ), etc.

Steps S611 and S613 in this case are steps showing an example of processing for requesting update of new data values when update of registered data values is requested. In addition, steps S611 and S613 in this case are executed to determine whether or not to update the new data defined for each item included in the new data when the update of the value of the registered data is requested. These are steps showing an example of processing for requesting updating of the values of items included in the new data in accordance with the settings.

In step S524, the CPU 201 of the server 102 builds a web application that displays and executes the screen information received in step S519. That is, step S524 is a step showing an example of processing for constructing an application screen including a data selection component for selecting registered data registered in the database.
In step S525, the CPU 201 of the server 102 activates the constructed web application.
This is the end of the description of the screen creation process in FIG.

FIG. 6 is a flowchart illustrating an example of screen utilization processing according to the first embodiment. Processing using the created screen will be described with reference to FIG. The information processing device 101 in FIG. 5 is a device used by a developer who creates an application screen, and the information processing device 101 in FIG. 6 is a device used by an end user who uses the application. In the present invention, the information processing apparatus 101 in FIG. 5 and the information processing apparatus 101 in FIG. 6 are assumed to be the same apparatus, but they may be different apparatuses.
In step S<b>601 , the CPU 201 of the information processing apparatus 101 accepts login of a user who uses the created screen.

In step S602, the CPU 201 of the information processing apparatus 101 accepts an operation using the screen. Specifically, from the displayed menu (not shown), pressing of a link to transition to the screen to be used is accepted.
In step S<b>603 , the CPU 201 of the information processing apparatus 101 transmits a screen utilization request to the server 102 .
In step S604, the CPU 201 of the server 102 receives a screen usage request.

In step S605, the CPU 201 of the server 102 generates screen information of the requested screen. Specifically, the screen information is generated using the screen table 410 and the screen component table 420 . That is, step S605 is a step showing an example of processing for generating screen information of an application screen including a data selection component for selecting registered data registered in the database.
In step S<b>606 , the CPU 201 of the server 102 transmits the generated screen information to the information processing apparatus 101 .
In step S607, the CPU 201 of the information processing apparatus 101 receives screen information for screen creation.

In step S608, the CPU 201 of the information processing apparatus 101 uses the received screen information to display a screen (for example, the customer master registration screen 910 in FIG. 9 and the sales transaction registration screen 1010 in FIG. 10). That is, step S608 is a step showing an example of processing for displaying an application screen including a data selection component for selecting registered data registered in the database constructed using the layout editing screen. In this embodiment, the screen displayed in step S608 is a data registration screen such as the customer master registration screen 910 and the sales transaction registration screen 1010. However, the screen is not limited to this. A data list screen or a data search screen such as the list screen 930 and the sales transaction list screen 1060 may be used.

In step S609, the CPU 201 of the information processing apparatus 101 accepts a screen operation and makes a determination. If the data registration button (934 in FIG. 9, 1054 in FIG. 10) is pressed, the process proceeds to step S610; if the data edit button (935 in FIG. 9, 1065 in FIG. 10) is pressed, the process proceeds to step S611; If the data search button (936 in FIG. 9, 1066 in FIG. 10) has been pressed, the process proceeds to step S612, and if the close button (not shown) has been pressed, this screen utilization process ends.

In step S610, the CPU 201 of the information processing apparatus 101 displays a data registration screen (for example, the sales transaction registration screen 1010) and accepts data input.

In step S611, the CPU 201 of the information processing apparatus 101 displays the data selected by the edit button on the data editing screen (for example, the sales transaction registration screen 1020) and accepts data editing.

It should be noted that, in the data input in step S610 or data editing in step S611, if pressing of the other screen data copy component selection button (1022, 1028 in FIG. 10) is received, as described in the description of step S515, Display the value of the component on the copy source screen in the component on the copy destination screen. That is, steps S610 and S611 are steps showing an example of processing for selecting data from registered data using the data selection component displayed on the constructed application screen. Steps S610 and S611 are steps showing an example of processing for selecting data from registered data using the data selection component displayed on the displayed application screen.

In step S612, the CPU 201 of the information processing apparatus 101 creates a search condition using the value entered in the search item on the data list screen (for example, the sales transaction list screen 1060).

In step S613, the CPU 201 of the information processing apparatus 101 transmits a registration/update/search request to the server 102 according to the accepted screen operation. That is, step S613 is a step showing an example of processing for requesting registration in the database as new data using the value of the selected registered data. Further, step S613 is a step showing an example of processing for requesting update of the value of the selected registered data.

In step S614, the CPU 201 of the server 102 receives and determines the request. In the case of data registration, the process proceeds to step S615, in the case of data search, the process proceeds to step S616, and in the case of data update, the process proceeds to step S617.

In step S615, CPU 201 of server 102 registers the data in the table according to the received data registration request. That is, step S615 is a step showing an example of processing for registering new data in the database using the value of the registered data selected using the data selection component included in the screen information of the generated application screen. be. Specifically, when the registration button 1033 is pressed and a data registration request is received, the values entered in the sales transaction registration screen 1020 are used to register in the sales transaction table 450 .

In step S616, CPU 201 of server 102 searches the table according to the received data search request. Specifically, when the search button 1066 is pressed and a data search request is received, the sales transaction table 450 is searched using the search conditions entered in the search condition section 1061 of the sales transaction list screen 1060 .

In step S617, CPU 201 of server 102 updates the data in the table according to the received data update request. Specifically, when the update button is pressed and a data update request is received, the value entered in the sales transaction registration screen 1020 is used to update the corresponding data in the sales transaction table 450 .

That is, at step S610 or step S611, the value of the component on the copy source screen is displayed on the component on the copy destination screen using the other screen data copy component selection button. When updating is performed, steps S610, S611, S615, and S617 are performed as new data using the values of the registered data selected using the data selection component included in the constructed application screen. It is a step which shows an example of the process of registering in a database.

In step S618, the CPU 201 of the server 102 determines whether the updated data is a reflection trigger. That is, step S618 is a step showing an example of processing for determining whether or not registered data has been updated. Further, step S618 is a step showing an example of processing for determining whether or not new data has been updated.

In addition, since the screen component table 420 stores the values of the reflection check boxes 833 to 836 as component attributes, when it is determined that the registered data has been updated, whether to update the new registered data or not is determined. It is an example of means for managing the setting of whether or not. Also, the screen component table 420 is an example of means for managing settings as to whether or not to update each item included in registered new data when it is determined that the registered data has been updated. is.

Specifically, it is determined whether or not a reflection trigger associated with data update is set. If it is set, the process proceeds to step S619; otherwise, the process proceeds to step S620. For example, in the case of a DB trigger like the reflection trigger 1301, it is determined whether or not a table whose data has been updated is described in the UPDATE ON clause among the DB triggers registered in the database.

In step S619, the CPU 201 of the server 102 executes a reflection trigger associated with the data update. That is, steps S618 and S619 update the new data if it is determined that the registered data has been updated and if the new data is managed to be updated. This is a step showing an example of processing for controlling not to update the new data when the new data is managed as not to be updated.

Further, in steps S618 and S619, when it is determined that the registered data has been updated, among the new data, the values of the items managed to be updated are updated. This is a step showing an example of processing for controlling not to update the value of an item managed as not to be updated among new data.

Further, in steps S618 and S619, when it is determined that the registered data has been updated, among the new data, the values of the items stored as being updated are updated. This is a step showing an example of processing for controlling not to update the value of an item stored as not to be updated among new data.

For example, in the case of the reflection trigger 1301, the table name described in the UPDATE ON clause is the customer master table 430, so when the record of the customer master table 430 is updated, this reflection trigger 1301 is executed. When the data of the copy source screen 823 (customer master table 430) is updated by executing this reflection trigger 1301, the updated values are reflected in the data of the copy destination screen 821 (sales transaction table 450).

In step S620, the CPU 201 of the server 102 generates screen information to be displayed after performing registration/update/search, and transmits the screen information to the information processing apparatus 101 (step S606).
This is the end of the description of the screen utilization processing in FIG.

FIG. 11 is a diagram showing an example of a screen for editing master data using a created screen in the information processing apparatus 101 of the first embodiment. FIG. 12 is a diagram showing an example of a screen displaying transaction data using a created screen in the information processing apparatus 101 of the first embodiment.
The difference between before and after application of the present invention will be described with reference to FIGS. 11 and 12. FIG.

The information processing apparatus 101 accepts pressing of the edit button 1111 on the customer master list screen 1110 (FIG. 11) by the screen user, and displays the customer master edit screen 1120 (step S608). Data update such as the customer master edit screen 1130 and pressing of the save button 1131 by the screen user are accepted (step S611). The server 102 updates the customer master table 430 (step S617) and generates screen information for the customer master list screen (step S620). The information processing device 101 displays a customer master list screen 1140 .
This customer master list screen 1140 naturally reflects the values updated on the customer master edit screen 1130 (1141 in FIG. 11).

The sales transaction list screen 1210 in FIG. 12 is a screen to which the present invention is not applied. Therefore, the values updated on the customer master edit screen 1130 are not reflected in 1211 and 1212, and the "problem to be solved by the invention" cannot be cleared. The sales transaction list screen 1210 is the same result as when all of the reflection check boxes 833 to 836 in FIG. 8 are set to OFF.

Also, the sales transaction list screen 1220 in FIG. 12 is a screen to which the present invention is applied. Therefore, the values updated on the customer master edit screen 1130 are reflected in 1221 and 1222, and the "problem to be solved by the invention" has been cleared.

As described above, it is possible to build an application that reflects the update of the copy source data to the copy destination data. It is possible to provide a mechanism for building.

[Second embodiment]
The first embodiment is a mechanism for constructing an application that reflects the update of the copy source data to the copy destination data, and the second embodiment constructs an application that reflects the update of the copy destination data to the copy source data. It's how it works. According to the second embodiment, it is possible to provide a mechanism for constructing an application that easily maintains consistency between copy source data and copy destination data generated by using an application.

A second embodiment will be described with reference to FIGS. 14 to 18. FIG.
FIG. 14 is a flowchart illustrating an example of screen creation processing according to the second embodiment. In the second embodiment, the flowchart of FIG. 5 in the first embodiment is replaced with FIG. 14, and the same step numbers are assigned to the same processes as in the first embodiment, and description thereof is omitted.

FIG. 15 is a diagram showing an example of a screen for setting component attributes of the screen displayed by the information processing apparatus 101 according to the second embodiment. In the second embodiment, the screen of FIG. 8 in the first embodiment is replaced with that of FIG. 15, and the same items as those in the first embodiment are given the same item numbers, and description thereof is omitted.
FIG. 16 is a diagram showing an example of a reflection trigger created by the server 102 of the first embodiment.

In step S1401, the CPU 201 of the information processing apparatus 101 accepts a selection as to whether or not to reflect the value update of the copy destination to other parts of the copy source. That is, step S1401 is a step showing an example of processing for managing settings as to whether or not to update registered data selected using a data selection component when it is determined that new data has been updated. .

Specifically, selection of reflection check boxes 1501 to 1504 (FIG. 15) is accepted. When the value of the part name 822 on the copy destination screen 821 is updated by setting 1501 to 1504 in FIG. You can decide whether to That is, among the reflection check boxes 1501 to 1504, the values of the copy destination are reflected to the copy source components for the components that are checked, and the values of the copy destination are not reflected to the copy source components for the unchecked components. can be set as

As a result, when the value of the copy destination is updated, it is possible to set whether or not to reflect it in the copy source for each part. For example, if the delivery person who delivered the product noticed an error in items such as "customer name", "address", and "telephone" and updated the sales transaction, the update of the sales transaction (copy destination) should be performed in the customer master (copy source). etc., and for items that the deliverer cannot notice, such as "mail", even if the deliverer updates the sales transaction, the update of the sales transaction (copy destination) is reflected in the customer master (copy source), etc. It is possible to build an application that can be operated flexibly such as not to

In step S522 (FIG. 14), the CPU 201 of the server 102 creates a DB trigger like the reflection trigger 1601 (FIG. 16).
Note that the UPDATE statement in the second half of the reflection trigger 1601 corresponds to the checked reflection checkboxes 1501 to 1504, and describes such as "part name of copy source screen 823=part name of copy destination screen 821". As a result, the value of the data of the copy destination screen can be reflected in the data of the copy source screen according to the value of the reflection check box.

Therefore, step S523 (FIG. 14) is an example of processing for managing settings as to whether or not to update registered data selected using a data selection component when it is determined that new data has been updated. are the steps shown. Further, step S619 executed in the second embodiment updates the registered data if it is determined that the new data has been updated and the registered data is managed to be updated. On the other hand, when the registered data is managed so as not to be updated, it is a step showing an example of processing for controlling not to update the registered data.

Further, in step S1401, in addition to the selection of reflection check boxes 1501 to 1504, selection of a check box 1506 "reflect even when copy source record status is complete" is accepted. If this check box 1506 is not selected, the status of the target record in the customer master (copy source) is changed to " It can be set not to be reflected when "Completed".

Therefore, step S523 (FIG. 14) is a step showing an example of management processing for setting whether to update the registered new data according to the status of the new data. Further, in step S619 executed in the second embodiment, when it is determined that the registered data has been updated, and when it is stored as updating the new data according to the status of the new data, , controls whether or not to update the new data according to the status, and on the other hand, if stored as not to update the new data according to the status of the new data, the These are steps showing an example of processing for controlling whether or not to update new data.

As a result, in the customer master (copy source), for data whose status is "completed" (for example, data logically deleted due to withdrawal etc.), even if the sales transaction (copy destination) data is updated can also be set not to be reflected in the customer master (copy source), it is possible to build an application that can control whether or not to reflect the update according to the status of the customer master (copy source) data.

Likewise, the WHERE statement in the second half of the reflection trigger 1301 (FIG. 13) is changed depending on whether or not the check box 1505 "reflect even if the status of the copy destination record is complete" is checked.

As a result, even if the customer master (copy source) data is However, since it can be set not to be reflected in the sales transaction (copy destination), it is possible to build an application that can control whether or not to reflect the update according to the status of the sales transaction (copy destination) data.

FIG. 17 is a flowchart illustrating an example of screen utilization processing according to the second embodiment. In the second embodiment, the flowchart of FIG. 6 in the first embodiment is replaced with FIG. 17, and the same step numbers are assigned to the same processes as in the first embodiment, and the description thereof is omitted.

In step S1701, the CPU 201 of the server 102 acquires registered trigger information regarding the requested screen. That is, step S1701 is a step showing an example of processing for acquiring setting information for updating new stored data. Specifically, among the reflection triggers created in step S522 (FIGS. 5 and 14), the reflection trigger sentence containing the screen name of the requested screen is acquired.

In step S1702, the CPU 201 of the server 102 generates screen information for the requested screen. That is, step S1702 is a step showing an example of processing for generating screen information indicating the update relationship between registered data and new data according to the acquired setting information. Specifically, among the reflection triggers acquired in step S1701, the screen name of the requested screen is described in part 1602 or 1603 in FIG. Screen information that indicates the relationship of data reflection is generated according to the item name of the part.

In step S608 (FIG. 17), the CPU 201 of the information processing apparatus 101 uses the received screen information to display the screen (for example, sales transaction edit screen 1810, sales transaction edit screen 1820, and customer master list screen 1830 in FIG. 18). indicate.

Here, FIG. 18 will be explained.
FIG. 18 is a diagram showing an example of a screen for displaying master data using a created screen in the information processing apparatus 101 of the second embodiment.
When the values of "address 1811" and "telephone number 1812" on the sales transaction edit screen 1810, which is the copy destination screen, are changed as shown in the sales transaction edit screen 1820 and the values are updated by pressing the save button 1823, step The copy source screen data (customer master table 430) is updated by the reflection trigger 1601 (FIG. 16) created in S522 (FIG. 14). As a result, the value of the record 1831 of the customer master list screen 1830, which is the copy source screen, is updated and displayed.

This makes it possible to provide a mechanism for constructing an application that easily maintains consistency between copy source data and copy destination data generated by using the application.
This completes the description of FIG.

In step S1703, the CPU 201 of the information processing apparatus 101 displays information indicating the relationship of data reflection using the screen information indicating the relationship of data reflection generated in step S1702 (FIG. 19).

Here, FIG. 19 will be explained.
FIG. 19 is a diagram showing an example of a screen displaying relationships of data reflection in the information processing apparatus 101 of the second embodiment.
A customer master list screen 1910 displays information such as 1911 and 1912 indicating the relationship of data reflection.
The information indicating the relevance of data reflection is whether the screen name of the requested screen is described in 1602 or 1603 in FIG. This is the screen information generated in step S1702 according to the item name.

1911 is information indicating the relationship of data reflection between the sales transaction table 450 and the customer master table 430, and 1912 is information indicating the relationship of data reflection between the point master table (not shown) and the customer master table 430. is.
A procedure for generating the screen information 1911 in step S1702 using the reflection trigger 1601 (FIG. 16) will be described.

Since the screen to be displayed at present is the "customer master list screen 1910", the reflection trigger 1601 having this screen name "customer master" in 1603 (FIG. 16) is acquired in step S1701.

Since 1602 of the reflection trigger 1601 describes "sales transaction table", screen information 1911 showing the relationship of data reflection between the sales transaction table 450 and the customer master table 430 is generated.

1604 of the reflection trigger 1601 describes that the value of the sales transaction table 450 is reflected to the value of the customer master table 430, so the item names described in 1604 are "customer name", "address", and "telephone". is generated, the screen information 1911 displaying "→" indicating that it is reflected in the direction from the sales transaction table 450 to the customer master table 430 is generated.
Similarly, a procedure for generating screen information 1911 in step S1702 using the reflection trigger 1301 (FIG. 13) will be described.

Since the screen to be displayed at present is the "customer master list screen 1910", the reflection trigger 1601 having this screen name in 1302 (FIG. 13) is obtained in step S1701.

Since 1303 of the reflection trigger 1301 describes "sales transaction table", screen information indicating the relationship of data reflection between the sales transaction table 450 and the customer master table 430 is generated.

1304 of the reflection trigger 1301 describes that the value of the customer master table 430 is reflected in the value of the sales transaction table 450. It generates screen information that displays "←" indicating that it is reflected in the direction of the table 450←customer master table 430.
As for "telephone", since both directions of "→" and "←" overlap, "→", "→", "⇔", and "←" are displayed as in 1911 instead of the display of "⇔".

As a result, on a list screen such as the customer master list screen 1910, it is possible to display information indicating the relationship of data reflection with other screens (or tables that hold screen data). Information (1921 and 1922) indicating the relationship of data reflection can also be displayed on a detail display screen such as the customer master edit screen 1920 that will be displayed later.

Therefore, it is possible to provide a mechanism for constructing an application that can easily identify the relationship between copy source data and copy destination data generated by using the application.

As described above, it is possible to provide a mechanism for constructing an application that easily maintains consistency between copy source data and copy destination data generated by using the application.

As described above, a recording medium recording a program for realizing the functions of the above-described embodiments is supplied to a system or device, and the computer (or CPU or MPU) of the system or device reads the program stored in the recording medium. Needless to say, the object of the present invention can also be achieved by reading and executing.

In this case, the program itself read from the recording medium implements the novel functions of the present invention, and the recording medium recording the program constitutes the present invention.

Examples of recording media for supplying programs include flexible disks, hard disks, optical disks, magneto-optical disks, CD-ROMs, CD-Rs, DVD-ROMs, magnetic tapes, non-volatile memory cards, ROMs, EEPROMs, silicon A disk or the like can be used.

Further, by executing the program read by the computer, not only the functions of the above-described embodiments are realized, but also based on the instructions of the program, the OS (operating system) and the like running on the computer are actually executed. Needless to say, a case where part or all of the processing is performed and the functions of the above-described embodiments are realized by the processing are included.

Furthermore, after the program read from the recording medium is written in the memory provided in the function expansion board inserted into the computer or the function expansion unit connected to the computer, the function expansion board is read according to the instruction of the program code. It goes without saying that a case where a CPU or the like provided in a function expansion unit performs part or all of the actual processing and the functions of the above-described embodiments are realized by the processing.

Moreover, the present invention may be applied to a system composed of a plurality of devices or to an apparatus composed of a single device. Further, it goes without saying that the present invention can be applied to the case where it is achieved by supplying a program to a system or apparatus. In this case, by loading a recording medium storing a program for achieving the present invention into the system or device, the system or device can enjoy the effects of the present invention.

The program may be in the form of object code, program code executed by an interpreter, script data supplied to an OS (operating system), or the like.

Furthermore, by downloading and reading out the program for achieving the present invention from a server, database, etc. on the network using a communication program, the system or device can enjoy the effects of the present invention. It should be noted that all configurations obtained by combining each of the above-described embodiments and modifications thereof are also included in the present invention.

100 information processing system 101 information processing device 102 server 103 network

Claims (9)

the computer,
selection receiving means for receiving a selection of an item to be used for new data to be registered with the registered data as a reference from the items included in the registered data;
Setting whether to update new data registered with the registered data as a reference when the value of the item of the registered data is updated for the item whose selection is accepted by the selection accepting means setting receiving means for receiving
An application is constructed that controls whether or not the new data is updated using the updated registered data according to the update of the registered data, based on the setting received by the setting receiving means. A program to function as a control means to control. The control means is
When the registered data is updated and the setting receiving means receives a setting to update new data, the new data is updated, and the setting receiving means updates the new data. 2. The program according to claim 1, wherein when a setting not to update is accepted, control is performed so that an application that suppresses update of the new data is constructed. The setting reception means
receiving a setting as to whether to update the new data based on the status of the new data when the registered data is updated;
The control means is
When the registered data is updated and the setting receiving means receives a setting to update the new data based on the status of the new data, the updating of the new data is controlled based on the status. On the other hand, if the setting receiving means receives a setting not to update the new data according to the status of the new data, control is performed so that an application that controls updating of the new data is constructed regardless of the status. 3. The program according to claim 1 or 2, characterized by: 4. The system according to any one of claims 1 to 3, further functioning as generating means for generating screen information indicating the relationship between updates in said registered data and said new data based on the settings received by said setting receiving means. program as described. the computer,
selection receiving means for receiving a selection of an item to be used for new data to be registered with the registered data as a reference from the items included in the registered data;
Whether or not to update the other when either the registered data or new data registered based on the registered data is updated for the item for which the selection is accepted by the selection acceptance means setting receiving means for receiving settings of
as a control means for controlling so that, when either one of the registered data and the new data is updated, an application for controlling updating of the other data is constructed based on the setting received by the setting receiving means A program to make it work. A control method in a computer, comprising:
a selection receiving step of receiving a selection of items to be used for new data to be registered with the registered data as a reference from the items included in the registered data;
Setting whether to update new data registered with the registered data as a reference when the value of the item of the registered data is updated for the item whose selection is accepted by the selection accepting step a setting reception step that receives
An application is constructed that controls whether or not the new data is updated using the updated registered data according to the update of the registered data, based on the setting accepted by the setting accepting step. A control method characterized by executing a control step of controlling. A control method in a computer, comprising:
a selection receiving step of receiving a selection of items to be used for new data to be registered with the registered data as a reference from the items included in the registered data;
Whether or not to update the other when either the registered data or new data registered based on the registered data is updated for the item for which the selection is accepted in the selection acceptance step a setting reception step for receiving the setting of
a control step for controlling, when one of the registered data and the new data is updated, building an application for controlling updating of the other based on the setting accepted by the setting accepting step; A control method characterized by executing selection receiving means for receiving a selection of an item to be used for new data to be registered with the registered data as a reference from the items included in the registered data;
Setting whether to update new data registered with the registered data as a reference when the value of the item of the registered data is updated for the item whose selection is accepted by the selection accepting means setting receiving means for receiving
control to construct an application that controls whether or not the new data is updated using the updated registered data according to the update of the registered data, based on the setting received by the setting receiving means; and a control means for controlling the information processing apparatus. selection receiving means for receiving a selection of an item to be used for new data to be registered with the registered data as a reference from the items included in the registered data;
When either one of the registered data and new data registered based on the registered data is updated for the item whose selection is accepted by the selection accepting means, whether to update the other setting receiving means for receiving a setting as to whether or not
and a control means for controlling, when one of said registered data and said new data is updated, building an application for controlling updating of said other data based on the setting received by said setting receiving means. An information processing device comprising:

Images