JP2000003401A - Form preparation processing system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To retrieve data from an existing database table and to easily output it by inputting or outputting variable data to the data input/output field of an optional form. SOLUTION: A data item desired to be generated as the data input/output field is selected. Then, data input/output field information is generated by a program 205. Then, a retrieval condition for executing a retrieval to a selected table is set by an operator by permitting data outputted from the table by data input/output field, which is previously generated on a display 201, or inputted by the operator to be a key. A data reference inquiry name is given in order to discriminate the contents of the set retrieval condition. Then, the data input/output field is generated on the display 201 from input/output field information which is generated by the program 205 and set in the attribute of the form by the data reference inquiry name to which data input/output field information is given.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a method of creating a form definition, a method of processing a database search and update according to the form definition, and a form creation system.

[0002]

2. Description of the Related Art Conventionally, a system relating to a form creation system is disclosed in Japanese Patent Application Laid-Open No. Hei 6-110910. This is a form creation system in which a table of a database storing form data at the time of form processing is obtained from an input form format. Also, based on the contents of the form processing defined for each form, etc., it is possible to obtain correspondence between forms representing the overall processing relationship and execution order, and to execute a plurality of related form processes in conjunction with each other It is a creation system. Further, there is provided a form creation system which can be automatically started by data input to an arbitrary form as a trigger.

[0003]

In this form creation system, it is required to eliminate the complexity of manual processing and to create a form in a short period of time. The present invention incorporates a data input / output field into a search condition in assembling a search expression, and eliminates the complexity of manual processing by automatically creating a search expression, as well as search definition information and data of an arbitrary form. An object of the present invention is to provide a form creation system that can create a form in a short time by taking in attribute information of input / output fields.

[0004]

According to the present invention, there is provided a database table selecting means, a data item selecting means for arbitrarily selecting data items constituting a database table, and a data input / output field. Search condition setting means for searching data in a database table, using data output or input as a key,
Data input / output field information creating means, data input / output field creating means for creating arbitrarily selected data items as data input / output fields on a form format creation screen, and storing data input / output field information as form attributes Data input / output field information storage means, search definition information creating means, search formula assembling means,
It is provided with a search expression executing means and a data display means.

[0005]

DESCRIPTION OF THE PREFERRED EMBODIMENTS Embodiments of the present invention will be described below with reference to FIGS.

(Embodiment 1) FIG. 1 is a flowchart showing an embodiment of the processing procedure of the present invention. FIG. 2 shows a hardware configuration of a computer device for implementing the present invention. In FIG. 2, a display 201 is an output device that displays a form created by the present device and displays various input screens. A keyboard 202 is an input device for inputting data expressed by characters and numerical values to the system. A mouse 203 is a pointing-type input device for creating and selecting input / output fields on the display 201 and calling various input screens. The processing device 204 is a storage device 2 for storing definition information necessary for various processes.
06, which controls the storage device 206 and the various input / output devices described above, receives input data from each device, searches for data, and outputs the data to the display 201. The operation of each of these devices is controlled by a program 205 stored therein.

Next, referring to the flowchart of FIG.
Processing for creating a form in the apparatus shown in FIG. 2 will be described. First, the program 205 reads the table management information from the table management information table and the field management information from the field management information table into the storage device 206 (step 101). Then, a table name is acquired from the table management information and displayed as a list (step 102). When the operator selects a table (step 103), the program 205 displays the data item names in the selected table (step 104).
Further, the operator selects a data item to be created as a data input / output field (step 105).
Then, the program 205 creates data input / output field information (step 106). Next, a search condition for performing a search on the selected table using data output from another table or input by an operator as a key in a data input / output field created in advance on the display 201 is defined as an operation condition. Is set by the user (step 107). When the setting of the search condition is continued, the process returns to step 107. When the setting of the search condition is completed, the operator gives a data reference query name to determine the content of the set search condition (step 108). Then, the program 205 creates a data input / output field on the display 201 from the data input / output field information created in step 106 (step 109),
The data input / output field information is attributed to the form (100 in FIG. 10) by the data reference query name given in step 108.
4) is set (step 1010). According to the above procedure, one form is defined and created.

