JPH1115650A - System construction support device - Google Patents

Abstract

(57) [Summary] [PROBLEMS] For example, Access exists as an application program for supporting the construction of a system using a conventional database, but Access refers to an asset created by an application having no OLE function. Or could not be combined with the data on the database. SOLUTION: The system construction support device of the present invention registers a relation between a data table 20, a query table 21, and a form information table 22 in a related information table 23, and registers data 16, 17 created by another application group. Information for combining with the data stored in the data table 20 is registered. The execution procedure generation unit 9 refers to the related information table 23 and, for example, Auto CAD5
b, it is possible to display the data in the data table 20 on the drawing and to display the drawing linked to the data.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

[0001] 1. Field of the Invention [0002] The present invention relates to a system construction supporting apparatus for assisting a user to construct a system for managing data such as character information, graphic information, image information, and voice information. In particular, the present invention relates to a system construction support device that arbitrarily associates data created by different application programs.

[0002]

2. Description of the Related Art Microsoft Access (Mic) is a conventional system construction support application.
Microsoft Access is a registered trademark of Microsoft Corporation. (Hereinafter referred to as Access). A
Access is a system that manages a relational database, and is an application program that assists a user in easily searching, organizing, and utilizing information. Access manages a plurality of tables, which are sets of data on a specific theme. It also manages information about how the tables are related to each other. Therefore, FIG. 30 (FIG. 30 shows Access
(Excerpt from User's Guide P36), associating a supplier table with a product table by a supplier code which is a field of the supplier table, for example, a product whose stock is reduced to 10 cases or less By searching from the table, the supplier name and the person in charge of the supplier can be acquired from the supplier table and displayed based on the specified supplier code. However, it is necessary to create a query for searching and create a form for displaying the search result. FIG. 31 shows the result of the search. Also, Acc
In ess, OLE (Object Linking)
Embedding function (OLE function is a certain Wi
Windows application objects to other Wi
(This is a function for embedding or linking in a document of the Windows application), and objects such as pictures, graphs, and worksheets created by other applications can be added to forms and reports. In addition to reading objects,
It can be edited directly on the ces form and report. For example, a paint brush (paint brush is M
A picture created by Microsoft (registered trademark) can be displayed by being linked to a form [product category]. FIG. 32 provides a field called “figure” for holding objects in the product classification table,
This indicates that the picture corresponding to the product category is stored in the field “figure”. FIG. 33 shows a form created based on the product classification table as shown in FIG.
The form shown in FIG.
The picture specified in the field is drawn in the connected object frame.

In Access, when a form having functions such as buttons is created, a user performs programming.

[0004]

In the Access described in the above conventional example, an object created by another application using the OLE function can be read into the Access or edited. Thus, A
Access can link objects created by applications that support OLE.
However, to link objects created by applications that do not support OLE, use Vi
sual Basic (Visual Basic
Access using Microsoft (registered trademark)
The user had to program to link the object from ss. For this reason, it is necessary for the user to understand the specifications of Visual Basic, and there is a problem that it takes time and cost to construct the system depending on the technical level of the user.

In order to create a form having functions such as buttons, the user must perform programming. Therefore, the user needs to understand the specifications of Visual Basic, and a period during which the system is constructed according to the technical level of the user. And costly.

SUMMARY OF THE INVENTION The present invention has been made to solve the above-mentioned problem, and when linking an object created by another application from a predetermined application, even if the other application does not support OLE. It is an object of the present invention to provide a system construction support apparatus that realizes object linking without programming by a user and can construct a system.

Another object of the present invention is to create a form having a function such as a button by saving the user the trouble of creating a program and constructing an efficient system.

[0008]

A system construction supporting apparatus according to the present invention has the following elements. (A) a data input section for inputting data, (b) a data table for storing data input from the data input section, and (c) a screen form for displaying data stored in the data table on a screen. A form information input section for inputting output form information as information, (d) a form information table for storing output form information input from the form information input section, and (e) data stored in the data table and A related information input unit for inputting related information for associating with the output format information stored in the form information table; (f) a related information table for storing the related information input from the related information input unit; The screen is composed of a data display unit for displaying data and an operation instruction unit for instructing the next operation. Information and operation instruction information storage unit that stores information for performing the following operations that support on the operation instruction section as the operation instruction information for displaying,
(H) extracting the related information stored in the related information table, extracting the operation instruction information from the operation instruction information storage unit that stores the operation instruction information, incorporating the relevant information into the operation instruction information, and executing the execution procedure. An execution procedure generation unit to be generated; and (i) an execution control unit that controls execution of processing based on the execution procedure generated by the execution procedure generation unit.

Further, the data table stores a data table name for identifying data to be stored, the form information table stores a form table name for identifying output format information to be stored, and the related information includes It is characterized by comprising a data table name and the form table name.

The system construction support apparatus further includes a basic menu information storage unit for storing basic menu information for generating a basic menu, and the execution procedure generating unit stores the basic menu information in the basic menu information storage unit. A basic menu generating unit that automatically generates a basic menu using the basic menu information stored in the storage unit and the related information stored in the related information table.

The system construction support apparatus further includes a query input unit for inputting operation information for inquiring data stored in the data table, and an operation information input from the query input unit. A query table to be stored, wherein the form information input unit inputs output format information of data obtained by querying the data table based on the operation information, and the related information input unit stores the data in the data table. And inputting related information for associating the input data with the operation information stored in the query table and the output format information stored in the form information table.

[0012] The query table stores a query table name for identifying operation information to be stored, and the related information includes at least the data table name, the query table name, and the form table name. It is characterized by.

Further, the system construction support apparatus further includes a communication manager for controlling the operation of the application program, and the related information table includes data created in the application program as the related information and input from the data input unit. External data related information for associating the data with the input data, and the operation instruction information storage unit stores the operation instruction information for associating the data created in the application program with the data input from the data input unit and operating the data. The execution procedure generation unit generates an execution procedure of a process based on the operation instruction information and the related information including the external data related information, and the execution control unit generates the execution procedure based on the execution procedure. The above application program for the communication manager Outputs instruction information for controlling the operation, the communication manager, and controls the operation of the application program based on the instruction information.

Further, the form information input unit extracts a part of the operation instruction information from the operation instruction information storage unit and stores the extracted operation instruction information in the form information table together with the output format information.

Further, the system construction support apparatus further includes a report information input section for inputting print style information for printing data, and a report information table for storing the print style information input from the report information input section. The report information table stores a report information table name for identifying print style information to be stored; and the related information input unit stores data stored in the data table and an operation stored in the query table. The present invention is characterized by inputting related information for associating the information with the output format information stored in the form information table and the print format information stored in the report information table.

The data table, the query table, the form information table, the related information table, and the report information table are databases, and can be updated by an application program that accesses the database. The operation of the application program is controlled.

Further, the system construction supporting apparatus further comprises a sort table for storing sort information for specifying an arrangement order when displaying data, and the data input section inputs the sort information into the sort table. It is characterized by the following.

[0018]

BEST MODE FOR CARRYING OUT THE INVENTION

Embodiment 1 FIG. Hereinafter, a system construction support apparatus according to the present invention will be described with reference to the drawings. As an example, in the first embodiment, it is assumed that a facility management system is constructed using the system construction support apparatus of the present invention. FIG. 1 is a configuration diagram showing a system construction support device according to the first embodiment. In FIG. 1, a system construction support device 1 includes a basic unit 2, a database unit 3, a communication manager 4, and an application group 5. The basic unit 2 includes a data input unit 6 for inputting data, a form information input unit 7 for inputting output format information for displaying data on a screen,
The related information input unit 8 for inputting related information for associating the data input from the data input unit 6 with the output format information input from the form information input unit 7 and the related information input from the related information input unit 8 will be described below. An execution procedure generation unit 9 for generating an execution procedure of a process based on operation instruction information stored in an operation instruction information storage unit to be executed, and executing the process based on the execution procedure generated by the execution procedure generation unit 9 It comprises an execution control unit 10 for controlling. Execution control unit 10
If the execution procedure generated by the execution procedure generation unit 9 includes an instruction to activate and operate another application program as shown in the application group 5, the activation or operation is performed. The instruction information 12 to be transmitted is output to the communication manager 4. Communication Manager 4
Starts an application registered in the application group 5 based on the instruction information 12 and controls its operation. Furthermore, the basic unit 2 includes a query input unit 11 for inputting operation information for inquiring data input from the data input unit 6. The database unit 3 includes a data table 20, a query table 21, a form information table 22, a related information table 23, a basic menu information storage unit, and an operation instruction information storage unit 24. The data table 20 is a table that stores data input from the data input unit 6. The query table 21 is a table that stores operation information input from the query input unit 11. The form information table 22 is a table for storing output form information input from the form information input unit 7. The related information table 23 is a table that stores the related information input from the related information input unit 8. The operation instruction information storage unit 24 and the basic menu information storage unit 25 store operation information on the screen, arrangement information of operation buttons, and the like. Details of the operation instruction information storage unit 24 and the basic menu information storage unit 25 will be described later. Application group 5
As an example, Access5a and AutoCAD
(Auto CAD is a registered trademark of Autodesk Corporation) 5b and paint brush (paint brush is
For example, an application program such as Microsoft® registered trademark 5d or a media player (media player is a registered trademark of Microsoft Corporation) 5c is provided. The application programs included in the application group 5 are not limited to those shown in FIG. 1. For example, Ichitaro and Hanako of JUSTSYSTEM (Ichitaro and Hanako are JUSTSYSTE
(Registered trademark of Company M). Reference numerals 16 and 17 denote storage units that store information (also referred to as objects) created by application programs as illustrated in the application group 5.

FIG. 2 is a flowchart showing a procedure for constructing a system using the system construction support apparatus according to the first embodiment. FIG. 3 is a flowchart showing a procedure for executing the system created according to the procedure shown in FIG. 2 in the first embodiment. In FIG. 2, the user first creates a data table 20 using the data input unit 6 (S1). Next, a query table 21 is created by the query input unit 11 (S2). Then, the form information table 22 is created by the form information input unit 7 (S3). Next, the related information table 23 is created by the related information input unit 8 (S4). Finally, the system environment is set (S5). According to the above procedure, the user builds the system. Further, in the system constructed according to the procedure shown in FIG. 2, as shown in FIG. 3, the execution procedure generation unit 9 generates the execution procedure by referring to the related information table 23 and the operation instruction information storage unit 24 (S10). ). Then, the execution control unit 10 executes the system based on the generated execution procedure (S11).

The steps S1 to S5 in FIG. 2 will be described in detail below. Note that the basic unit 2 of the system construction support device of the present invention is designed to include a table creation function of the Access 5a. And, for the user who builds the system, it is as if Acces
It seems that the system construction support apparatus operates by activating s5a. When the user starts Access5a, a table creation menu 40 shown in FIG. 4 is displayed. From the table creation menu 40, new creation and design editing of tables, queries, forms, and reports, and data registration / change can be performed. When the new creation button 47 of the table creation menu 40 is clicked, the system construction support device is activated. Table creation menu 40
The operations for the other buttons displayed in
Since the operation is the same as the table creation in esss, the description is omitted.

Next, the table creation in S1 will be described by taking as an example a procedure for creating an equipment table from the table creation menu 40. When the table button 41 in FIG. 4 is clicked and the new creation button 47 is clicked, the data input section 6 is activated, and the table wizard menu 50 shown in FIG. 5 is displayed. Table Wizard Menu 5
0 has a comment display area 51 in which the operation procedure of the table wizard is displayed. The table list 52 displays the names of the tables for which the system construction support device has prepared sample data in advance. For example, a sample table “T_equipment data” for managing the equipment data in the equipment management system is prepared in advance and is displayed in the table list 52. When the user selects a predetermined table from the table list 52, the field names of the selected table are displayed in the field list 53. The user selects an arbitrary field name from the field names displayed in the field list 53 and clicks the operation button 54. When the operation button 54 is clicked, the selected field name is copied to the field list 55 of the new table. To change the field name, select the field name to be changed from the field list 55 of the new table, and click the field name change button 56,
Register a new field name. When the field definition of the new table is completed, the next button 57 is clicked. When the next button 57 is clicked, a screen is displayed in which the user can register an arbitrary table name for the table having the configuration created in FIG. Embodiment 1
Here, the name of the created table is referred to as “equipment data table”. Clicking on the complete button 58 in FIG.
The table for which the field has been newly defined is stored under the table name selected from the table list 52.
Note that the operation of each of the operation buttons 54 is performed in Acces
The same operation as s is performed.

As described above, in the system construction support apparatus of the present invention, sample data in several types of systems are prepared in advance, and the sample data is prepared based on the sample data, similarly to the Access table wizard function.
You can define table field names. Since the table creation function is similar to the Access table wizard, a user who has learned the Access operation can easily create a table. In addition, the data input unit 6 automatically adds a selection flag and a field for storing primary key information to the created data table. However, it is not displayed in the field list 55 of the new table. Primary key information is Ac
This is the same as the definition of the primary key information in the ESS, and is information having a unique value for identifying a record stored in the table. Here, the values stored in the primary key information field have the order in which the records were registered as the values of the primary key information. The selection flag is a flag indicating that the field is selected by the user among the field names of the sample table prepared in advance in the system.

Next, the creation of the query table in S2 will be described. The query here is operation information, which is not essential for the system. However, when a plurality of data tables are created in S1, they are used to define the relationship between the tables. For example, in S1, the equipment data table and the equipment user table (the equipment user table has the field configuration shown in FIG. 6A)
Is set, and queries are set for these two tables. The query is operation information for inquiring data stored in the data table. The operation information is input by activating the query input unit 11. The input operation information is registered in the query table 21. The query input unit 11 is activated from the table creation menu 40 in FIG. When the query button 42 of the table creation menu 40 is clicked, the query input unit 11 is activated. When the query input unit 11 is activated, an Access query creation screen is displayed. Then, a selection query is created according to the Access query creation procedure. For example, the equipment data table 60 composed of fields as shown in FIG.
And a selection query for the facility user table 61 is created.
When the two tables are selected, a connection line is automatically drawn between the equipment data table 60 and the equipment user table 61 by the Access function. The connection line indicates how the equipment data table 60 and the equipment user table 61 are related to each other.
It has a user ID field in common. The connection lines 1 and ∞ indicate that one record in the facility user table 61 has a 1: many relationship with a plurality of records in the facility data table 60. Therefore, the two tables are joined by the user ID field. After selecting the table for which the query is to be created, the next step is to select the fields storing the data to be obtained from the two tables. The method of selection follows the function of Access, and the description is omitted here. In the first embodiment, the main key information, the selection flag, the equipment management number, the product code, the user's name, and the section name shown in FIG.
Select fields. Then, the name of the created query table is referred to as “equipment query”.

Next, the creation of the form information table in S3 will be described below. Form information table 22
Is a table for storing output format information for outputting the data stored in the data table 20 on the screen,
The output format information is input from the form information input unit 7.
The activation of the form information input unit 7 is performed from the table creation menu 40 in FIG. When the form button 43 of the table creation menu 40 is clicked and the new creation button 47 is clicked, the system construction support device is activated, and the form information input unit 7 is activated. Form information input section 7
When you start, the form wizard is started, and a screen for selecting the type of form to be created is displayed. In the system construction support device of the present invention, three types of forms can be designed. The three types of forms are a list subform, an edit form, and a detail form. The list subform is a definition of an output format for displaying a list of data acquired from the data table 20 specified in the query based on the query created in S2 on the screen.
The editing form is a definition of an output format for an additional editing screen used to add a new record to the data table. It is also a definition of an output format for a change edit screen for changing the contents of a predetermined record in the data table. The detail form defines an output format for editing and displaying a predetermined record of the data table on one screen. The list subform is a query table as a source, the edit form is a data table as a source, and the detail form is a query table as a source. When you select a form type,
A list of table names or query names that have already been created is displayed according to the type of the selected form, and a table name or query name to be a source is selected. Upon selection of the source, a wizard for defining the fields of the form shown in FIG. 7 is displayed. In the form format wizard menu 70 shown in FIG. 7, a list of fields constituting the table selected as the source is displayed in the field list list 71. 72 is defined in a field list 73 to be displayed. After the field definition is completed, the next button 74 is clicked. When you click the Next button 74, a screen for defining the title of the form is displayed.
Specify the title you want to display. The screen for designating the title is similar to Access, and a description thereof will be omitted. For example, here, the title is a facility data list. After specifying the title, click the Finish button to save the form with a file name and save. The output format information is stored in the form information table 22 with the specified file name. Note that the edit form and the detail form are fixedly displayed in a single form, and the list subform is fixedly displayed in a list form. What is displayed based on the set output format information is the data stored in the data table 20, and from the screen displaying the data,
For example, display of a button for transition to another process is not performed. For this reason, the system construction support apparatus displays data on the screen based on the output format information, and simultaneously prepares operation instruction information for displaying buttons and the like in the operation instruction information storage unit 24 of the database unit 3 in advance. deep. It is assumed that the operation instruction information is prepared for each type of form. Form information input section 7
Saves the output form information in the form information table 22 and at the same time retrieves operation instruction information for displaying buttons and the like corresponding to the type of form from the operation instruction information storage unit 24, and outputs the form information table together with the output form information. 22.

Next, the creation of the related information table in S4 will be described below. In the first embodiment, a related information table including the fields shown in FIG. 8 is created. The related information table includes a list form name 80, an edit form name 81, a detailed form name 82, a data table name 83, a query table name 84, and a type 85. Create related information table, Acces
This is performed using the table creation function of s. When the table button 41 of the table creation menu 40 in FIG. 4 is clicked, a table wizard menu 50 in FIG. 5 is displayed. Then, when "T_related information" is selected from the table list 52, the related information input unit 8 is activated. In the system construction support device of the present invention, six field names shown in FIG. 8 are registered in advance in "T_related information". For this reason, the user can select “T_related information” from the table list 52 and easily define the fields of the related information table. After defining the fields, enter the actual related information and create the related information table. The created related information table is stored in the related information table 23 with an arbitrary table name designated by the user.

For example, if the table name of the data table created in S1 to S3 is "Equipment data TBL", the query table name is "Equipment query", and the list form name is "Equipment data list F", The related information table is as shown in FIG. Further, it is assumed that the detailed form name is "Facility Details F" and the edit form name is "Facility Edit F", and the form name is input as shown in FIG. A related information table is created as described above, and a setting is made so that a query and a form relating to a predetermined data table can be combined.

Next, the setting of the system environment in S5 will be described. In the setting of the system environment, registration of users who can use the system constructed by the user, registration of a password for each user, setting of access rights for each user with respect to the created table, and the like are performed. In this way, the system created using the system construction support device of the present invention supports security management.

Next, the execution procedure of the system shown in FIG. 3 will be described in detail. For example, according to the procedure of FIG.
Assuming that an equipment management system has been constructed, a procedure for executing this system will be described. When the execution procedure generation unit 9 is activated, the execution procedure generation unit 9 stores the operation instruction information storage unit 24,
A procedure for displaying a menu is created with reference to the related information table 23, and the execution control unit 10 displays a main menu 90 shown in FIG. The screen form of the main menu 90 is created based on basic menu information prepared in advance by the system construction support apparatus. The system construction support device includes a basic menu information storage unit 25 of the database unit 3.
Next, information for displaying the menu screen shown in FIG. 9 is stored. When the execution procedure generation unit 9 is executed, the execution procedure generation unit 9 refers to the related information table 23, refers to the form information table 22 based on the form name registered in the list form name 80, and To get. The acquired title is stored in the basic menu information storage unit 25 so that it can be displayed in the main table list list 91 and the sub table list list 93 of the main menu 90. If there is no change in the related information table, the main menu 90 can be created from the information in the basic menu information storage unit 25. As shown in FIG. 9, the main menu 90 includes a drawing attribute button 95, a main table list list 91, a main table button 92, a sub table list list 93, a sub table button 94, a new CAD drawing registration button 96, and an end button 97. It is composed of The contents that operate after clicking the drawing attribute button 95 will be described in another embodiment, and the description is omitted in the first embodiment. In the main table list list 91, the titles of the list form names 80 in which the type 85 of the related information table is "1" are displayed in a list. In the sub-table list 93, the titles of the list form names 80 whose related information table type 85 is "2" are displayed in a list. The user can select the main table list 9
1 or an arbitrary title is selected from the sub-table list 93, and the main table button 92 or the sub-table button 94 is clicked to display the selected list. When the main table button 92 or the sub-table button 94 is clicked, the procedure for the execution procedure generation unit 9 to display the list is executed by the operation instruction information storage unit 24,
It is generated with reference to the related information table 23, and the execution control unit 1
Execute the procedure generated by 0.

FIG. 10 shows an example in which the equipment list is selected from the main table list list 91 and the main table button 92 is clicked to be displayed. The equipment list window 100 shown in FIG. 10 includes a user setting unit and a system fixing unit. A user setting unit 101 surrounded by a dotted line is displayed based on output format information registered in the form information table 22. The other part is the system fixing part. In order to display the system fixed unit as shown in FIG. 10, the form information input unit 7 determines in S3 of FIG.
When the form information table is created, the output form information of the fixed part is added to the created form information table 22. The output format information of the fixed portion is information stored in the operation instruction information storage unit 24. Since the equipment list window 100 is a list subform, the system fixed unit in FIG. 10 is a system fixed unit for the list subform. As described above, by adding information for the system fixing unit to the form information table 22, the information shown in FIG.
A list screen as shown in FIG. The user setting unit 101 is a list display unit 104. The search condition input unit 103 is generated based on information added to the form information table 22 from the operation instruction information storage unit 24,
The search condition input field provided in the search condition input unit 103 conforms to the field displayed in the list. The search condition input unit 103 is capable of inputting conditions for three records, and the conditions specified in the same field of each record are in an OR relationship, and the conditions specified in any field of one record are AND relationship. The record number display section 105 displays the first record number of the currently displayed record. List display section 104
Is displayed in the form information table 2.
The field to be displayed is determined based on the output format information stored in No. 2.

The execution procedure generation unit 9 generates the related information table 2
3, the related information table is searched based on the list subform name selected from the main table list list 91 or the sub table list list 93 in FIG. At this time, if the list name selected from FIG. 9 is selected from the main table list list 91, the related information in which the type 85 of the related information table is “1” is searched. If the list name is selected from the sub-table list list 93, the related information whose type 85 is "2" is searched. Referring to the related information table 23, a query table name and a data table name corresponding to the list subform name can be obtained. For this reason, the execution procedure generation unit 9 acquires data from the corresponding data table based on the operation information of the query table registered in the query table name, and outputs the data to the output form information registered in the list form name 80. A procedure for displaying the acquired data based on the operation instruction information corresponding to the button in FIG. 10 stored in the operation instruction information storage unit 24 is acquired, and the execution control unit 10 executes the procedure. When the add button 106, the change button 107, and the copy button 108 are clicked, the execution procedure generation unit 9 executes the above-described operations 106, 107, and 10 stored in the operation instruction information storage unit 24.
8 is obtained, and based on the operation instruction information, the edit form name 81 of the related information table is obtained.
In accordance with the output format information registered with the form name set in (1), a procedure for displaying the data acquired from the data table is generated, and the execution control unit 10 executes the procedure.

For example, at the same time as displaying the information of the main table in a list using Access, operation buttons such as a change button and an addition button are also displayed, and by clicking the operation button, another processing corresponding to the operation button is performed. (For example, to display another form). In this case, the user
First, you must place a button on the form, give the button a title, create an event procedure, and set the action to be performed with that button. For this reason, in order to perform the above setting using Access, sufficient knowledge about Access was required, and it was not easy to set. However, in the present invention, the type, arrangement position, and operation when the operation button is clicked on each form are determined in advance, and these settings are used as operation instruction information in the operation instruction information storage unit. 24. Therefore, the execution procedure generation unit 9 obtains necessary operation instruction information from the operation instruction information storage unit 24 to execute the next process that occurs when the operation button is clicked. Then, a form name and a data table name necessary for the acquired operation instruction information are acquired from the related information table 23. Then, the acquired form name and data table name are incorporated into the operation instruction information to generate an execution procedure. The system construction support apparatus of the present invention eliminates the need for arranging operation buttons on a form and setting an operation corresponding to an operation button as in the conventional Access. If necessary information is registered, the operation buttons are automatically displayed on the form, and the processing that occurs when the operation button is clicked can be realized. Thus, the system can be easily constructed.

FIG. 11 shows an example of a screen for editing. FIG.
The execution button 122 and the close button 123 are displayed in the edit window 120 of the above. This is because the operation instruction information for the edit form registered in the operation instruction information storage unit 24 is added to the output format information. Is displayed.
When the detail button 110 is clicked, the execution procedure generation unit 9 acquires the operation instruction information corresponding to the detail button 110 stored in the operation instruction information storage unit 24, and acquires the detailed form name of the related information table. Is generated in the operation instruction information, and a procedure for displaying the data acquired from the data table is generated according to the output form information registered in the detailed form name, and the execution control unit 10 executes the procedure.

FIG. 12 shows an example of a screen for details. FIG.
A close button 124 is displayed in the detail window 121 of the above, but this is displayed because the operation instruction information for the detailed form registered in the operation instruction information storage unit 24 is added to the output format information. . Delete button 109
Is clicked, the operation instruction information corresponding to the delete button 109 stored in the operation instruction information storage unit 24 is acquired, and the acquired operation instruction information is added to the selection box 11.
7. Incorporating information necessary for generating a procedure for deleting the record to be deleted from the corresponding data table with the record selected by step 7 as a deletion target,
The execution control unit 10 executes the procedure.

The CAD drawing display button 111, the list print button 112, and the detail print button 113 will be described in detail in another embodiment, and a description thereof will be omitted. When the condition clear button 114 is clicked, operation instruction information corresponding to the condition clear button 114 stored in the operation instruction information storage unit 24 is acquired, and the acquired operation instruction information is set in the search condition input unit 103. Include information that will generate a procedure to clear the value. When the search button 115 is clicked, the execution procedure generation unit 9
Acquires the operation instruction information corresponding to the search button 115 stored in the operation instruction information storage unit 24, and acquires the acquired operation instruction information from a data table corresponding to the condition specified in the search condition input unit 103. The execution control unit 10 executes the procedure by incorporating necessary information so as to generate a procedure for searching for and displaying data that matches the search condition. When the close button 116 is clicked, the execution procedure generation unit 9 acquires the operation instruction information corresponding to the close button 116 stored in the operation information storage unit 24, and displays the displayed list on the acquired operation instruction information. The screen is closed, and information necessary for generating a procedure for displaying the main menu screen of FIG.
0 performs the procedure.

As described above, the execution procedure generation unit 9 extracts the operation instruction information corresponding to each button from the operation instruction information storage unit 24, and refers to the relevant information table to the extracted operation instruction information and associates the relevant information with the extracted operation instruction information. Then, based on the related information, an execution procedure is generated by incorporating necessary information so as to generate a procedure for executing a process for the clicked button.

The execution control unit 10 executes the procedure generated by the execution procedure generation unit 9. When the application program as shown in the application group 5 is started, the execution control unit 10 generates the instruction information 12, and Transfer to communication manager 4. The communication manager 4 controls the application program based on the instruction information 12. Data received from the application program is returned to the basic unit 2 via the communication manager 4. In the basic unit 2, the execution procedure generation unit 9 acquires necessary operation instruction information from the operation instruction information storage unit 24 based on the data received from the application program, generates an execution procedure, and executes the procedure executed by the execution control unit 10. And follow the steps.

Embodiment 2 In the second embodiment, an example in which a CAD drawing created by AutoCAD and data stored in a data table are combined as an application program representing a group of applications will be described below. The following table is created to connect the CAD drawing and the data. [・ Drawing attribute table]: The table on the left is a predetermined C
This is a table for managing AD drawings, and is composed of fields shown in FIG. As shown in FIG. 13, the drawing attribute table has drawing numbers, drawing names, file names, creators, creation dates, and revision dates as fields. The drawing number is a number for identifying a CAD drawing, and the drawing name is a drawing name for a user to identify a predetermined CAD drawing. The file name is the actual file name of the CAD drawing. The creator, creation date, and revision date can be automatically set by the system. [・ Drawing information query table]: The table on the left is
This is a table for combining predetermined data registered in the data table created in the first embodiment with predetermined graphics on a CAD drawing. [Drawing information list table]: The table on the left is a table for storing output format information for displaying data stored in the data table on the screen based on the operation information registered in the drawing information query table. . [Layer correspondence table]: The CAD drawing represents one drawing with several layers. For example, in the case of a floor plan, the floor plan is represented by Layer 1, the arrangement of desks on the floor is represented by Layer 2, the arrangement of telephones on the desk is represented by Layer 3, and the arrangement of personal computers is represented by Layer 4. The layer correspondence table is a table for combining data of a layer and a figure represented in the layer. Since the data is registered in the data table, a list form name created from the data table is associated with a layer name. [・ Attribute display table on drawing]: The table on the left is C
By combining data stored in a predetermined field in the data table with a predetermined figure on the AD drawing,
It is a table created for pasting data to a figure on an AD drawing. [. Related information table]: The table on the left is the table described in the first embodiment, but in the second embodiment, the table shown in FIG.
Further, information about the drawing is added. [• Graphic information table]: The table on the left is a table for managing graphic IDs on CAD drawings.

FIG. 14 shows a format of the related information table. As shown in FIG. 14, a field of the external data identification name 86 is newly added to the related information table. In the field of the external data identification name 86, the table name of the drawing information list table is specified. For example,
Register as computer list F. Also, the type 85 is set to “2” and a new record is added. The list form name 80 of the record to be added specifies the table name of the drawing information list table. Here, the external data identifier 86
Is registered as the computer list F in the same manner as the name specified in the field of (1). For the field of the edit form name 81, the field of the detailed display name 82, and the field of the data table name 83, the same table name as the record whose type 85 is "1" is specified. Here, the first embodiment
Specify the same table name as the table name registered in. In the query table name 84, the table name of the drawing information query table is registered. Here, it is registered as a computer query. Thus, the data table and C
The drawing information of the AD drawing is combined with the external data identification name registered.

In the second embodiment, as an example, FIG.
As shown in FIG. 5, the computer list is combined with the equipment figure of the CAD drawing. FIG. 16 shows the procedure of the connection. In FIG. 16, first, a drawing attribute table composed of the fields shown in FIG. 13 is created (S20). At this time, FIG.
As shown in FIG. 5, the CAD drawing in FIG.
−001 ”and the file name is“ SEISAN2F.D ”.
OC ". The drawing attribute table is obtained by activating the data input unit 6. Since the system construction support apparatus has the table definition information of the drawing attribute table in advance, the table list 5 of the table wizard menu 50 of FIG.
Select a drawing attribute table from 2 and create a new table using the set fields. Then, data is input to the created table. The created drawing attribute table is stored in the data table 20.

Next, a layer correspondence table is created (S21). FIG. 17 shows the configuration of the layer correspondence table. As shown in FIG. 17, the layer correspondence table 140
Consists of fields for layer name and form name. Layer 13 of CAD drawing 133 shown in FIG.
4 and the computer list 130, the layer name of the layer 134 and the form name of the computer list 130 are set in the layer correspondence table 140. For example, the layer name of the layer 134 is “KEISANKI.DO
C ", and the form name is" computer list F ". The layer correspondence table is created by activating the related information input unit 8. Since the system construction support device has the table definition information of the layer correspondence table in advance, FIG.
The table corresponding to the layer is selected from the table list 52 of the table wizard menu 50, and a new table is created using the set fields. Then, data is input to the created table. The created layer correspondence table is stored in the related information table 23.

Next, a drawing information query table is created (S22). The drawing information query table is created based on a main data table, here, a query table created for the equipment data table (the equipment query of the first embodiment) and a graphic information table. First, a graphic information table is created (S23).

FIG. 18 shows the configuration of the graphic information table. The graphic information table 150 includes primary key information, a file name, a graphic ID, a selection flag, and a form name.
The graphic information table starts Auto CAD and starts CA
This table is automatically created by displaying a data list from the screen displaying the D drawing and selecting one predetermined record from the data list. Here, the data list to be displayed is a data list created from the main table. In the example of the related information table shown in FIG. 14, the main data table is the equipment data TBL. The list form name of the data list to be created is the equipment data list F.

As will be described below, the list form name is determined by referring to the layer correspondence table. For example, when the layer 134 shown in FIG. 15 is displayed, one figure is selected, and “link” is selected from the menu bar and clicked. The link function of the menu bar is provided when the system construction supporting apparatus of the present invention uses the Auto C
This is a function added to the function of AD. When the "link" is clicked, the execution procedure generation unit 9 is transmitted via the communication manager 4.
Is started. The execution procedure generation unit 9 acquires operation instruction information corresponding to “link” from the operation instruction information storage unit 24, and refers to the layer correspondence table 140,
The form name corresponding to the layer 134 is obtained. Further, the related information table is referred to based on the form name, and a query table name corresponding to the form name is obtained. A procedure is generated that incorporates the acquired information into the operation instruction information and displays the data in the specified output format information based on the operation information registered in the query table. When the execution control unit 10 executes the above procedure, an equipment list window 100 of FIG. 10 is displayed. Then, one arbitrary record is selected from the displayed equipment list window 100. For example, when a record whose equipment management number is “AKKQ2” (primary key information is not displayed in the equipment list window 100 but primary key information is “100100”) is selected, graphic information shown in FIG. A table is created. The configuration of the graphic information table is fixed, and includes fields of primary key information, a file name, a graphic ID, a selection flag, and a form name. The primary key information of the created graphic information table 150 is “10010
0 ”, and the file name is the drawing file“ SEISAN2F.DOC ”containing the figure selected by AutoCAD.
Becomes The figure ID is the figure ID of the selected figure, and A
The information is acquired from the auto CAD and becomes “001”. The graphic ID is not displayed on the CAD drawing. The selection flag sets an initial value. The selection flag is a field used when an arbitrary record is selected from the displayed records when the graphic information table 150 is displayed on the screen. The form name is the form name “facility data list F” of the form that displays the facility list window 100. In this way, by designating the main table data for the CAD figure,
Data can be automatically input to the graphic information table.

Next, a drawing information query is created (S2).
4). The drawing information query is performed by activating the query input unit 11. The query input unit 11 is activated to display a query table corresponding to the main data table on the query creation screen and the graphic information table created in S23. Here, the main data table is an equipment data table, and the query table corresponding to the equipment data table is an equipment query. The equipment query is shown in FIG. The query table and the graphic information table can be linked by the primary key information. In the field of the drawing information query table, a file name, a figure ID, a selection flag, and a form name are selected from the figure information table. Also, the main key information is selected from the equipment query. The fields selected here are required fields. Further, in order to paste the user name on the CAD drawing for the equipment figure and display it, the user name field is selected from the equipment query. The user name is an arbitrary field, and other models may be selected (the equipment query in FIG. 6B does not have a model field, but it is selected here as it exists). In FIG.
The outline of the drawing information query created as described above is shown.
The drawing information query table name is a computer query.

Next, a drawing information list table for registering output format information for displaying data obtained from the drawing information query created in S24 is created (S2).
5). The drawing information list table is created by activating the form information input unit 7. Activation of form information input 7
This is performed by clicking the form button 43 in FIG. By clicking the form button 43, a drawing information query is designated for the original table. The fields of the designated drawing information query are displayed in the field list 71 of the form format wizard menu 70 in FIG. .
The created drawing information list table is stored in the form information table 22. Here, the form name of the drawing information list table is a computer list F.

Next, an attribute display table is created on the drawing (S26). FIG. 20 shows the configuration of the attribute display table on the drawing. The drawing-based attribute display table 170 includes a form name, an attribute name, a query name, and a field name. The form name specifies the form name of a data list linked and linked to the CAD drawing layer. The attribute name designates an attribute name corresponding to a field name to be displayed for selecting a field to be pasted on a figure on a CAD drawing. The query name specifies a drawing information query table name. The field name specifies the field name on the drawing information query table to be pasted on the figure. For example, the layer 134 shown in FIG.
As shown in FIG. 7, the equipment data list F is linked. For this reason, the form name and the equipment data list F are specified as the form names in the drawing attribute display table 170. The attribute name is a user name. The query name is
Register the drawing information query table name. Here, it is registered as a computer query. For the field name, specify the field name to be attached to the figure on the computer query.
Here, the field name is a user name. Further, a new record is created and the model is registered in the field name so that the model name can be pasted on the figure. In this way, using the registered drawing attribute display table 170,
When a paste attribute change is selected and clicked from the menu bar on the CAD drawing, a paste attribute selection box 180 in FIG. 21 can be displayed. The user selects the attribute list 181
By selecting an arbitrary attribute name from among the attribute names displayed in (1) and clicking the OK button, the data of the field corresponding to the selected attribute name can be displayed on the CAD drawing.

Next, a description will be given of a procedure for displaying a related CAD drawing when a list of data tables is displayed, and an operation of the execution procedure generating unit 9. Note that the execution control unit 10 executes the generated procedure after the execution procedure generation unit 9 generates a procedure for performing a series of operations, and the timing at which the execution control unit 10 operates is not particularly specified. Further, the execution procedure generation unit 9 acquires a basic procedure for performing a series of operations from the operation instruction information storage unit 24 as operation instruction information, incorporates necessary information into the acquired operation instruction information, and executes the execution procedure. Shall be generated.

FIG. 22 shows the C associated with the data list display.
Execution procedure generation unit 9 for generating a procedure for displaying an AD drawing
The operation of FIG. In order to display a CAD drawing, FIG.
The user clicks the CAD drawing display button 111 from the data list display screen as shown in FIG. 0, but displays a list as shown in FIG. There is a method of clicking a CAD drawing display button 111 from a list. However, the two methods use different tables for reference. For this reason, a procedure for displaying a CAD drawing from a screen displaying a drawing information list will be described first. The computer list 130 shown in FIG. 15 is based on the operation information of the drawing information query 160 shown in FIG. This is the list displayed.

FIG. 23 shows a screen displaying the computer list again. One record is selected from the computer list displayed in FIG. For example, if the primary key information is 100
The record displayed on the second line from the top, which is 102, is selected (S30). Next, the CAD drawing display button 11
1 is clicked (S31). When the CAD drawing display button is clicked, the execution procedure generation unit 9 acquires operation instruction information corresponding to the CAD drawing display button from the operation instruction information storage unit 24. The acquired operation instruction information is information indicating a procedure for acquiring information of the CAD drawing linked to the selected record (S32). The procedure in which the execution procedure generation unit 9 acquires information on a CAD drawing will be described from S33 to S35. In S33, the query name is acquired based on the form name of the displayed screen with reference to the related information table. It can be seen from the related information shown in FIG. 14 that the form name of the computer list displayed in FIG. 23 is “computer list F”. The contents of the table of the acquired computer query are as shown in FIG. In S34, referring to the query table, the file name of the CAD drawing including the graphic linked to the record selected in S30 is obtained. Drawing information query 1 of FIG.
Looking at 60, the file name is specified to be obtained from the graphic information table. Therefore, referring to the graphic information table 150 in FIG. 18, the file name “SEISAN2F.DOC” of the CAD drawing can be obtained. In S35, the execution control unit 10 activates the Auto CAD 5b via the communication manager 4. At this time, the execution control unit 10 assigns the file name of the CAD drawing acquired in S34 via the communication manager 4 to the Auto CAD 5b.
Pass to. The Auto CAD 5b displays the corresponding drawing based on the acquired file name of the CAD drawing.

FIG. 24 shows an example of displaying a CAD drawing. As described above, when the information managed in the data table and the graphic on the CAD drawing are linked, by pressing the display button of the CAD drawing from the screen displaying the data list, the graphic of the link destination can be easily displayed. Can be displayed.

Next, the procedure for displaying the CAD drawing of the link destination from the data table list will be described. The procedure is shown in FIG.
Similarly, by selecting one record from the screen displaying the list and clicking the CAD drawing display button 111, a related CAD drawing can be displayed. However, the method of obtaining the file name of the CAD drawing to be passed to Auto CAD is slightly different. In S33, the query name is acquired based on the form name of the screen with reference to the related information table. Since the displayed list is the drawing information list, the query name of the drawing information query table can be obtained from the form name of the drawing information list. However, if the CAD drawing display button 111 is clicked while displaying the data table list,
The execution procedure generation unit 9 acquires operation instruction information corresponding to the CAD drawing display button 111 from the operation instruction information storage unit 24. Further, referring to the related information table, the external data identification name is obtained based on the form name in the data table list. Then, the acquired external data identifier is incorporated into the operation instruction information. The external data identification name is a form name for outputting a drawing information list. If the form name of the drawing information list can be obtained, the table name of the drawing information query can be obtained. For example, when the CAD drawing display button 111 is clicked from the equipment list in FIG.
Based on the equipment data list F which is the form name of the equipment list,
Referring to the related information table of FIG.
Get the external data identifier corresponding to. The external data identification name can be acquired as “computer list F”. By executing S34 and S35 of FIG. 22 described above, CA
D drawing can be displayed.

Next, a process of pasting data linked to a plurality of figures arranged on a CAD drawing while the drawing is displayed on the Auto CAD side will be described. Note that the execution control unit 10 executes the generated procedure after the execution procedure generation unit 9 generates a procedure for performing a series of operations, and the timing at which the execution control unit 10 operates is not particularly specified. Also, the execution procedure generation unit 9
It is assumed that a basic procedure for performing a series of operations is acquired as operation instruction information from the operation instruction information storage unit 24, and necessary information is incorporated into the acquired operation instruction information to generate an execution procedure. FIG. 25 shows a procedure for pasting data to a CAD drawing. According to FIG. 25, as shown in FIG.
When the AD drawing is displayed, a predetermined layer is selected, and “Paste attribute” is selected from the menu bar and clicked (S40). When "Paste attribute" is clicked on the menu bar, the execution procedure generation unit 9 is activated via the communication manager 4 (S41). Execution procedure generator 9
Acquires the layer name of the CAD drawing selected from the Auto CAD 5b via the communication manager 4.
Then, a layer correspondence table is searched based on the acquired layer name to acquire a linked form name. For example, assuming that the layer name passed from the AutoCAD 5b is “KEISANKI.DOC”, the form name of the form linked in FIG. 17 is “equipment data list F” (S42). The execution procedure generation unit 9 acquires a query table name of the drawing information query by referring to the related information table based on the form name acquired in S42 (S43, S44). Looking at the related information table shown in FIG. 14, the equipment data list F is related information of the main table since the type is “1”. Therefore, in order to obtain the query table name of the drawing information query, the external data identification name is obtained.
According to FIG. 14, the external data identifier for the equipment data list F is the computer list F. Subsequently, when a record whose list form name is the computer list F is searched, a record in which the list form name is the computer list F and the type is “2” indicating that it is related information relating to the drawing can be searched. . Then, the query table name is acquired from the record whose list form name is the computer list F. The query table name is a computer query. Based on the acquired query table name, a corresponding query table is searched, and a field name set as an attribute that can be pasted on a figure is acquired (S45). FIG.
According to the drawing information query 160, the field names are the user name and the model. When there are a plurality of fields that can be pasted obtained in S45, a command for changing the paste attribute is selected and clicked from the menu bar displaying the CAD drawing, and a paste attribute selection box 180 shown in FIG. 21 is displayed. Attribute list 18
The attribute to be pasted can be arbitrarily selected from 1. Here, the description proceeds assuming that the user name is selected. According to the drawing information query 160, the user name is obtained from the equipment data table, and the graphic ID is obtained from the graphic information table. For this reason,
For the information to be pasted, the attribute acquires the user name of the equipment data table, and the figure ID of the paste destination is acquired from the figure information table (S46). The graphic information table and the equipment data table are linked based on the primary key information. Therefore, the user name and the graphic I
Find D. For example, referring to FIGS. 18 and 15, the primary key information “100100” has the graphic ID “001”,
The user name is “Yamada”. Therefore, the user name “Yamada” can be pasted on the graphic whose graphic ID is “001” on the CAD drawing.

FIG. 26 shows an example in which attributes are pasted on a CAD drawing. As shown in FIG. 26, a user name “Yamada” is displayed below a graphic (graphic ID “001”) indicating a computer. At the same time, the graphic ID “00”
For the figure “2”, the user name “Arai” is displayed. This is because the attribute acquired by the execution control unit 10 is passed to the Auto CAD 5b via the communication manager 4 (S4
7) This is realized by the Auto CAD 5b pasting the attribute data passed from the communication manager 4 to a predetermined position on the displayed screen (S48).

As shown in FIG. 26, for example, the model can be displayed by changing the pasting attribute in the CAD drawing on which the user name is pasted. The method of changing the pasting attribute of the pasting is as described in S45.

As described above, by using the system construction supporting apparatus of the present invention, OL can be accessed for Access.
A system can be constructed by linking an application program having no E function and a data table.

Embodiment 3 In this embodiment, FIG.
The function of the 0 sort reference box 102 will be described. The user can select any field in the data table and set the sort order. The set sort order is stored in the sort table. The sort table is stored in the related information table 23 as one of the related information tables. FIG. 27 shows a configuration example of the sort table. The sort table includes a form name, a sort name, and a field name. As the form name, a table name for storing the output format information stored in the form information table 22 is specified. For example, if the list form name for displaying the equipment list in FIG. 10 is the equipment data list F, the equipment name is registered as “equipment data list F”. The sort name is the sort reference box 10 in FIG.
2 specifies the name of the sort to be displayed. For example, if the sort key is a facility management number, the sorting is performed in the order of the facility management number. The field name specifies the field name as a sort key. The field specified as the field name is the field name of the field existing in the data table. For example, the “facility management number” is registered. In the sort table, a plurality of records can be designated by using three fields of a form name, a sort name and a field name as one record. For the specified record, the sort name is displayed in the sort criteria box 102.
Any sort order can be selected by the sort reference box 102. When an arbitrary sort name is selected from the sort criterion box 102, the data is edited in ascending order of the fields specified in the field names and displayed again.

Embodiment 4 FIG. The system construction support device of the present invention can edit and print data stored in the data table 20. This is Acces
This is the same as the concept of the report in s. The system construction support device 1 shown in FIG. 28 includes a report information input unit 13 in the basic unit 2. Activation of the report information input unit 13
Report button 44 of table creation menu 40 in FIG.
Click to launch. It is assumed that the operation of the report information input unit 13 after activation conforms to the report table creation function in Access. Report information input unit 13
Input print information designating a print style, and the input print information is stored in a report information table 26 provided in the database unit 3. In the related information table,
The list report table name is registered as shown in FIG. For example, the table name of the created list report is registered as “equipment list R”. In addition to the list report, a print style of the detailed report can be set. For setting, print information is input from the report information input unit 13, and the set data is registered in the report information table 24.
Then, the created detailed report name, for example, “equipment details R” is registered in the detailed report table name of the related information. In this way, by registering the list report table name and the detailed report table name in the related information table, the list report is sent to the printer by clicking the list print button 112 of the equipment list window 100 shown in FIG. Can be output. By clicking the detail print button 113, a detail report can be output to a printer. When the list print button 112 is clicked, the execution procedure generation unit 9
The operation instruction information corresponding to the list print button 112 is obtained from the operation instruction information storage unit 24. Then, a list report name is acquired based on the list form name displaying the equipment list window 100. For example, if the list form name for displaying the equipment list window 100 shown in FIG. 10 is “equipment data list F”, the acquired operation instruction information indicates that the list report name is “equipment list” from the related information table shown in FIG. R ". For this reason, the execution procedure generation unit 9 is operation instruction information that generates a procedure for acquiring print information with the table name “equipment list R” from the report information table 24, and executes the procedure generated by the execution control unit 10. Execute. Then, the equipment list is output to the printer according to the acquired print information. When the detail print button 113 is clicked, the execution procedure generation unit 9 acquires operation instruction information corresponding to the detail print button 113 from the operation instruction information storage unit 24, and based on the list form name, associates the detailed report name with the related information. Generate the procedure to get from the table. For example, if the equipment list in FIG. 10 has a list form name of “equipment data list F”, the execution control unit 10 acquires the detailed report name as “equipment details R” from the related information table shown in FIG. be able to.
Then, based on the operation instruction information, the execution procedure generation unit 9 refers to the report information table 24 on the basis of the acquired “equipment details R” and generates a procedure for acquiring the corresponding print information. The execution control unit 10 acquires the print information and outputs data to the printer according to the acquired print information.

As described above, by registering the table names of the list report information and the detailed report information in the related information table in association with the list display form name, the list print button provided on the list screen or the detailed print By simply clicking a button, a system that can output data to a printer can be easily constructed.

[0059]

As described above, in the system construction supporting apparatus according to the present invention, the execution procedure generation unit performs the operation based on the related information stored in the related information table and the operation instruction information stored in the operation instruction information storage unit. The execution procedure is generated by the execution control unit. For this reason,
If the name of the data table whose data is stored in the related information table and the name of the form information table that stores the output format information when the data is output are stored in association with each other, the user can use the output format information based on the output format information. Without programming to output data
Data can be output. Therefore, there is an effect that the system can be easily constructed without being influenced by the technical level of the user.

The basic menu for activating the constructed system is automatically generated by the basic menu generator provided in the execution procedure generator based on basic menu information and related information prepared in advance. For this reason, the user
When constructing a system, there is no need to generate a menu screen for activating the constructed system, and the number of steps required for constructing the system can be reduced. Further, since basic menu information is prepared, a basic menu for starting a system generated by using the system construction supporting apparatus of the present invention has a similar basic menu screen. Therefore, the user who operates the system
There is no need to learn the operation procedure for each system, which has the effect of making it easier to operate the system.

Further, operation information for inquiring data stored in the data table is stored in the query table. Then, data obtained by querying the data table based on the stored operation information is displayed based on the output format information. For this reason, it is possible to virtually create a data table and to save memory. Further, the data obtained from the data table can be changed only by changing the operation information, and there is an effect that a flexible system can be constructed.

A communication manager controls the operation of the application program. The related information table stores external data related information that associates data created in the application program with data stored in the data table. The operation instruction information storage unit stores operation instruction information that causes data created by the application program to operate in association with data stored in the data table. For this reason, for example, if the drawing information created by AutoCAD and the data on the data table are associated and stored in the related information table, the drawing related to the data can be displayed on the screen while the data is displayed on the screen. Can be displayed above. At this time, the execution procedure generation unit generates an execution procedure of the process based on the operation instruction information and the related information, and the execution control unit sends an application program, for example, an AutoCAD program to the communication manager based on the execution procedure. Since the instruction information for controlling the operation is output, the user can easily acquire the AutoCAD drawing information related to the displayed data without being conscious of the operation of activating AutoCAD. Further, related data can be referred to from Auto CAD, and the user can easily construct a flexible system. Thus, when linking an object created by another application from a given application, the object is linked without user programming, regardless of whether or not the other application supports OLE. There is an effect that makes it possible.

Operation instruction information for displaying an operation instruction section on the screen is provided in advance. Then, the form information input unit stores the operation instruction information in the form information table together with the output format information. For this reason, data can be programmed without programming to display a button that transitions from the screen displaying data to another processing on the screen, or programming the processing to be activated by clicking the button. The operation instructing unit can be automatically displayed on the displayed screen and operated. Therefore, the system can be constructed without being influenced by the technical level of the user who constructs the system. In addition, since the operation instruction unit is generated based on operation instruction information prepared in advance, a system created using the system construction support apparatus of the present invention generates a similar operation instruction unit. . Therefore, the button operation is the same between the systems, which has the effect of increasing the system operation efficiency of the user.

Further, the print information is stored in the report information table, and the information relating the data table, the query table, and the report information table is stored in the related information table. For this reason, the user does not need to program the process of printing the data obtained from the data table based on the print style information based on the operation information stored in the query table, and the operation procedure generating unit generates the operation instruction information. The data can be printed according to the print style information based on the related information table. For this reason, there is an effect that a user's system construction man-hour can be reduced. Also, if you change the data table,
By referring to the related information table, it is possible to easily search for print style information for performing printing using the changed data table, so that it is possible to construct a system that can easily deal with system maintenance.

The data table, the query table, the form information table, the related information table, and the report information table are databases, and the above tables can be updated by any application program that accesses the database. Therefore, if the user can use the application program for accessing the database, the system construction supporting apparatus of the present invention can be easily operated, and accordingly,
There is an effect that the system can be easily constructed.

Further, the sort table stores sort information for designating the order in which data is displayed. Therefore, if sort information that can be assumed in advance is set in the sort table, the sort order can be selected from the sort table when data is displayed, and a flexible system operation can be performed. There is.

[Brief description of the drawings]

FIG. 1 is a diagram showing a configuration diagram of a system construction support device according to a first embodiment of the present invention.

FIG. 2 is a flowchart showing a system construction procedure according to the first embodiment of the present invention.

FIG. 3 is a flowchart showing an execution procedure of the system according to the first embodiment of the present invention.

FIG. 4 is a diagram showing a table creation menu according to the first embodiment of the present invention.

FIG. 5 is a diagram showing a table wizard menu according to the first embodiment of the present invention.

FIG. 6 is a diagram showing an example of creating a query table according to the first embodiment of the present invention.

FIG. 7 is a diagram showing a form table creation wizard menu according to the first embodiment of the present invention.

FIG. 8 is a diagram showing a configuration of a related information table according to the first embodiment of the present invention.

FIG. 9 is a diagram showing a main menu for activating a system created by the system construction support apparatus of the present invention.

FIG. 10 is a diagram showing an equipment list screen according to the first embodiment of the present invention.

FIG. 11 is a diagram showing a screen for adding, changing, or copying in Embodiment 1 of the present invention.

FIG. 12 is a diagram showing a screen displaying details in the first embodiment of the present invention.

FIG. 13 is a diagram showing a configuration of a drawing attribute table according to the second embodiment of the present invention.

FIG. 14 is a diagram showing a configuration of related information according to the second embodiment of the present invention.

FIG. 15 is a diagram for explaining a relationship between a computer list and a CAD drawing according to the second embodiment of the present invention.

FIG. 16 is a flowchart showing a procedure for combining data and drawings according to the second embodiment of the present invention.

FIG. 17 is a diagram showing a configuration of a layer correspondence table according to the second embodiment of the present invention.

FIG. 18 is a diagram showing a configuration of a graphic information table according to the second embodiment of the present invention.

FIG. 19 is a diagram showing a configuration of a drawing information query table according to the second embodiment of the present invention.

FIG. 20 is a diagram showing an attribute table on a drawing according to the second embodiment of the present invention.

FIG. 21 is a diagram showing a paste attribute selection menu according to the second embodiment of the present invention.

FIG. 22 is a flowchart showing a procedure for displaying a CAD drawing from data obtained by linking data and the CAD drawing according to the second embodiment of the present invention.

FIG. 23 is a diagram showing a display example of a drawing information list according to the second embodiment of the present invention.

FIG. 24 is a diagram showing a display example of a CAD drawing according to the second embodiment of the present invention.

FIG. 25 is a flowchart showing an attribute pasting procedure according to the second embodiment of the present invention.

FIG. 26 is a diagram showing an example of performing attribute pasting on a CAD drawing according to the second embodiment of the present invention.

FIG. 27 is a diagram showing a configuration of a sort table according to the third embodiment of the present invention.

FIG. 28 is a diagram showing a configuration diagram of a system construction support device according to a fourth embodiment of the present invention.

FIG. 29 is a diagram showing a configuration of a related information table according to the fourth embodiment of the present invention.

FIG. 30 is a diagram showing an example in which a supplier table and a product table created in conventional Access are displayed.

FIG. 31 is a diagram showing a search result table extracted under predetermined conditions from a supplier table and a product table in conventional Access.

FIG. 32 is a view showing a product category list in the conventional Access.

FIG. 33 is a view showing an example of a form in which a picture in a conventional Access is pasted.

[Explanation of symbols]

1 system construction support device, 2 basic unit, 3 database unit, 4 communication manager, 5 application group, 5a access, 5b auto CAD, 5
c Media player, 5d paint brush, 6
Data input unit, 7 form information input unit, 8 related information input unit, 9 execution procedure generation unit, 10 execution control unit, 11
Query input unit, 12 instruction information, 13 report information input unit, 16, 17 storage unit for storing information created by application programs, 20 data tables, 21 query tables, 22 form information tables, 23 related information tables, 24 operations Instruction information storage unit, 25 basic menu information storage unit, 26 report information table, 30 new database creation menu, 31 database save list box, 32 database list, 33 file name box, 34 file type list box, 35 open button, 36
Cancel button, 40 Table creation menu, 41
Table button, 42 Query button, 43 Form button, 44 Report button, 45 Open button, 46 Design button, 47 New button, 4
8 list window, 50 table wizard menu, 51 comment display area, 52 table list list, 53 field list list, 54 operation buttons,
55 Field list of new table, 56 Change field name button, 57 Next button, 58 Finish button, 60 Equipment data table, 61 Equipment user table, 70 Form wizard menu, 71
Field list list, 72 operation buttons, 73 Field list to display, 74 Next button, 75 Complete button, 80 List form name, 81 Edit form name, 82 Detail form name, 83 Data table name,
84 query table name, 85 type, 86 external data identification name, 90 main menu, 91 main table list list, 92 main table button, 93 sub table list list, 94 sub table button, 95
Drawing attribute button, 96 New CAD drawing registration button, 9
7 End button, 100 Equipment list window, 101
User setting section, 102 sort reference box, 103
Search condition input section, 104 list display section, 105 record count display section, 106 add button, 107 change button, 108 copy button, 109 delete button, 110
Details button, 111 CAD drawing display button, 112
List print button, 113 Detailed print button, 114
Clear condition button, 115 search button, 116 close button, 117 selection box, 120 edit window, 121 detail window, 130 computer list,
131 user field, 132 model field,
133 CAD drawing, 134 layers, 140 layer correspondence table, 150 figure information table, 160
Drawing information query, 170 Attribute display table on drawing, 180 Paste attribute selection box, 181 Attribute list.

 ────────────────────────────────────────────────── ─── Continuation of the front page (72) Inventor Akira Koyanagi 2-3-2 Marunouchi, Chiyoda-ku, Tokyo Mitsubishi Electric Corporation

Claims (10)

[Claims] 1. A system construction support device having the following elements: (a) a data input unit for inputting data, (b) a data table for storing data input from the data input unit, (c) A) a form information input section for inputting output form information which is screen form information for displaying data stored in the data table on a screen; and (d) storing output form information input from the form information input section. (E) a related information input unit for inputting related information for associating data stored in the data table with output format information stored in the form information table; (f) inputting the related information A related information table storing the related information input from the section, and (g) displaying data stored in the data table. The screen includes a data display unit for displaying the data and an operation instruction unit for instructing the next operation, and corresponds to information for displaying the operation instruction unit on the screen and the operation instruction unit. An operation instruction information storage unit that stores information for performing the next operation as operation instruction information, and (h) operation instruction information that retrieves the relevant information stored in the relevant information table and stores the operation instruction information. An execution procedure generation unit that extracts operation instruction information from the storage unit and incorporates the related information into the operation instruction information to generate an execution procedure; and (i) performs processing based on the execution procedure generated by the execution procedure generation unit. An execution control unit that controls execution. 2. The data table stores a data table name for identifying data to be stored; the form information table stores a form table name for identifying output format information to be stored; 2. The system construction support apparatus according to claim 1, wherein the system construction support apparatus comprises a data table name and the form table name. 3. The system construction support device further includes a basic menu information storage unit for storing basic menu information for generating a basic menu, and the execution procedure generating unit stores the basic menu information in the basic menu information storage unit. 2. The system construction support according to claim 1, further comprising: a basic menu generation unit for automatically generating a basic menu using the basic menu information stored and the relevant information stored in the relevant information table. apparatus. 4. The system construction support device further comprises: a query input unit for inputting operation information for inquiring data stored in the data table; and a query input unit for inputting the operation information input from the query input unit. A query table to be stored, wherein the form information input unit inputs output format information of data obtained by inquiring the data table based on the operation information, and the related information input unit stores the data in the data table. 2. The system construction supporting apparatus according to claim 1, wherein related information for associating the input data, the operation information stored in the query table, and the output format information stored in the form information table is input. . 5. The query table stores a query table name for identifying operation information to be stored, and the related information includes at least the data table name, the query table name, and the form table name. The system construction support device according to claim 4, wherein: 6. The system construction support apparatus further comprises a communication manager for controlling operation of an application program, wherein the related information table is input from the data input unit with data created in the application program as the related information. External data related information for associating the data with the input data, and the operation instruction information storage unit stores the operation instruction information for associating the data created in the application program with the data input from the data input unit. The execution procedure generation unit generates a processing execution procedure based on the operation instruction information and the related information including the external data related information, and the execution control unit performs the processing based on the execution procedure. For the communication manager, Outputs instruction information for controlling the work, the communication manager, the system configuration supporting apparatus according to claim 4, wherein the controller controls the operation of the application program based on the instruction information. 7. The form information input unit extracts a part of the operation instruction information from the operation instruction information storage unit and stores it in the form information table together with the output format information. Or the system construction support device according to 4. 8. The system construction support apparatus further includes: a report information input section for inputting print style information for printing data; and a report information table for storing print style information input from the report information input section. The report information table stores a report information table name for identifying print format information to be stored, and the related information input unit stores data stored in the data table and an operation stored in the query table. 7. The system construction support apparatus according to claim 6, wherein related information for associating the information with the output format information stored in the form information table and the print format information stored in the report information table is input. 9. The data table, the query table, the form information table, the related information table, and the report information table are databases, and can be updated by an application program that accesses the database. ,
9. The system construction support device according to claim 8, wherein the operation of the application program is controlled. 10. The system construction support device further comprises:
2. The system construction support apparatus according to claim 1, further comprising a sort table for storing sort information for specifying an arrangement order when displaying data, wherein the data input unit inputs the sort information into the sort table. .