JPH06337806A - Information processor - Google Patents

Abstract

PURPOSE:To execute a data base definition for storing input data by classification and generation of a data display screen deciding a data display area without using of a programming language and to define the data base at the time of generating the screen so as to improve operability. CONSTITUTION:A screen generation part 3 generates the data display screen and stores it in a file 4 based on the attribute values of parts sticked to the target screen 11 of application development by selecting them from an input parts designation column 12 and parts which are conversationally inputted in an attribute value setting column 16. A data base definition part 5 generates a data base item for classifying and storing input data based on the attribute values of the parts which are conversationally inputted at the time of generating the data display screen, and input data is accumulated in the data base 6 in accordance with the item.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to an information processing apparatus that stores input data as a database and outputs the data using the database.
The present invention relates to an information processing apparatus having a function of creating a data display screen by pasting parts and interactively inputting part attributes and defining a database when creating the screen.

[0002]

2. Description of the Related Art When a database is constructed by accumulating input data in a conventional information processing apparatus, in many cases, the framework of the database is defined in advance by a database definition language (DDL), and the access operation to the database is a database search language. It is described in (SQL etc.) and the display screen of the database data is created by using another programming language.

[0003]

Since a conventional information processing apparatus requires a programming language for database definition and screen creation, programming knowledge is required for application development, and both the database definition and screen creation are programming language. Since it has to be created in, there is a problem that it takes time to develop the application.

The present invention has been made in order to solve such a problem. A data display screen is created by sticking parts and interactively inputting part attributes, and based on the part attributes interactively input at the time of screen creation. An object of the present invention is to provide an information processing apparatus that can easily create a screen and define a database by creating a database item and eliminating the trouble of creating a screen and defining a database twice.

[0005]

An information processing apparatus according to a first aspect of the present invention stores input data as a database and determines the display area of the data in the information processing apparatus which outputs the data using the database. And a means for interactively inputting attribute information of the part, and a means for creating a data display screen based on the attribute pasted on the screen and the interactively input attribute information of the part. It is characterized by

In addition to the first aspect of the invention, the information processing apparatus according to the second aspect of the present invention defines a database by creating items for classifying input data based on the attribute information when a data display screen is created. It is characterized in that it is provided with a means for doing.

An information processing apparatus according to a third aspect of the invention is characterized in that, in addition to the second aspect of the invention, a means for creating a data display screen using a defined database is provided.

In addition to the first, second or third invention, the information processing apparatus according to the fourth invention, when displaying a plurality of database data of the same item in a list, displays the display start position and the display position of the database data. A means for interactively inputting the number and display interval, and means for creating a screen for displaying a plurality of database data of the same item only by determining one data display area and interactively inputting the attribute information are provided. Is characterized by.

[0009]

In the information processing apparatus according to the first aspect of the present invention, the parts that determine the data display area are pasted on the screen, and attribute information such as the part name, display start position, width, and height of the pasted parts is interactively input. Create a data display screen.

The information processing apparatus according to the second aspect of the present invention creates a database item for classifying and storing the input data from the attribute information of the parts interactively input at the time of creating the data display screen to create a database. Is defined.

An information processing apparatus according to the third invention creates a data display screen by using a defined database defined on the basis of attribute information of parts.

In the information processing apparatus according to the fourth invention, when displaying a plurality of database data of the same item in a list, a display area for one database data is determined and a display start position, a display number and a display interval are set. Just enter interactively,
Create a screen that lists multiple database data of the same item.

[0013]

DESCRIPTION OF THE PREFERRED EMBODIMENTS The present invention will be described below with reference to the drawings showing its embodiments. FIG. 1 shows an information processing apparatus according to the present invention (hereinafter,
FIG. 3 is a block diagram showing the configuration of the device of the present invention). In the figure, reference numeral 1 denotes a display screen for developing an application by sticking parts using an input means 2 such as a mouse and a keyboard. The display screen 1 is a target screen assuming a screen of an application development target. 11, an input component designation field 12 for designating a pasting component for determining the data display area on the target screen 11, a background designation field 13 for designating the background of the target screen 11, and a selection of a pasting component on the target screen 11. The pasted parts specification field 14 for opening the window, the processing item specification field 15 for specifying the processing items on the target screen 11 such as "new creation" and "screen registration", and the attribute values of the parts pasted on the target screen 11 are displayed. An attribute value setting field 16 for interactive input is provided.

The screen creating section 3 is attached to the target screen 11 by the input means 2 and is part information consisting of attribute values which are interactively input to the part which determines the data display area.
Also, the data display screen is created based on the standard display information such as the character string input in the background of the data display area and the file 4
To store.

The database defining unit 5 stores the screen created by the screen creating unit 3 in the file 4, and when the database creating flag is set, the part name, the number of digits, and the data type in the part information. Based on the above, items for classifying the input data into data sets having the same property are created and the database 6 is defined. Input data is stored in the database 6 for each item created by the database definition unit 5.

The parts information expanding unit 7 reads the data corresponding to the parts information read from the file 4 from the database 6 and expands it in the parts management table 8, and the list display unit 9 reads the standard display information read from the file 4 on the target screen. 11, the database data of the parts management table 8 is displayed on the target screen 11 as a list.