FIG. 3 shows table management information 301 and field management information 302 read into the storage device 206 of FIG. In the “form name” of the table management information 301, the name of the form given by the operator is set. In the “table name”, a table name to which the form refers to data is set. Note that the system automatically assigns a unique value to the value of “table name”. for that reason,
Based on the table name, the field management information of the table can be accessed. In the “table name” of the field management information 302, a value corresponding to the “table name” of the table management information 301 is set. In “item name”, an item name existing in the form set in “form name” 301 is set. The column name in the table is set in “column name”. Since the system sets the column name in the form of “table name_serial number”, even if a duplicate name is set in “item name”, it can be treated as a different data item. In the “number of rows”, a value of the number of data rows that can be input / output is set. The value of the number of data digits that can be input / output is set in the “number of digits”. The size of the data input / output field created in step 104 is determined from the number of rows and the number of digits. In the “data type”, the type of data that can be input / output for the item is set. “Ch
If "ar" is set, the character data will be "decimal"
If it is set, numerical data can be input / output. In addition, "money" (money data) and "date" (date data) can be set. In “data length”, a data length that can be input / output of the item is set.

FIG. 4 shows a list of database tables displayed on the display 201 in step 102 of FIG. A form list screen 401 shown in FIG. 4 displays a list of form names set in "form name" of the table management information 301. The operator can easily select a database table by selecting a required form.

FIG. 5 shows a data reference query screen 501 for selecting whether to create an item in the database table selected in step 103 as a data input / output field. In the form name 502, a form name corresponding to the database table selected in step 103 of FIG. 1 is displayed. In the item name 503, an item name corresponding to an item in the selected database table is set.
It is displayed based on the field management information 302. The display button 504 can be set or released by the operator using the mouse 203. When a display mark is given to the display button 506 of a data item to be created as a data input / output field by the operator, the data item can be created as a data input / output field.

FIG. 6 shows the details of the data input / output field information 601 created in step 106. The same as “table name”, “item name”, and “column name” of the field management information 302 in FIG. 3 is set in “table name”, “item name”, and “column name” 601. As for the “display flag”, “display” is set to the data item to which the display mark is added by the operator in step 105, and nothing is set to the data item to which the display mark is not added. A data item for which “display” is set is created as a data input / output field, and a data item for which nothing is set means that it is not created as a data input / output field. “Comparison operator”, “search type”, and “search condition” will be described in the description of FIG.

FIG. 7 shows a data input / output field 702 previously created by the operator in step 106.
In addition, a data reference inquiry screen 501 for setting search conditions using output or input data as a key is displayed on the display 201. Search condition 505
Displays search conditions set by the operator.
The search condition setting panel 506 is a panel for setting a search condition for each data item of the item name 503. The search condition set in 506 by the operator is the search condition 5
05 will be displayed.

Next, referring to the flowchart of FIG.
The details of the search condition setting process in step 107 using the data output or input to the data input / output field as a key will be described. First, the operator inputs the item name 503 in FIG.
The data item for setting the search condition is mouse 203
Then, the search condition setting panel 506 is displayed (step 1071). Next, a data input / output field 702 serving as a key on the form layout creation screen 701 in FIG. 7 is selected by the mouse 203 (step 1).
072). When the confirm button 507 is pressed, the search condition 5
At 05, the name (item name) of the selected data input / output field is displayed (step 1073). Then, the program 205 executes the data input / output field information 6 shown in FIG.
01, the values of the “comparison operator”, “search type”, and “search condition” are updated (step 1074).

FIG. 9 shows the state of the data input / output field information updated in step 1074. “Comparison operators” include “=”, “! =”, “> =”, “<=”,
Operators such as “IN” and “NOTIN” are set.
This value can be selected by the operator.
In “search type”, a flag for determining the type of search is set. To perform a search using data output or input in the data input / output field as a key, set “variable”. When the data displayed in the search condition 505 of FIG. 7 is used for the search as it is, a value “fixed” is set. In the “search condition”, the data displayed in the search condition 505 is set. Through the above operations, the operator can easily set the search condition using the data output and input in the data input / output field as a key.

FIG. 10 shows a state in which the data input / output field 1002 created on the form format creation screen 701 in step 109 is displayed on the display 201.

FIG. 11 is a flowchart showing the details of the data input / output field creation processing in step 109. The data input / output field creation processing will be described with reference to the flowchart in FIG. First, program 20
5 checks the value of the display flag of the data input / output field information 601 created in step 106 of FIG. 1 (step 1091). If no value of the display flag is set, the process returns to step 1091. If the value of the display flag is "display", the item name 601 is created as a heading field (1001 in FIG. 10) of the data input / output field (step 1092). The size of the data input / output field to be created is calculated from the number of rows and the number of digits of the field management information 302 in FIG. 3 (step 1093).
The data input / output field of the calculated size (1 in FIG. 10)
002) is created (step 1094). If there is another data item to be created as the data input / output field, the process returns to step 1091. Figure 1 if not present
The data reference query name given in step 108 is set in the attribute (1003 in FIG. 10) of the data input / output field selected in step 1072 in FIG. 8 (step 1095).

