JPH08272574A - Data display device - Google Patents

Abstract

PURPOSE: To provide a data display device which facilitates the recognition of an input content by means of a user so as to avoid misoperation and by which a program generator can more easily generate and change a program. CONSTITUTION: The data display device is provided with a display part 110, a data base 200 storing data displayed on the display part 110 and a data base access part 150 accessing the data base 200. A box generation part 130 displays data accessed by the data base access part 150 on the display part 110 in the system of a box and decides the specification of the box based on information accessed by the data base access part 150. Thus, a large amount of list display can easily be executed. Furthermore, a data base item except for a code and a name can be designated as a list display item.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to components used in a computer. For example, the program receives input of data, processes the data, and outputs the held data on a screen, a form, or the like. Some types of input data are of a type that is selected from a predetermined set. The present invention relates to a data display device that processes a code that a human can easily enter into a machine and a name that a human can easily understand as a pair.

[0002]

2. Description of the Related Art Conventionally, when a program is created or executed, a screen component combining an input area and a list display has been used for data input consisting of a code and a name. FIG. 34 is a diagram showing a drop-down combo box. Drop-down combo box is, for example, "MicrosoftWindo" issued by Microsoft Corporation in June 1993.
ws Version 3.1 Software Development Kit Windows Interface Application Design Guide ”135
1 to 136 are examples of screens showing an input method of program constituent elements in the conventional code input shown on pages 136 to 136; FIG.
4, 901 is a program component, 902 is a cursor, 903 is a display, 904 is a computer, 90
Reference numeral 5 is a keyboard and 906 is a mouse. The program component 901 includes an input area 911 and a button 91 for opening a list.
2. It consists of a list display 913.

Next, the operation will be described. The program component 901 has a screen form as shown in FIG. 35 in the initial state when the program is executed. When the mouse 906 is operated on a desk or the like, the cursor 902 moves on the display 903 according to the operation of the mouse. Move the cursor 902 to the position of the button 912 to open the list and click the mouse 9
When the button on 06 is pressed, a list display 913 is displayed, and the screen form is as shown in FIG.

In the state shown in FIG. 34, the mouse 906 is used to
For example, if you move the cursor 902 to the position "02 Kanagawa" and press the button on the mouse 906,
"Kanagawa Prefecture" is selected, "02 Kanagawa Prefecture" is posted in the input area 911, and the list display 913 is displayed on the display 90.
It disappears from 3, and the screen form becomes as shown in FIG.

Next, an operation by a program creator when creating a conventional program will be described. FIG. 37 shows, for example, “Nikkei Open System” 27 issued in September 1994.
7 is a screen showing program creation using conventional program components on pages 7 to 279. From the menu, select the generation of the program component 901, and use the mouse 906 and the cursor 902 to display the program 9.
Specify the position and size in 03, source program 9
The item name displayed in the list display 913 is designated at 07.

Next, the operation of the conventional program components will be described with reference to the flowcharts of the conventional program components shown in FIGS.

FIG. 38 is a flowchart (generation of list display) in the conventional program constituent elements. This flowchart starts from the initial state screen shown in FIG.
It corresponds to the change of the screen form to the screen shown in FIG. FIG.
The processing of this flowchart is started from the state shown in FIG. First, in S900, a button 91 for opening the list of FIG.
Determine if 2 was selected. If not selected, the process ends. If the open list button 912 is selected, each item name designated by the source program 907 of FIG. 37 stored in the memory in S901 is transferred to the list display 913 of FIG. Succeedingly, in S902, it is determined whether or not the transfer of all the item names is completed. If not completed, the processing from S901 is repeated again. When the transfer of all the items is completed, a list display 913 having all the item names is displayed on the display 903 in S903.

FIG. 39 is a flowchart of a conventional program component corresponding to the change of the screen form from the display in which the list display 913 shown in FIG. 34 is open to the display in which the item shown in FIG. 36 is selected. (Selection of items). First, in S910, it is determined whether any item in the list display 913 in FIG. 34 is selected. If not selected, the process ends. If it is selected, in step S911 in FIG.
The number of items selected from the position of the cursor 902 of 4 is calculated. Next, the items selected in S912 are shown in FIG.
6 is input to the input area 911. Next, in step S913, the list display 913 is deleted from the display 903.

FIG. 40 shows an example of code input from the keyboard 905 of a conventional program component (code input from keyboard). By pressing the key “0” and the key “2” on the keyboard 5 in the input area 911,
This is the screen form when the input of the code “02” is completed.

[0010]

Since the conventional program components are configured as described above, the contents of the input area of the screen form (FIG. 36) at the time of mouse operation is "02 Kanagawa prefecture" and at the time of keyboard operation. There is a problem that it is difficult to confirm whether or not the user has selected the code when operating the keyboard, because the contents of the input area of the screen form diagram (Fig. 40) are different from "02" and "Kanagawa prefecture". Was included.

In order to solve this problem, the program creator has conventionally used a character string ("0" set in the input area 911.
2 "Kanagawa Prefecture" or "02"
I had to write a program to retrieve the code part "02" from.

Further, when displaying a large number of lists, it is difficult to modify the programs because the source program for setting the character strings to be displayed becomes long and the loop control structure is incorporated.

Further, when the character strings to be displayed in a list have the same or very similar contents, the user is confused at the time of selection or is selected by mistake.

Further, if the character strings to be displayed as a list have the same or very similar contents, the user is confused at the time of selection or is selected by mistake.

Further, when the program creator arranges the program components on the screen, setting the size of the program components on the screen to a required size is a complicated task. Therefore, it has been desired to reduce the work load.

Further, when the program creator arranges the program components on the screen, it has been a complicated task to set the item names for explaining the program components as labels. Therefore, similarly to the above, it has been desired to reduce the work load.

If there are many items displayed in the list,
When selecting a desired item from a small list display, it takes time for the operator to find the item to be selected.

In addition, for example, in the case of a printer that cannot print Chinese characters, Kana characters may be displayed, and in other cases, Chinese characters may be displayed. When a name group to be displayed at that stage is selected from such a plurality of name groups, it is not easy for the program creator to change the name group, which has been a development burden.

The present invention has been made to solve the above problems, and in the data input process consisting of a code and a name, the screen form when operating the mouse is the same as the screen form when operating the keyboard. The purpose is to obtain a data display device that allows the user to confirm the input contents.

It is another object of the present invention to provide a data display device in which items can be selected even if a user inputs only a code from a keyboard.

Further, the purpose of the program creator is to obtain a data display device which does not need to create a program for extracting a code portion from a character string set in the input area.

Further, for a large number of list displays, a data display device capable of obtaining a desired function only by designating a database holding codes and names without individually setting a list display character string is provided. The purpose is to get.

It is another object of the present invention to provide a data display in which additional information can be specified in addition to the code and name in the list display.

It is another object of the present invention to provide a data display device capable of designating conditions for narrowing down display contents or a data display device for inquiring conditions for narrowing down display contents.

Another object is to obtain a data display device for automatically calculating the lateral length of the input area.

Another object of the present invention is to obtain a data display device for automatically setting item names for input areas.

It is another object of the present invention to obtain a data display device that displays a list display in a larger size than in the past.

It is another object of the present invention to provide a data display device capable of easily selecting a character string group to be used from a plurality of character string groups.

[0029]

A data display device of the present invention is characterized by having the following elements. (A) a display unit for displaying data, (b) a database storing data to be displayed on the display unit, (c) a database access unit for accessing the database,
(D) A box generation unit that displays the data accessed by the database access unit in the form of a box on the display unit and determines the specifications of the box based on the information accessed by the database access unit.

The box generating unit is characterized by including a length determining unit for determining the length of the characters displayed in the box according to the length of the data to be displayed.

The box generation unit is characterized by including a number-of-cases determination unit that determines the number of data items to be displayed in the box in accordance with the number of data items to be displayed.

The box generation unit is characterized by including an item name use unit that uses the item name used in the database as a label used for the box.

The box generating unit is characterized by including a selecting unit for selecting the data accessed by the database access unit from the database according to conditions.

The box is a list display box area for displaying a list of a plurality of data.

The box is an input display box area for inputting and displaying one data.

The data display device of the present invention is characterized by having the following elements. (A) a display section for displaying data, (b) first display means for displaying an input display box area for inputting and displaying data on the display section, (c) input for the input display box area Second display means for displaying a list display box area for displaying a candidate list of data to be displayed as a pair of codes and names on the display section, and (d) input displayed by the first display means. First data input means for inputting the code displayed in the list display box area to the display box area and displaying the input code and the name corresponding to the code, (e) the second display means Second data input means for selecting any code and name displayed in the list display box area by and displaying the selected code and name in the input display box area.

The box generated by the box generation unit is Windows (Microsoft Microsoft Corp.).
It is characterized by being applied to an application running on a trademark of "poration".

The box generated by the box generation unit is a Visual Basic (US Microsof).
It is applied to an application running on a trademark of T Corporation).

[0039]

The data display device of the present invention has a display section for displaying data, a database for storing the data to be displayed on the display section, and a database access section for accessing the database. The data accessed by the database access unit is displayed on the display unit in the form of a box, and the specifications of the box are determined based on the information accessed by the database access unit. This makes it possible to easily display a large number of lists. Also, database items other than codes and names can be designated as list display items.

The box generation unit includes a length determination unit that determines the length of the character displayed in the box according to the length of the data to be displayed. The length determination unit automatically calculates the length of the character displayed in the box from the number of digits of the specified data item in the database.

The box generation unit includes a number-of-cases determination unit that determines the number of data items to be displayed in the box according to the number of data items to be displayed. The number determination unit, for example,
When displaying a large number of lists, the list display is displayed as a separate screen, so that the number of list displays that the operator can see at one time is increased to shorten the time for the operator to find the item to select. You can

The box generation unit includes an item name use unit that uses the item name used by the database as the label used for the box. The item name use unit automatically sets the item name used for the label from the database name or the code column name.

The box generation unit includes a selection unit that selects the data accessed by the database access unit from the database according to conditions. The selection unit is, for example,
When displaying a large amount of data, create display conditions based on the display conditions and database item values, and reduce the number of items displayed.

The box is a list display box area for displaying a list of a plurality of data. Therefore, it is possible to specify a condition as a list display item of database items other than the code and the name. Alternatively, a condition database item can be specified as a list display item of database items other than codes and names, and a sub-screen for inquiring the operator of the condition database item is displayed.

The box is an input display box area for inputting and displaying one data. If this input display box area is provided with an input area and a name display section, the name will be displayed in a name display section that is separate from the input area when the mouse is operated. The screen form is the same, and the user can confirm the input contents. Also, since only the code is set in the input area,
The program creator does not have to create a program for extracting the code part from the input area character string.

The data display device of the present invention comprises a display section for displaying data, and the first display means displays an input display box area for inputting and displaying the data on the display section. The second display means displays a list display box area for displaying a candidate list of data to be input and displayed in the input display box area on a pair of the code and the name. The first data input means causes the input display box area displayed by the first display means to input the code displayed in the list display box area, and the input code and a name corresponding to the code. Is displayed. The second data input means causes the second display means to select any code and name displayed in the list display box area, and displays the selected code and name in the input display box area. To do.

The box generated by the box generation unit is Windows (Microsoft Microsoft Corp.).
This is a box that is applied to applications running on (trademark of corporation).

The box generated by the box generator is a Visual Basic (Microsof, USA).
t application (trademark of Corporation).

[0049]

【Example】

Example 1. An embodiment of the present invention will be described below with reference to the drawings. FIG. 1 is a block diagram showing the configuration of the data display device of the present invention. In the figure, reference numeral 110 denotes a display unit, an input display box area 112, a list display box area 1
14 is displayed. Reference numeral 130 denotes a box generation unit, which includes a length determination unit 132, a number determination unit 134, and an item name use unit 13
6. It has a selection unit 138. Reference numeral 150 denotes a database access unit that accesses the database 200. FIG. 2 is a screen form diagram according to the present invention. In the figure, 902 is a cursor, 903 is a display, and 904.
Is a calculator, 905 is a keyboard, and 906 is a mouse. The input display box area 112 includes an input area 11, a button 12 for opening a list, and a name display area 14. The list display box area 114 also includes a list display 13. It should be noted that the dotted lines in the figure are used to clearly indicate the ranges of the constituent elements and need not be displayed on the actual display. FIG. 3 is a screen form diagram in an initial state when the data display device of the present invention is operated. FIG. 4 is a screen form diagram when a list is displayed. FIG. 5 is a screen form diagram when an item is selected.

Next, the operation will be described. The input display box area 112 has a screen form as shown in FIG. 3 in an initial state during operation of the data display device. Mouse 90
When 6 is moved on the desk, the cursor 902 moves on the display 903. When the cursor 902 is moved to the position of the button 12 for opening the list and the button on the mouse 906 is pressed, the list display 13 is displayed. The screen form is shown in Figure 4.
It becomes like the screen form figure (at the time of list display) shown in.

In the state of FIG. 4, using the mouse 906, for example, when the cursor 902 is moved to the position "02 Kanagawa prefecture" and the button on the mouse 906 is pressed, "02 Kanagawa prefecture" is selected and the code " 02 ”is transcribed in the input area 11, the name“ Kanagawa ”is transcribed in the name display area 14, the list display 13 disappears from the display 903, and the screen form is as shown in FIG. 5 (when selecting items). become.

Next, the operation of the box generation unit 130 that prepares the data for list display as a database and specifies the database name to determine the specifications of the box area will be described.

FIG. 6 shows a database configuration diagram for holding codes and names. In the figure, 200 is a database,
70 is a database name, 71 is a district code, 72 is a district name, 73 is a district name kana, 74 is a store name, and 75 is a block name. Reference numerals 71 to 75 are columns that form the database 200 in which the database name 70 is a district. The database name 70 corresponds to a file name stored in an external storage device such as a disk.

FIG. 7 is a diagram for explaining the operation of the box generator of this embodiment. In the figure, 7 is a source program that defines the specifications of the box displayed in the data display device. “DB”, “CODE”, and “MEISYO” described in the source program 7 are attributes that define the specifications of the box. As shown in FIG. 7, the attribute “DB” has the database name 70 and the attribute “CODE” has
A district code 71 is designated for the attribute, and a district name 72 is designated for the attribute "MEISYO". DB access unit 150
Accesses the database 200 by referring to the definition of the specification of the box described in the source program 7, and refers to the column of the district code and the district name from the database having the database name "district" and displays it in the box.

FIG. 8 shows the case where a database is used.
5 is a flowchart (generation of list display) corresponding to a change in the screen form of FIGS. 3 to 4. First, in S100, as shown in FIG.
It is determined whether or not the button 12 for opening the list is selected. If not selected, the process ends. If selected,
In S101, the database name 70 designated by the source program 7 shown in FIG. 7, that is, the area code and the area name from the database 200 shown in FIG. 6 are input and linked, and the list is displayed in the list display 13 of FIG. Next, in S102, it is determined whether or not all transcriptions have been completed. If not completed, the process of S101 is repeated again. When all the transcriptions are completed, the list display 13 in which the district code and the district name are set is displayed on the display 903 in S103.

As described above, since the data display device of this embodiment is provided with the box generation section and the database access section, the specification of the box can be defined only by designating the database name and the columns constituting the database. Yes, there is no need to write long programs or complicated programs.

Example 2. In the above-described embodiment, the case where the column district code 71 corresponding to the code and the column district name 72 corresponding to the name are displayed in the list has been described, but other columns in the database 200 of FIG. It may be displayed.

FIG. 9 shows a screen form diagram including additional information. In the list display 13, in addition to the column district code 71 corresponding to the code and the column district name 72 corresponding to the name, the district name kana 73, the store name 74, and the block name 75 are displayed.

FIG. 10 shows a source program for displaying additional information. As shown in the figure, in this embodiment, "OT
The attribute "HER" is used. Using this attribute, the source program 7 has a database name 70 displayed in the list display 13 shown in FIG. 9, a column district code 71 corresponding to the code, and a column district name 72 corresponding to the name.
In addition to the district name Kana 73, store name 74, block name 75
Is specified.

Further, although the list display 13 in FIG. 9 shows the method in which the column delimiters are blank, the method in which the column delimiters are lines as shown in FIG. 11 may also be used. Has the same effect.

Further, in FIG. 10, the method of designating the additional information in one line is shown. However, the method of designating the additional information in a plurality of lines is also possible, and the same effect as the above-mentioned embodiment is obtained.

Example 3. Further, in the above-mentioned embodiment, the method of displaying all the columns (records) existing in the database in the list display is shown, but it is the method of selecting and displaying only the column records that match the specified condition. May be.

The operation of the selection unit 138 will be described with reference to the drawings. FIG. 12 shows a screen form diagram (with list display condition). In the figure, an input area 9 is a condition input area for designating a condition for selecting a record. For example, if "head office" is entered in the input area 9 and a list display is instructed, the list display 13 displays the records in the database configuration diagram shown in FIG.
Only those whose store name 74 is “main store” are selected and displayed.

FIG. 13 shows a source program for designating display conditions. In the source program 7, in addition to the database name 70 displayed in the list display 13, the column district code 71 corresponding to the code and the column district name 72 corresponding to the name, the store name 74 is equal to the contents of the input area 9 in FIG. This is specified as the display condition of the list display 13. The """described in the source program is used as a delimiter that encloses the character string. If you want to describe""" in the character string itself, you can write two consecutive """". Shall be taken. Also, "&" is a connector. Therefore, the attribute “CONDITION” is a combination of the character string “store name =” ”and the store name.TEXT that indicates the contents of the input area 9 in FIG. 12, that is,“ main store ”and“ ””, so “store name =” main store “”

FIG. 14 is a flow chart (generation of list display when display conditions are designated). First, S110
It is determined whether or not the button 12 for opening the list has been selected. If not selected, the process ends. If selected,
The database name 70 specified by the source program 7 of FIG. 13 in S101a, that is, the database 20 of FIG.
Enter the district code and district name from 0 in one line (one record). Next, in S112, it is determined whether or not all the inputs have been completed. If the input is not completed, it is determined in S114 whether the input data matches the designated display condition. If they match, the code and the name are linked in S101b, and the code is transferred to the list display 13 in FIG. next,
Return to S101a. If they do not match in S114, S10
Return to 1a. When all the input is completed in S112, the list display 13 in which the district code and the district name of the record matching the display condition are set is displayed on the display 903 in S113.

As described above, in the embodiment, the case of generating the list display when the display condition is designated has been described. As a result, the number of lines displayed in the list display box can be reduced.

Example 4. In this embodiment, the operations of the box generation unit and the database access unit will be described. The length determination unit refers to the number of digits of the code column corresponding to the data displayed in the box by the database access unit, and automatically calculates the length that can be displayed in the box. Also, the item name use unit automatically sets the designated database name or the corresponding code column name as the label of the item name.

FIG. 15 shows a screen form diagram (initial state).
The input display box area 112 includes a component label 15,
Input area label 16, input area 11, button 1 to open the list
2, name display labels 17a, 17b, name display area 14
a, 14b. The name display label 17a corresponds to the name display area 14a, and the name display label 17b corresponds to the name display area 14b. The length of the characters in the input area 11 is set by the length determining unit 132 so that a two-digit number can be set.

FIG. 16 shows a flowchart for calculating the character length of the input area 11 shown in FIG. Figure 17
It is a figure which shows the source program which defines the specification of the box of this Example. In this source program, the box specification is defined using the attribute "COLUMN" called a column. The attribute "COLUMN" is an array, and the numbers indicating the relative positions in the array are used to define other attributes. The details will be described below. In the source program 7, the database name 70 displayed in the list display 13 and the column name used in the list display 76 are designated. 71 indicates that the first column name (district code) is a code. Reference numeral 72 indicates that the column names displayed in the name display area are the second (district name) and the third (district name kana). Reference numeral 77 designates that the condition input sub-screen 18 in FIG. 20, which will be described later, is displayed when the list is displayed. Also, on the condition input sub-screen 18, 4
It relatively specifies that the second (store name) and the fifth (block name) column names can be conditionally specified.

The flowchart of FIG. 16 will be described. First, in S1210, the column name representing the code is obtained.
Here, from the source program 71 shown in FIG. 17,
It can be seen that the first column is the column representing the code, and the "district code" described in the first column from 76 of the source program shown in FIG. 17 is the column name of the database 200 representing the code. Recognize. Next, in step S1211, the database access unit obtains the number of digits in the "district code" column from the database 200.
The database access unit refers to the definition information of the database corresponding to the configuration diagram shown in FIG. 6 and obtains the two-digit number from the district code column 71. Next, in step S1212, the database access unit obtains the district code column type. For example, when the type is a number type, it is found that the character having the maximum width is "0". Next, the size of the phantom (font) displayed in S1213 is obtained. For example, 16
Suppose it turns out to be a dot. Finally, in S1214, as shown in FIG.
The width of the input area 11 in 5 can be obtained by a calculation formula such as the number of digits × font size. As described above, the length determining unit determines the length of the box.

Next, the operation of the item name utilization section will be described. FIG. 18 shows a flowchart for generating the component label 15 of FIG. First, in S1218, as shown in FIG.
The database name "district" is obtained from 70 of 7. Then S
In 1219, the component label 15 of FIG. 15 is generated at the head position (upper left in the screen coordinates) of the input display box area.

FIG. 19 shows a flowchart for generating the input area label 16 of FIG. In S1220, FIG.
The column name "district code" is obtained from 71 and 76 in FIG.
Next, in S1221, the input area label 16 of FIG. 15 is generated in the input display box area.

FIG. 20 shows the name display area label 17 of FIG.
The flowchart which produces | generates a, 17b is shown. S122
At 2, it is determined whether all the name displays at 72 in FIG. 17 have been processed. If there are unprocessed items, S12
At 23, the corresponding column name is obtained from 72 and 76 in FIG. Next, in S1224, the name display area label 17a of FIG. 15 is generated. Next, in FIG.
The name display area 14a is generated. Next, the process returns to the determination of S1222. The same processing is repeated while the name is displayed. When the name is no longer displayed, the determination in S1222 is NO, and the process ends.

Next, a method of inquiring the operator of the conditions in the method of displaying only the columns that meet the specified conditions will be described.

FIG. 21 shows a screen form diagram (condition specification).
FIG. 21 is a screen form diagram when the button 12 for opening the list is selected in FIG. 18 is a condition input sub-screen,
Reference numeral 181 is an input area label, 182 is an input area for inputting conditions, 183 is a button for opening a list, and 184 is a button for closing the condition input sub-screen 18. When "Main store" is set in the input area 182 (to the right of the input area label 181 in which "Store name" is a display character string) corresponding to the store name, and the open list button 183 is selected, the list is displayed. When the button 184 for closing the condition input sub-screen is selected with the mouse or the like, the screen form returns to FIG.

FIG. 22 shows the condition input sub-screen 18 of FIG.
9 shows a flowchart for generating First, in S1201, the first condition from 77 in the source program shown in FIG. 17 is read. Next, in S1202, it is determined whether all the conditions of 77 in FIG. 17 have been processed. If all the conditions have been processed, in step S1209 the button 183 for opening the list and the button 1 for closing the condition input sub-screen in FIG.
84 is generated on the condition input sub-screen 18, the size of the condition input sub-screen 18 is calculated, and the condition input sub-screen 18 is displayed. If all the conditions have not been processed in the determination in S1202, in S1203, a number indicating the relative position of the attribute column designated in the attribute condition 77 of FIG. 17, that is, 76 in FIG. 17 based on the relative condition number. Column name is obtained. Next, S12
At 04, the input area label 181 of FIG. 21 is generated on the condition input sub-screen 18. Next, in S1205, the number of digits of the corresponding column is obtained from the database 200 of FIG. Then S
At 1206, the input area 182 of FIG. 21 is generated. Then S
In 1208, the condition next to 77 in FIG. 17 is read, and S1
Proceed to judgment 201.

Further, in the above-mentioned embodiment, the method of displaying the list display on the screen having the input area is shown.
A method of displaying the list display on another screen may be used.

Further, in the method of displaying the list display on another screen, a method of automatically setting a database name in the title of another screen may be used.

Further, in the method of displaying the list display on another screen, a method of automatically setting the database column name in the list display column title may be used.

FIG. 23 shows a screen form diagram (list display).
A list display 13 is displayed in the display 903. The list display 13 includes a button 1301 for selecting an item,
A button 1302 for returning to the original screen, a title 1303, and a plurality of column names 1304 are included. Code "0" with a mouse
1 ”is selected and the select button 1301 is selected,
Information corresponding to the code “01” is input by the database access unit to the input area 11 and the name display areas 14a and 14 of FIG.
b. A button 1302 for returning to the original screen
When is selected, the screen form returns to the screen form diagram (condition specification) in FIG. 21 before displaying the list display 13.

FIG. 24 shows a flowchart for generating the list display 13 of FIG. In S1230, the database name is obtained from the source program 70 shown in FIG. It turns out that the database name is "district". next,
In S1231, the database name is changed to the title 13 of FIG.
Set to 03. Next, in S1232, five column names can be obtained from the source program 76 shown in FIG. Next, in S1233, the column names are set as the five column names 1304 in FIG. Next, S1234
Then, data is obtained from the database 200 of FIG. 6 under the condition specified on the condition input sub-screen 18 of FIG. Next, in S1235, the obtained data is displayed as a list display 13 in FIG.
Set to. Finally, in S1236, the list display 13 of FIG. 23 is displayed.

In the above-described embodiment, the name column is fixed and only one type can be designated. However, a list of a plurality of name columns can be designated, and one type of name column can be selected. May be.

Further, it is also possible to adopt a system in which a plurality of name columns can be designated as a list display and a plurality of types of name columns to be adopted can be selected.

FIG. 25 shows a screen form diagram (when an item is selected). When the code "01" is selected in FIG. 23 and the select button 1301 is selected, the list display 13 is erased from the display 3 and the screen form is as shown in FIG.
The code "01" is displayed in the input area 11 and the name display area 14a.
Is set to the district name "Tokyo" corresponding to the code "01", and the district name kana "Tokyo" corresponding to the code "01" is set in the name display area 14b.

FIG. 26 shows a flowchart for selecting items from FIGS. 23 to 25. First, the data selected in S1240 is obtained. Code "0" for FIG.
If the row that is "1" is selected, the first column is "0".
1 ”, 2nd column is“ Tokyo ”, 3rd column is“ Tokyo ”, 4th column is“ Main store ”, 5th column is“ Kanto ”
It can be seen that it is. Next, in S1241, the code correspondence information is specified. 7 of the source program shown in FIG.
It can be seen from 1 that the code correspondence information is in the first column. Next, in S1242, the content “01” of the first column is transferred to the input area 11 of FIG. Next, in S1243,
The name correspondence information is specified. From the source program 72 shown in FIG. 17, the name correspondence information is the second column and the third column.
You can see that it is a column. Next, in S1244, as shown in FIG.
The contents "Tokyo" of the second column and the contents "Tokyo" of the third column are transferred to the name display areas 14a and 14b of No. 5, respectively. Finally, in step S1245, the list display 13 of FIG. 23 is deleted from the display 3.

Example 5. In this embodiment, a data display device having no database access unit will be described. The screen form of this embodiment is the same as that of FIG. 2 shown in the above-mentioned embodiment. Also, in the data display device,
The screen display in the initial state during operation is as shown in FIG.
The screen display of the list display has the screen form shown in FIG.

The display change of the screen corresponding to the operation is the same as that of the above-mentioned embodiment. For example, in the state of FIG.
Use 06 to move the cursor to the position "02 Kanagawa" 9
02 is moved and the button on the mouse 906 is pressed,
"02 Kanagawa Prefecture" is selected, the code "02" is transferred to the input area 11, and the name "Kanagawa Prefecture" is displayed in the name display area 14
The list display 13 disappears from the display 903, and the screen form becomes as shown in the screen form diagram (when selecting an item) shown in FIG.

Next, the operation for determining the specifications of the box area will be described with reference to FIG. From the menu, select Create Box, Mouse 906 and Cursor 902
Is used to specify the position and size of the box displayed in the display 903, and to specify the code and name displayed in the list display 13 in the source program 7. The source program 7 has an attribute "CODE" and "MEIS".
The attribute "YO" is prepared. These attributes can be specified by an array. Numbers in parentheses are subscripts indicating relative positions in the array. The source program is written in a form that associates a character string with the array element of the attribute.

The operation of the data display device of this embodiment will be described below with reference to the flow charts shown in FIGS. 28 to 30. FIG. 28 is a flowchart (generation of list display) corresponding to the change in screen form from FIG. 3 to FIG. First, in S200, it is determined whether the button 12 for opening the list in FIG. 3 has been selected. If not selected, generation is not performed and the process ends. If selected, S201
Then, each code and name in the array designated by the source program 7 in FIG. 27 are linked and transferred to the list display 13 in FIG. Next, in S202, it is determined whether or not the transfer of all codes and names is completed. If not completed, the process of S201 is repeated again. When all the transcriptions have been completed, the list display 13 having all the codes and names designated by the array is displayed on the display 903 in S203.

FIG. 29 is a flowchart (selection of items) corresponding to the change in screen form from FIG. 4 to FIG. First, in S210, it is determined whether the list display 13 of FIG. 4 is selected. If not selected, the process ends. If selected, in S211, the number of the item selected from the position of the cursor 902 in FIG. 4 is calculated. Then S
The code selected in 212a is transferred to the input area 11 of FIG. Next, the name selected in S212b is transferred to the name display area 14 of FIG. Next, in step S213, the list display 13 of FIG. 4 is deleted from the display 903.

Further, with respect to the input area 11 in FIG.
The screen form when the input of the code "02" is completed by pressing the key "0" and the key "2" on the keyboard 905 is the same as in FIG. This will be described using a flowchart. FIG. 30 is a flowchart (code input) corresponding to the change in screen form shown in FIG. 5 when a code is input from the keyboard 905 in FIG. First, S22
In 0, the code table (correspondence between the code designated by the source program and the name shown in FIG. 27) is searched for the code entered in the input area 11. Next, if there is no matching code in S221, the processing ends in error. If there is a matching code, the corresponding name is transferred to the name display area 14 in FIG. 5 in S222.

As described above, according to this embodiment, the name is displayed on the name display section which is separated from the input area when the mouse is operated. Therefore, the screen form when the mouse is operated and the screen form when the keyboard is operated are shown. Are the same and the user can confirm the input contents.

Since only the code is set in the input area, the program creator does not have to create a program for extracting the code portion from the input area character string.

Incidentally, in the above-mentioned embodiment, as shown in the source program 7 of FIG.
Although the method of specifying for one attribute (CODE, MEISYO) is shown, as shown in FIG. 31, a special character (for example, tab character) is used as a delimiter between the code and the name, and 1
A method of designating the attribute of the type (List) may be used, and the same effect as that of the above-described embodiment is obtained.

As the first embodiment, the list display 13 shown in FIG. 2 is displayed on the display 903 or deleted by the button 12 for opening the list. However, the button 12 for opening the list is not provided. The list display 13 may be always displayed, and the same effect as that of the above-described embodiment can be obtained.

Further, this embodiment may be combined with the above-mentioned third embodiment. 22 of the flow chart shown in FIG. 30 using the data input to the input area 9 corresponding to the subject shown in FIG. 12 using the screen form diagram shown in FIG.
Perform a search similar to the processing of 0, and ensure that the entered code satisfies the condition by giving an error when the code "02" that is not "store name" is entered. You can

The method of displaying the list display in another screen in the above-described embodiment may be combined with this embodiment.

Further, a method in which a plurality of name columns in the above-described embodiment can be designated as a list display and one kind of name column to be adopted can be selected may be combined with this embodiment.
Further, it may be a method in which a plurality of types of name columns to be adopted can be selected.

Next, the case where the same function is realized using this data display device and the case where it is not used will be compared with reference to the drawings. FIG. 32 is a diagram showing a source program when the data display device of the present invention is not used. In addition, FIG.
FIG. 9 is a diagram showing a source program when the data display device of the present invention is used. Comparing FIG. 32 and FIG. 33, it is 23 lines when not used, but 7 lines when used, and the same function is realized by a source program of 1/3 or less. As described above, according to the data display device of the present invention, development and modification can be efficiently performed.

[0100]

According to the data display device of the present invention, since the database access unit and the box generation unit are provided, the non-program database is utilized for data display and a long program or a complicated program is not created. The list can be easily displayed. Further, it is possible to obtain a data display device that reduces the load of creating and changing the specifications of the box.

Further, according to the data display device of the present invention, since the length determining unit calculates the length of the character to be displayed in the box from the number of digits in the database and automatically sets it, the program creator can display the box display screen. There is no need to adjust the size above to the required size.

When displaying a large number of lists, the list display is displayed as a separate screen, and the number of list displays that the operator can see at one time is increased to find the item selected by the operator. The time can be shortened.

Further, according to the present invention, there is an effect that the label can be easily created and changed in a short time.

Further, according to the present invention, since the accessed data is selected according to the condition to reduce the number of cases, it is possible to shorten the time for the operator to find the target item.

Further, according to the present invention, it is possible to easily create or change the list display box.

Further, it is possible to obtain a data display device in which the operator is not confused or erroneously operated.

According to the data display device of the present invention, the user can confirm the input contents by name.

Further, according to the present invention, Windows
This has the effect of facilitating the development and modification of the application that runs on top.

Further, according to the present invention, the Visual
This has the effect of facilitating application development and modification using Basic.

[Brief description of drawings]

FIG. 1 is a block diagram showing the configuration of a data display device according to the present invention.

FIG. 2 is a screen form diagram according to the data display device of the present invention.

FIG. 3 is a screen form diagram in an initial state at the time of executing the program of the present invention.

FIG. 4 is a screen form diagram when displaying a list according to the present invention.

FIG. 5 is a screen form diagram when an item is selected according to the present invention.

FIG. 6 is a database configuration diagram for holding codes and names according to the present invention.

FIG. 7 is a diagram showing a definition of box specifications when the database of the present invention is used.

FIG. 8 is a flow chart for generating a list display when using the database of this invention.

FIG. 9 is a screen form diagram including additional information of the present invention.

FIG. 10 is a diagram showing a source program for displaying additional information according to the present invention.

FIG. 11 is a screen form diagram including additional information according to the present invention.

FIG. 12 is a screen form diagram when there is a list display condition of the present invention.

FIG. 13 is a diagram showing a source program for designating display conditions of the present invention.

FIG. 14 is a flow chart for generating a list when the display condition of the present invention is specified.

FIG. 15 is a screen form diagram in an initial state when the program of the present invention is executed.

FIG. 16 is a flowchart for calculating the length of the input area according to the present invention.

FIG. 17 is a diagram showing a source program of the present invention.

FIG. 18 is a flow chart diagram for generating a component label of the present invention.

FIG. 19 is a flow chart diagram for generating an input area label according to the present invention.

FIG. 20 is a flow chart diagram for generating a name display area label according to the present invention.

FIG. 21 is a screen form diagram for specifying conditions according to the present invention.

FIG. 22 is a flow chart diagram for generating the condition input sub-screen of the present invention.

FIG. 23 is a screen form diagram of a list display of the present invention.

FIG. 24 is a flow chart for generating a list display according to the present invention.

FIG. 25 is a screen form diagram when an item is selected according to the present invention.

FIG. 26 is a flow chart for performing item selection according to the present invention.

FIG. 27 is a diagram showing a definition of a box specification according to an embodiment of the present invention.

FIG. 28 is a flow chart for generating a list display according to the present invention.

FIG. 29 is a flow chart for selecting an item of the present invention.

FIG. 30 is a flow chart of the code input according to the present invention.

FIG. 31 is a diagram showing a source program using a delimiter between a code and a name according to the present invention.

FIG. 32 is a diagram showing a source program when the data display device of the present invention is not used.

FIG. 33 is a diagram showing a source program when the data display device of the present invention is used.

FIG. 34 is a diagram showing conventional program components.

FIG. 35 is a diagram showing an initial state of a conventional program component.

FIG. 36 is a view showing a state in which a conventional program component item is selected.

FIG. 37 is a view showing program creation by a conventional program component.

FIG. 38 is a flowchart of generation of a list display in a conventional program component.

FIG. 39 is a flowchart for selecting an item in a conventional program component.

FIG. 40 is a diagram showing code input from a keyboard of a conventional program component.

[Explanation of symbols]

110 display, 112 input display box area, 11
4 box area for list display, 130 box generator,
132 length determination unit, 134 number determination unit, 136 item name use unit, 138 selection unit, 150 database access unit, 200 database.

Claims (10)

[Claims] 1. A data display device, which is predetermined to display data in a predetermined standard format box, having the following elements: (a) A display unit for displaying data. , (B) a database storing data to be displayed on the display unit, (c) a database access unit for accessing the database,
(D) A box generation unit that displays the data accessed by the database access unit in the form of a box on the display unit and determines the specifications of the box based on the information accessed by the database access unit. 2. The data generating apparatus according to claim 1, wherein the box generating unit includes a length determining unit that determines a length of a character displayed in the box according to a length of data to be displayed. Display device. 3. The data display device according to claim 1, wherein the box generation unit includes a number determination unit that determines the number of data items to be displayed in the box according to the number of data items to be displayed. 4. The box generation unit includes an item name use unit that uses an item name used by a database as a label used for a box.
The data display device described. 5. The data display device according to claim 1, wherein the box generation unit includes a selection unit that selects data accessed by the database access unit from the database according to conditions. 6. The data display device according to claim 1, wherein the box is a list display box area for displaying a list of a plurality of data. 7. The data display device according to claim 1, 2 or 4, wherein the box is an input display box area for inputting and displaying one data. 8. A data display device, which is predetermined to display data in a predetermined standard format box, having the following elements: (a) a display unit for displaying data. , (B) first display means for displaying an input display box area for inputting and displaying data on the display unit, (c) a candidate list of data input for display in the input display box area, Second display means for displaying a list display box area for displaying the code and name as a pair on the display section, and (d) for inputting the list display in the input display box area displayed by the first display means First data input means for inputting the code displayed in the box area and displaying the input code and the name corresponding to the code, (e) the above list by the second display means It displayed in use box region to select one of the codes and names, a second data input means for the selected code and the name displayed in the box area for the input display. 9. The data display device according to claim 1, wherein the box is applied to an application running on Windows (trademark of Microsoft Corporation in the United States). 10. The box is a Visual Ba
sic (US Microsoft Corporation
8. The data display device according to claim 1, wherein the data display device is applied to an application developed by using a trademark of "on".