Next, the procedure for newly creating a data display screen and the procedure for defining a database associated with the creation of a new screen by the apparatus of the present invention having the above-described configuration will be described based on the screen display examples of FIGS. 2 to 7. . In the initial screen of the database definition (Fig. 2) that is performed when creating a new screen, select the key "input component" in the paste component specification column 14
At 12, for example, "text" for determining the area where character data can be input / output is selected (FIG. 3), and the cursor is dragged to paste the text part on the target screen 11 (FIG. 4). Next, in the attribute value setting field 16, the attribute item “part name” “upper left coordinate” of the pasted text part
Values are interactively input in "width", "height", "number of parts", "part repetition interval", etc. (Fig. 5).

FIG. 6 shows a state in which the above parts pasting is repeated to determine a plurality of data display areas and the screen creation is completed, and each part information (part attribute) of this screen,
Also, the standard display information such as "phonetic", "name", "telephone", "address", "contents" character string indicating the type of input / output data at the beginning of each data display area, and ruled lines (thin lines) surrounding each data display area are displayed. Save to file 4.

To define a database based on a newly created screen, select "Create database" in the processing item designation column 14 (Fig. 6) and select "Set" in the "Create database" item in the screen attribute column. To set the database creation flag for saving the result of new screen creation as a database (FIG. 7). If the database creation flag is set when the component information and the standard display information are saved in the file 4, the database definition unit 5 inputs based on the component name, the number of digits, and the data type obtained from the attribute information of the component. Create database items to classify data into data sets with the same properties. For example, if it is a database of "address book", "name""phone""address"
Create items such as.

Next, a procedure for creating a list type screen using a defined database will be described based on the screen display examples shown in FIGS. 8 to 11 and the flowchart shown in FIG. As described above, in the device of the present invention, since the database is defined based on the component information, the defined database can be used as the component for screen creation. If you select “Database” in the pasted parts specification field 14, (S
1), the items of the current database "address book" are displayed (Fig. 8). For example, when creating an input / output item of "name" on the screen, select "name" (Fig. 9) and paste it on the screen (S2) (Fig. 10). Since the screen is a list type, the items are pasted on top. Next, although the attribute value is set in the attribute value setting field 16, "name" is automatically displayed in the "part name" item. In addition, set the coordinate value at the top of the list in the "Upper left coordinate" item,
(S3) (FIG. 11) can be omitted by entering values for (the number of parts displayed on one screen) and “part repeat interval” (FIG. 11). Save the part information and the standard display information of the screen created in this way in the file 4.
(S4).

Similarly to "Name", "Name" and "Name" are displayed on the list screen (FIG. 13) created by setting "8" in "Number of parts" and "1" in "Part repeat interval" of "Address". FIG. 14 shows a state in which the database data of “address” is displayed.

Next, the procedure for displaying a list of database data on the list screen will be described with reference to the block diagram of FIG. 1 and the flowchart of FIG. The list display unit 9 reads the standard display information (characters, ruled lines, background) and component information of the corresponding list screen from the file 4 (S5), and displays the standard display information (S6). On the other hand, the component information developing unit 7 develops the component information in the component management table 8 by the procedure described later (S7). The list display unit 9 reads the data in the database 6 based on the component name and offset in the component management table 8 (S8), and sequentially displays the database data expanded in the component management table 8 at the corresponding display positions (S9).

FIG. 16 is a flow chart showing the details of the procedure for expanding the component information into the component management table 8 at step S7 described above. The conceptual diagram of the data in the database 6 shown in FIG. 17 and the file 4 shown in FIG. The procedure for developing the parts will be described with reference to the conceptual view of the parts information of FIG. The attribute values of the "component name", "upper left coordinate", "width", "height" and "input / display attribute" of the first component are calculated from the component information of the file 4 in the component management table 8
(S71), and the "offset" of the parts management table 8 is set to "0" (S72). The value "4" of "number of parts" in the parts management table 8 is set as a variable, and it is determined whether the number of parts is "1" based on this variable value (S73). The number of parts is "1". If not, copy the attribute value of "part name", "width", "height", "input / display attribute" of the next part to the next row of the part management table 8 (S74) The value "7" obtained by adding the value "2" of the "component repeating interval" to the vertical value "5" of the upper left coordinate "is copied to the" upper left coordinate "field of the second component (S75). Further, the value "1" obtained by adding "1" to the "offset" value "0" of the immediately preceding first component in the component management table 8 is copied to the "offset" field of the second component ( S76). The pointer of the parts management table 8 is advanced and the variable of the number of parts is set to "1".
Decrease (S77).

On the other hand, if the result of determination in step S73 is that the number of components is "1", the component information of the file 4 and the pointer of the component management table 8 are advanced (S78), and it is determined whether or not there is component information ( (S79), if there is part information in the file 4, the process returns to step S71 to repeat the processing of S71 to S78, and if there is no part information, the processing ends.

Next, the screen creation procedure for displaying one line of information "name""address""phone""FAX" in two lines in the "address book" list is shown in FIGS. 20 to 26. A display example will be described. Paste the text parts and decide the data display area of "Name" and "Address" on the first line,
After creating a list screen like this, set the attribute values of "name" and "address" in the attribute value setting field 16 as shown in Figs. 20 and 21, but display the data of "name" and "address". In order to create a list screen (Fig. 22) in which the area is every other line,
Set "4" in "number of parts" and "2" in "part repeat interval".

Then, in the vacant line, "phone" and "FA"
The parts of "X" are pasted and the respective attribute values are set. At this time, in addition to setting "4" for "number of parts" and "2" for "part repeat interval", the initial value of "upper left coordinate" is set. Set "4, 6" for "phone" and "22, 6" for "FAX" (Fig. 23, Fig. 24) In the list screen (Fig. 25) created in this way, one "name""Address""Telephone""F
FIG. 26 shows a state in which the database data of "AX" is displayed over two lines.

As described above, when displaying a plurality of data as a list, the list display screen can be created by simply determining the display area of one data and interactively inputting the attribute information, so that the operability is good.

[0028]

The apparatus of the present invention can create a data display screen and define a database by an easy operation that does not depend on a programming language, define a database when creating a data display screen, and use the defined data. Since it is possible to create a screen by doing so, even a user who does not have programming knowledge can easily create an application in a short period of time.

[Brief description of drawings]

FIG. 1 is a block diagram of a device of the present invention.

FIG. 2 is a diagram showing a screen display example for explaining a procedure for creating a screen.

FIG. 3 is a diagram showing a screen display example for explaining a procedure for creating a screen.

FIG. 4 is a diagram showing a screen display example for explaining a procedure for creating a screen.

FIG. 5 is a diagram showing a screen display example for explaining a procedure for creating a screen.

FIG. 6 is a diagram showing a screen display example for explaining a procedure for creating a screen.

FIG. 7 is a diagram showing a screen display example for explaining a procedure for creating a screen.

FIG. 8 is a diagram of a screen display example illustrating a procedure of creating a screen using a defined database.

FIG. 9 is a diagram of a screen display example illustrating a procedure for creating a screen using a defined database.

FIG. 10 is a diagram of a screen display example illustrating a procedure for creating a screen using a defined database.

FIG. 11 is a diagram showing a screen display example for explaining a procedure for creating a screen using a defined database.

FIG. 12 is a flowchart showing a procedure for creating a screen using a defined database.

FIG. 13 is a diagram of a screen display example illustrating a procedure for creating a list display screen.

FIG. 14 is a diagram showing a screen display example in which a list of database data is displayed on the list display screen.

FIG. 15 is a flowchart showing a procedure for displaying a list.

FIG. 16 is a flowchart showing a procedure of expanding component information in a component management table.

FIG. 17 is a conceptual diagram of data in a database.

FIG. 18 is a conceptual diagram of part information of a file.

FIG. 19 is a conceptual diagram of a parts management table.

FIG. 20 is a diagram of a screen display example illustrating a procedure for creating a list display screen that displays data for one case over two lines.

FIG. 21 is a diagram of a screen display example illustrating a procedure for creating a list display screen that displays data for one case over two lines.

FIG. 22 is a diagram of a screen display example illustrating a procedure for creating a list display screen that displays data for one case over two lines.

FIG. 23 is a diagram of a screen display example illustrating a procedure for creating a list display screen that displays data for one case over two lines.

FIG. 24 is a diagram of a screen display example illustrating a procedure for creating a list display screen that displays data for one case over two lines.

[Fig. 25] Fig. 25 is a diagram illustrating a screen display example illustrating a procedure for creating a list display screen that displays data for one case over two lines.

FIG. 26 is a diagram showing a screen display example in which a list of database data is displayed on the list display screen.

[Explanation of symbols]

 1 Display screen 2 Input means 3 Screen creation part 4 File 5 Database definition part 6 Database 7 Parts information development part 8 Parts management table 9 List display part 11 Target screen 12 Input parts specification field 13 Background specification field 14 Paste parts specification field 15 Processing Item specification field 16 Attribute value setting field

 ─────────────────────────────────────────────────── ─── Continuation of the front page (72) Inventor Kimio Nagasawa 2-18 Keihan Hondori, Moriguchi City, Osaka Sanyo Electric Co., Ltd.

Claims (4)

[Claims] 1. An information processing apparatus for accumulating input data as a database and outputting the data using the database, wherein a means for pasting a part for determining a data display area and a part attribute information are interactive. An information processing apparatus comprising: an input unit; and a unit for creating a data display screen based on a part attached to a screen and attribute information of the part that is interactively input. 2. The information processing apparatus according to claim 1, further comprising means for creating an item for classifying input data based on the attribute information and defining a database when the data display screen is created. 3. The information processing apparatus according to claim 2, further comprising means for creating a data display screen using a defined database. 4. When displaying a plurality of database data of the same item in a list, a means for interactively inputting a display start position, a display number, and a display interval of the database data, determination of one data display area, and determination of the attribute information. 3. A means for creating a screen for displaying a plurality of database data of the same item only by interactive input.
Alternatively, the information processing device according to item 3.