As described above, according to the present embodiment, it is possible to select a database table created in advance, and to arbitrarily select items in the selected database table. Setting search conditions for searching the database table using data output or input as a key,
An arbitrarily selected data item can be easily created as a data input / output field.

(Embodiment 2) FIG. 12 shows a case where data is input to a data input / output field by an operator.
9 is a flowchart illustrating an embodiment of a processing procedure for assembling and executing a search condition expression using the data as a key. The form format creation screen 1301 in FIG. 13 shows a state where the items of the database table have been created as data input / output fields. The execute button 1302 is a button prepared in advance to activate a form created by the operator. The attribute 1303 is an attribute of the data input / output field, and is a name representing the content of the data reference inquiry set in step 1095 of FIG. The data input / output field 1304 is a data input / output field created by the operator according to the procedure shown in FIG. Attribute 130
Reference numeral 5 denotes a form attribute, which is a name representing the data input / output field information set in step 1010 of FIG.

A form execution screen 1401 shown in FIG. 14 shows a state in which a form executed by the operator is displayed on the display 201. The details of the process of assembling and executing a search condition expression will be described with reference to the flowchart of FIG.
First, the execution button 1302 at the top of the form format creation screen 1301 is pressed by the mouse operation of the operator, and the form is activated (step 1201). Next, the program 205 acquires data input / output field information from the attribute of the form set in step 1010 of FIG. 1 (step 1202), and checks the value of the search type (step 120).
3). If the value of the search type is “variable”, step 12
Proceed to 08. If the value of the search type is other than “variable”, search definition information is created (step 1204), a search expression is assembled (step 1205), the search expression is executed (step 1206), and the searched data is The data is output to the data input / output field (step 1207), and the activated form is displayed on the display 201 (step 1208). The operator inputs data to the data input / output field 1402 on 1401 in FIG. 14 (step 1209). At that time, the program 205 determines from step 109 of FIG.
The existence of the data reference query name set in step 5 is checked (step 1210). If the data reference query name exists, the corresponding data input / output field information is acquired from the attribute of the form (step 1211), search definition information is created (step 1212), and a search formula is assembled (step 1213). Then, a search formula is executed (step 1214), and the searched data is output to the corresponding data input / output field (step 1215). Steps 1211 to 1215 are repeated by the number of data reference query names existing in the attribute of the field for which data has been input. If the input of the form data by the operator is not completed, the process returns to step 1209, and the input of the data by the operator is repeated (FIG. 15).

Next, referring to the flowchart of FIG.
The process of creating the search definition information in steps 1204 and 1212 in FIG. 12 will be described. First, the program 205 acquires a database table name from the “table name” of the data input / output field information and holds it as the selected database table name (step 12).
121). The value of the “display flag” is checked, and if “display” is set, the item name is acquired from the “column name” and held as the selected data item name (step 12122).
The value of “search type” is acquired (step 12123).
When the “search type” is set to “variable”, the unique ID of the data input / output field set in the “search condition” is acquired (step 12124). “Fixed”
Is set, the value of “search condition” is obtained as it is (step 12125).

Further, the item name acquired in step 12122, the operator of "comparison operator", and step 12124
Alternatively, the value obtained in step 12125 is separated by a delimiter “,” and stored as search condition information (step 1).
2126). Step 12122 to Step 1212
6 is repeated by the number of data items existing in the data input / output field information.

FIG. 17 is a diagram showing the search definition information 1701 created in step 1212 of FIG. In FIG. 17, 1702 is set with a name representing the data reference inquiry given by the operator in step 108 of FIG. 170
3, the database table acquired in step 12121 is set. Step 112 is added to 1704.
The data item name acquired in step 2 is set. 1705
Is set with the search condition information acquired in step 12126.

Referring to the flowchart of FIG.
The process of assembling a search formula in Step 1213 of Step 2 will be described. First, the selected database table name is acquired from the search definition information created in step 1212 of FIG. 12 (12131). Get selected data item name (1
2132). Acquire search conditions (step 1213)
3). A unique ID is obtained from the search condition (step 12134). The data input / output field is recognized from the unique ID (step 12135). The input / output data is obtained from the data input / output field (step 12).
136), a search formula is assembled (12137). The search expression assembled here is the search condition delimiter ","
Depends on the second comparison expression separated by.

