JPS6316373A - Dynamic table type picture display system - Google Patents

Abstract

PURPOSE:To freely obtain a desired display style by changing interactively and dynamically the table style displayed on a display of a terminal equipment through this terminal equipment. CONSTITUTION:When the display position designating information is inputted from a terminal equipment 3, a picture frame generating means 11 produces the information on a picture frame equivalent to a single picture to be displayed on a display device from the display position designating information and the table information stored in a table information storing means. A picture object production means 12 produces the screen object equivalent to a single screen displayed on the display of the equipment 3 from the information displayed in each table out of the table information stored in the table information storing means as well as said information on the picture frame. A picture input/output means 14 inputs said picture object to display the picture of the contents corresponding to the picture object on the display of the equipment 3 and also inputs a reception image received from the equipment 3 after a replacement operation like deletion, etc. is applied to the displayed picture.

Description

[Detailed Description of the Invention] [Industrial Application Field] The invention relates to a tabular screen display method, and in particular, to a tabular screen display method, in which a database on a host computer is interactively accessed in a tabular format from the display of a terminal device. This invention relates to a dynamic tabular display method that can dynamically change the tabular format displayed on the screen.

(Prior Art) When a database on a host computer is accessed from a terminal device, the contents of the database are displayed in a table format on the display of the terminal device.

Conventional tabular screen display methods in such systems include information such as the frame of the table for each screen, the setting of fields that can be entered, 2 the position of the table on the screen, 2 the number of tables, 9 the number of screens to be displayed, etc. in a database. Generally, the screen image itself is stored in a fixed format in a file, etc., and there is no means for interactively changing the format of the table displayed from the terminal device.

[Problem that the invention seeks to solve]

However, terminal users may wish to change the table format according to their own preferences, for example, and having the displayed table format fixed is inconvenient in various ways.

The present invention has been made in view of these circumstances, and its purpose is to provide a dynamic table that allows the terminal device to interactively and dynamically change the table format displayed on the display of the terminal device. The purpose is to provide a format display method.

[Means for solving problems]

In order to achieve the above object, the present invention provides information regarding the entire table to be displayed on the display of a terminal device.

table information storage means for storing table information including information defining the framework of each table and information on data to be displayed in each table; and display position designation information from the terminal device and stored in the table information storage means. screen frame generation means for generating screen frame information for one screen to be displayed on the terminal device from the display data information in the table information generated by the screen frame generation means; screen object generation means for generating one screen worth of screen objects to be displayed on the display of the terminal device from the table information stored in the table information storage means; A screen object is input, a screen with contents corresponding to the screen object is displayed on the display of the terminal device, and a received image transmitted from the terminal device after an operation is performed on the displayed screen is displayed. Based on the input screen input/output means, the cursor position information in the received image input to the screen input/output means, and the screen frame information generated by the screen frame generation means, the topsoil where the cursor is positioned is determined. cursor position detection means for detecting the position; and storing the table information based on the topsoil position of the cursor detected by the cursor position detection means and a screen change command in the received image input to the screen input/output means. and table information updating means for updating table information of the means.

[Effect]

When display position designation information is input from a terminal device, the screen frame generation means selects one frame to be displayed on the terminal device based on this display position designation information and the table information stored in the table information storage means.
The screen object generation means generates screen frame information for the screen, and the screen object generation means combines the generated screen frame information and the information of the data to be displayed in each table of the table information stored in the table information storage means. From this, 100 screen objects to be displayed on the display of the terminal device are generated. The screen input/output means receives the generated screen object for one screen as input, displays a screen with contents corresponding to this screen object on the display of the terminal device, and also performs operations such as deletion on the displayed screen. Input the received image sent from the terminal device after the change operation has been performed. Then, from the cursor position information in the received image and the information on the construction surface frame generated by the screen frame generation means, the cursor position detection means detects the topsoil position 1 where the cursor was positioned at the time of the update request, and The information update means, based on the detected topsoil position of the cursor and the screen change command in the received image input to the screen input/output means,
Update table information in table information storage means.

〔Example〕

Next, embodiments of the present invention will be described with reference to the drawings.

FIG. 1 is a block diagram of an embodiment of the present invention, in which 1 is a host computer, 2 is a communication control device, 3 is a terminal device having a display 3a and a keyboard 3b, 4 is a communication line, and the terminal device 3 is a communication control device. Interactive processing with the host computer 1 is possible via the line 4 and the communication control device 2. .

The host computer 1 includes, for example, a table information storage file 10 provided in a magnetic disk device, a screen frame generation means 11, a screen object generation means 12, a cursor position detection means 13, and a screen input/output means 14. , table information updating means 15 are included.

The table information storage file 10 includes table information 1 necessary for displaying a tabular screen on the display 3a of the terminal device 3.
0a, and the table information is composed of information A regarding the entire table, information B defining the framework of each table, and information C regarding the data to be displayed in each table.

Figure 2 shows an example of the content of facial expression i10a, ta+ in the same figure shows the content of information A regarding the entire table, mountain) in the same figure shows information B that defines the framework of each table, and figure C1 shows the content of information A for each table. The information Hc of the data displayed inside each is shown.

As shown in the same figure (al), information A includes the total number n of tables displayed on the terminal device 3, the identification numbers F1 to Fn of each table,
The display order of each table, the number of rows in each table, distance information between each table, and whether each table is actually displayed on the display 3a of the terminal device 3 or not displayed (display like this) Temporary deletion information is included for each table, which instructs the user to temporarily delete the information (to make it impossible to do so).
)), information C includes the number of columns in each table, the column width of each column in each table, and temporary deletion information that indicates whether temporary deletion is to be performed for each column. As shown in tc+, each table includes data to be displayed in each field uniquely determined by the row and column of each table.

The table information storage file 10 does not store the screen image itself of the table to be displayed, but the information necessary to generate the screen image is stored, so the table information 1
It is possible to virtually develop an image of the entire screen based on 0a.

FIG. 3 shows a portion of the image of the entire screen virtually developed in this way. The display order of Tables 30, 31, and 32 on the entire virtually expanded screen, the number of rows in each table (9), and the distance between the tables are known from information A regarding the entire table shown in Figure 2+al, and each table 30 to 32 The number of columns (2) and the width of each table are determined from the information B that defines the framework of each table shown in Figure 2 (bl).
The data set in each field of ~32 is shown in Figure 2 (C1
This can be determined from the information C of the data displayed in each table. The present invention displays such a virtually developed screen image below,
The screen frame and each field data to be displayed on the terminal device are obtained. In addition, in the virtual deployment, information A
Temporary deletion information for each table in the table indicates that temporary deletion is present, and temporary deletion information for each column of each table in information B is generated by excluding columns indicating that temporary deletion exists. Hereinafter, the operation of this embodiment will be explained with reference to the drawings. In FIG. When there is a request for access in table format, the screen frame generation means 11 of the host computer 1 is activated. Note that various designation methods can be adopted as the display position designation information, such as designating the table number from the top of the table to be displayed, column number 1 from the left, and the row number in the table.

When the screen frame generation means 11 is activated, it starts the process shown in FIG. A row of the table to be displayed is selected based on the number, and a vertical screen frame is generated (process 40).

Next, information B that defines the frame of each table to be displayed obtained by vertical screen frame generation is input from the table information storage file 10, and the specified horizontal display position and number of characters that can be displayed on one screen are A column to be displayed is selected from , and a horizontal screen frame is generated (processing 41).

This horizontal screen frame is created for all the tables to be displayed that were obtained during the vertical screen frame generation. With this, 1
Generation of the screen frame for the screen is completed.

To explain the generation of the above screen frame using FIG. 3, for example, as the display position designation information, the vertical display position a is the upper end of the table 30 in FIG. 3, and the horizontal display position is Assuming that this is the leftmost part of Table 30, and the vertically displayable range of one screen is the range shown by the box in Figure 3, and the horizontally displayable range of 100 screens is the range shown by D in Figure 3. , the vertical screen frame is a frame that extracts all the row lines in Tables 30 and 31,
The horizontal screen frame is a frame in which all the column lines in Table 30.31 are extracted.

Note that if display positions a and b specify row 9 and column 9 in the middle of the table, the display will start from the middle of the table.

Now, after the screen frame generation means 11 has finished generating a screen frame for one screen, it gives information about the generated screen frame to the screen object generation means 12 and starts it (process 42).

In response to this, the screen object generation means 12 starts the process shown in FIG. The data to be processed is read from the table information storage file 10 and a screen object for one screen is generated (processing 50). Then, this screen object for one screen is given to the screen input/output means 14 to start it (process 51
).

The screen input/output means 14 includes the screen object generation means 12
When a screen object is input from , the process shown in FIG. 6 is started, and as is well known, information necessary for displaying a screen with contents corresponding to the screen object on the display 3a of the terminal device 3 is communicated. The control device 21 sends the data to the terminal device 3 via the communication line 4, and displays the screen on the display 3.
a (processing 60).

After this, the terminal device 3 becomes ready for keystrokes, and the terminal device N
When the operator 3 looks at the table format displayed on the display 3a and wants to make changes, he inputs a pre-prepared command such as deletion, expansion, or addition of a table, and also inputs a pre-prepared command such as deletion, extension, or addition of a table. All you need to do is to position the cursor at the position of column 1, row 1 of the table and press the send key.By pressing the send key, a received image containing the image of the pressed command and the address of the cursor on the screen is transmitted from the terminal device 3. The line 49 is applied to the screen input/output means 14 of the host computer 1 via the communication control device 2.

The screen input/output means 14 determines whether the command received in response is a command related to changing the table format or not (61.62), and changes the address of the cursor on the screen with the change command. In addition to notifying the cursor position detection means 13, the received command is transmitted to the table information updating means 1.
5 (processing 63.64).

When the cursor position detecting means 13 is notified of the address of the cursor on the screen from the screen input/output means 14, the cursor position detecting means 13 calculates the position of the cursor from the address and the screen frame read from the screen frame generating means 11.
The topsoil field where the cursor was located is detected and this is notified to the table information updating means 15.

Further, the table information updating means 15 receives the command notified from the screen input/output means 14, the field information of the topsoil of the cursor notified from the cursor position detection means 13, and the screen frame generated by the screen frame generation means 11. When inputting information, the starting point for changes is the 1st row and 1st column of the table, which is determined from the topsoil field information of the cursor, and deletion, expansion, additional display, and temporary deletion of the 5th row and 9th column of the table are performed only for the part specified by the command. Table information storage file 1 by referring to the screen frame so that
Update table information in 0.

When the update of the table information 10a by the table information update means 15 is completed, the screen frame generation means 119, the screen object generation means 121, and the screen input/output means 14 are activated again, and the table format based on the changed table information is transferred to the terminal device 3. It will be displayed. Therefore, by repeating a series of changing operations on the terminal device 3 side, it becomes possible to freely change the screen image.

Figure 7 shows expansion, copying, and temporary deletion in the deletion table 9.

It shows the correspondence between the content of the command and the position of the cursor that should be input from the terminal device 3 when expanding a table unit, and the content of the change to be executed in that case. FIG. 8 is a diagram for explaining the name of the position where the cursor is placed during a change operation, and in the tree specification, the top row and leftmost column of the table indicated by reference numeral 81 is called the "table name area". Each column of the top row other than the table name area indicated by numeral 82 is referred to as a "column name area", and is indicated by numeral 83.
The leftmost column other than the table name area shown by is called the ``row operation area.''

Furthermore, FIG. 9 is a flowchart of a processing example of the table information updating means 15 that performs the processing corresponding to FIG.
3, the type of command is determined, and processes 94 to 9
In step 9, the position of the cursor is determined, and in steps 100 to 110, the corresponding table information is updated.

The details of each change operation will be explained below.

[Deletion operation] ■Deletion operation at the back position If you want to delete n number of subsequent tables starting from a certain table, place cursor K in the table name area of that table and use the command rDEL.
Enter nJ. In this case, the table information updating means 15
The total number of tables 2 in the table information 10a, the display order, etc. are updated, and the content corresponding to the deleted table is deleted from the information B that defines the framework of each table and the information C of the data displayed in each table ( Processing 101).

■ Column-by-column deletion operation If you want to delete n columns to the right of a certain column in a table as a starting point, place cursor K in the column name area of the starting column.
Enter the command rDEL nJ. At this time, the table information updating means 15 changes the number of columns of the table to be deleted in the information B that defines the framework, and deletes the corresponding column width information and information C of the data to be displayed in each table (processing 100).

■ Deletion operation of row order If you want to delete n rows below a certain row in a table as a starting point, place the cursor K in the row operation area of that row and input the command rDEL nJ. At this time, the table information updating means 15 changes the number of rows to be deleted in the information A of the entire table,
The display data corresponding to the deleted row in the information C of the data displayed in each table is deleted (processing 102).

[Extension operation in a table] Expansion operation for 0 columns To add n columns to a table, place the cursor Kt in the table name area of the table and input the command rEXP nJ. In this case, the table information updating means 15 changes the number of columns in the expanded table in information B, sets the column width to, for example, a standard value, and leaves the field of the expanded column blank (processing 104).

■ Column Width Expansion Operation To expand a certain column of a table by n digits, place cursor K in the column name area of that column and enter the command rEXPn. At this time, the table information updating means 15 updates the corresponding column width information in Information@B (process 103).

Expansion operation with 0 rows When adding n rows to a table starting from a certain row,
Place cursor K in the line operation area of that line and execute command rEX
Enter P nJ. At this time table.

The information updating means 15 changes the number of rows in the corresponding table in the information iA, and leaves the content of the added field in the information C blank (processing 105).

[Copying Operation] When copying n rows of a certain table and displaying them after that row, place the cursor K in the row operation area of the row to be copied and input the command rcOPY nJ.

In this case, the table information updating means 15 changes the number of rows of the corresponding table in the information tiA, and stores the copy source data as the contents of the copy destination field in the information C (process 110).

[Temporary erasing operation ■Temporary erasing operation on the back side Starting from a certain table, the next n tables will be made invisible by one screen,
If you want to leave the original information in the table information 10a, place the cursor K in the table name area of the table and use the command rVDEL n
Enter J. At this time, the table information updating means 15 changes the temporary deletion information regarding the specified table in the information A to "deleted" (process 106).

■ Column-by-column deletion operation Starting from a certain column in a table, I want to make n columns invisible on the screen.
If you want to leave the original information in the table information 10a, place the cursor K in the column name area of that column and use the command rVDEL n
Enter J. At this time, the table information updating means 15 updates the information fH.
The temporary deletion information of the designated column in B is changed to "Yes" (processing 107).

[Extension operation of the front wheel position] ■ Forward table extension operation When adding 9 tables of 9 tables in front of a certain table, place the cursor K in the table name area of the table and input the command rTADD nJ. In this case, the table information updating means 15 changes the total number of tables in information A (1), the display (1), and the order (1), and sets, for example, a prescribed value for the number of rows, 5 columns, and 9 column widths of the table for the added table. , each field in the table is left blank (processing 108).

■Extending a table backwards If you want to add 9 tables after a certain table, place the cursor K in the row area of the table and use the command ``TADD nJ''.
Enter. The operation of the table information updating means 15 at this time is the same as in the above (1) (process 109).

FIG. 10 shows changes in the screen on the display 3a, taking as an example the deletion operation in columns among the above various operations, and 61 shows the screen before deletion, and 62 shows the screen after deletion. . Type the command rDELJ, which means deletion, in the command field set at the top of the screen, etc.
In this case, to delete only two columns, press "2" as a parameter after DEL. Also, position the cursor at the column name castle of the mouth column. If you press the send key in this state, the above-mentioned process will be performed, and the screen 62 will be displayed based on the table information 1Oa after the change, starting from the mouth row.
A table is displayed in which the original column and column have been deleted.

〔Effect of the invention〕

As explained above, the present invention does not store the tabular format displayed on the display of a terminal device and the data therein as a screen image, but instead stores information about the entire table such as the number of tables to be displayed, the display order, etc. It is stored in the format of information that specifies the layout of each table, such as the number of columns in the table (9 column width), and information about the data to be displayed in each table, such as what kind of data is displayed in each field of each table. , a screen object including information on a screen frame for one screen and information on data to be displayed therein is generated and displayed on the terminal device only when display position designation information is input from the terminal device; In addition, the cursor was positioned at the time of the update request based on the cursor position information in the received image after an operation such as deletion was performed on the screen displayed on the terminal device's display and the information on the screen frame of the display. A cursor position detection means that detects the position on the table, and a table that updates the table information of the table information storage means based on the detected position of the cursor on the table and the screen change command in the input received image. Since an information update means is provided, the table format can be dynamically changed interactively by simply modifying the table information in response to simple operations such as command input and cursor indication from the terminal device. be.

[Brief explanation of the drawing]

FIG. 1 is a block diagram of an embodiment of the present invention, FIG. 2 is a diagram showing an example of the configuration of the table information 10a, FIG. 3 is a diagram showing a part of the image of the entire virtually expanded screen, and FIG. 5 is a flowchart of an example of processing by the screen frame generation means 11, FIG. 5 is a flowchart of an example of processing by the screen object generation means 12, FIG. 6 is a flowchart of an example of processing by the screen input/output means 14, and FIG. 7 is a flowchart of an example of processing by the screen object generation means 14. 8 is an explanatory diagram of the name of the position in the table where the cursor is placed during the change operation; FIG. 9 is a flowchart of a processing example of the table information updating means 15; FIG. 10 is a diagram showing an example of the screen contents before and after the change when a column-by-column deletion operation is performed. In the figure, 1... host computer, 2... communication control device, 3... terminal device, 4... communication line, 1
0... Table information storage file, 11... Screen frame generation means, 12... Screen object generation means, 13...
Cursor position detection means, 14... Screen input/output means, 1
5... Table information update means, A... Information regarding the entire table, B... Information defining the framework of each table, C... Information on data to be displayed in each table.

Claims (1)

[Scope of Claims] Table information storage means for storing table information including information regarding the entire table to be displayed on a display of a terminal device, information defining the framework of each table, and information on data to be displayed in each table. , screen frame generation means for generating screen frame information for one screen to be displayed on the terminal device from display position designation information from the terminal device and table information stored in the table information storage means; and the screen A screen object that generates a screen object for one screen to be displayed on the display of the terminal device from screen frame information generated by the frame generation means and display data information in the table information stored in the table information storage means. generating means; and inputting a screen object for one screen generated by the screen object generating means, displaying a screen with contents corresponding to the screen object on the display of the terminal device, and displaying information on the displayed screen. screen input/output means for inputting a received image transmitted from the terminal device after an operation is performed on the screen; cursor position information in the received image inputted to the screen input/output means; and generated by the screen frame generation means. cursor position detection means for detecting the position on the table where the cursor is positioned from the information of the screen frame that has been displayed; 1. A dynamic tabular screen display method, comprising table information updating means for updating table information in said table information storage means based on a screen change command in an inputted received image.