FIG. 19 shows steps 12131 to 1213.
An example of the search formula assembled in No. 7 is shown (1901). If “=” is set in the comparison expression, it means a match search,
Only one unique ID is set (190
2). If “> = | <=” is set, it means range search, and two unique IDs are set (1
903). If there is only “> =” or “<=”, there is one unique ID (1904). “IN”
Alternatively, if “! IN” is set, it means that the value matches one of the plurality of values or does not match any of the plurality of values, and there are a plurality of unique IDs to be set. In this case, the unique ID is separated by a delimiter “|” (1905).

As described above, according to the present embodiment, by inputting or outputting variable data in the data input / output field of an arbitrary form, the form for outputting the data of the existing database table can be reproduced. Without creating
By executing the relevant search formula, it is possible to easily search and output data from the existing database table.

[0026]

As described above, according to the present invention, it is possible to easily set a retrieval formula for retrieving data of another form by using the data input / output in the data input / output field as a key with a mouse operation. Therefore, there is an advantageous effect that data of a plurality of different forms can be easily referred to on one form.

[Brief description of the drawings]

FIG. 1 is a flowchart showing a processing procedure of a form creation method.

FIG. 2 is a diagram illustrating a hardware configuration of a computer device that implements the present invention.

FIG. 3 is a detailed diagram of table management information and field management information.

FIG. 4 is a diagram showing an example in which a list of forms is displayed.

FIG. 5 shows a data reference screen.

FIG. 6 is a detailed diagram of data input / output field information.

FIG. 7 is a diagram showing an example of setting a search expression.

FIG. 8 is a flowchart of a search formula setting process.

FIG. 9 is a detailed view of data input / output field information after setting a search formula.

FIG. 10 is a diagram showing an example in which an arbitrarily selected data item is created as a data input / output field;

FIG. 11 is a flowchart of a data input / output field creation process.

FIG. 12 is a flowchart of a process of searching an existing database table by inputting data.

FIG. 13 is a diagram showing an example in which data items of an existing database table are created as input / output fields.

FIG. 14 is a diagram showing an example of a state in which a form has been executed;

FIG. 15 is a diagram showing an example of a state in which a search based on data input has been executed;

FIG. 16 is a flowchart of processing for creating search definition information.

FIG. 17 is a detailed diagram of search definition information.

FIG. 18 is a flowchart showing a process of assembling a search expression.

FIG. 19 is a diagram showing an example of a search formula assembled from set search conditions.

[Explanation of symbols]

 201 display device 202 keyboard input device 203 mouse input device 204 processing device 205 storage program 206 storage device 301 table management information 302 field management information 401 form list screen 501 data reference inquiry screen 502 database table name display field 503 data item name display field 504 Display button 505 Search condition column 506 Search condition input panel 507 Search condition determination button 601 Data input / output field information 701 Form format creation screen 702 Data input / output field 1001 Data item header field 1002 Data input / output field 1003 Data input / output field attribute 1004 Form attributes 1301 Form format creation screen 1302 Form execution button 1303 Data input / output fields Attribute 1304 Data input / output field 1305 Report attribute 1401 Report execution screen 1402 Data input / output field 1701 Search definition information 1702 Data reference query name storage 1703 Selected database table name storage 1704 Selected data item name storage 1705 Input search condition storage 1901 Form execution screen 1902 Match search formula assembly drawing 1903 Range search formula assembly diagram 1904 Range (start) search formula assembly diagram 1905 IN search formula assembly diagram

 ──────────────────────────────────────────────────続 き Continued on the front page F term (reference) 5B075 ND03 NK02 NK14 NK24 NK44 NK54 PP02 PP03 PP13 PP22 PP23 PQ02 PQ46 QM01 QM10 UU05

Claims (2)

[Claims] 1. A database table selecting means for selecting a first database table created in advance, and data for arbitrarily selecting data items constituting the first database table selected by the database table selecting means. An item selecting means, and the first database using data of a second database table previously created in a data input / output field previously created on a form format creation screen or arbitrary data input by an operator as a key Search condition setting means for setting a search condition for searching table data; and data input / output field information based on the data item selected by the data item selection means and the search condition set by the search condition setting means. Data input / output field information to be created Report creation means, means for creating a data input / output field on the form layout creation screen based on the data input / output information, and data input / output field information storage for storing the data input / output field information as a form attribute And a means for creating a form. 2. Search definition information creating means for creating search definition information based on data input / output field information created by data input / output field information creating means, and search definition information created by said search definition information creating means Search formula assembling means for assembling a search formula based on the search formula, search formula executing means for executing the search formula assembled by the search formula assembling means, and data display means for displaying the execution result of the search formula in the data input / output field 2. The form creation processing system according to claim 1, further comprising: