JP2531079B2 - Table chain update method - Google Patents

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a table format update used for tabulation and tabulation, and more particularly to a table chain update method for automatically retrieving and updating a table having the same item sequence.

[0002]

Conventionally, the search for presentation or database, Rukoto to represent data in tabular form or graph, is being performed. In addition, recently, tables are often used in the process of tabulating data in accounting or statistics. The table format is a versatile data representation format in information processing for presenting or tabulating various data.

In the method of generating a table used for the above-mentioned purpose, each row item and column item are individually defined, and the shape and size of the table are defined by the line segment and the coordinates of the start point and the end point thereof. , Or a table is stored in a bitmap as image data.

However, in addition to the method of generating a table, the entire table format is prepared for partial changes in the table including additions and deletions of items in the table or changes in item names, and the same items are provided. There is a processing request to find a table and make the same change to all tables. This processing request is simply a change of items in rows or columns, but is a request that often occurs in tables used for tabulation or tabulation.

On the other hand, instead of the above simple table format change,
Changes to some rows or columns or partitions of the tabular format may cascade through the entire table. A method for shaping a table derived and expanded in a chained manner is disclosed in JP-A-2-72.
There is a Japanese Patent No. 471, "Table processing-method". The solution to this is to register the constraint conditions regarding the position and size for each partition of the table to fit in the table format, and when there is a change in the partition, the constraint conditions are satisfied for all partitions. As described above, the shaping process of a chained section is automatically performed for each hierarchical section.

[0006]

The above-described conventional table processing method is one method for shaping the change in another section that affects the entire table by shaping the one section in the table. On the other hand, there is a change process for making the same change to the item strings of all the tables having the same item string. This occurs when an item is inserted, deleted, or renamed when the data is expressed in a tabular format. Then, all the tables having the same item sequence are extracted and the same change processing is performed .

[0007]

SUMMARY OF THE INVENTION It is an object of the present invention to provide a method capable of making changes to an item string of a table to all tables having the same item string.

According to the chain update method of the table of the present invention, data is entered in each of the sections formed by the row-wise item sequence and the column-wise item sequence, and the table name is used in the table used for tabulation and tabulation. To indicate the change of the item's column
Change instruction procedure, table specified by name and the table
The shape of the item is acquired from the table master, and the item sequence change and table
Change processing procedure to change the shape of
Has the same item string for the table management master to be stored
Item check procedure to retrieve and acquire the table name, and
Obtain the name table from the table master and change the item sequence
For the update processing procedure for making changes and the table management master,
Determines whether the search for a table with the same item string has been completed
And the procedure to do so.

[0009]

Embodiments of the present invention will now be described with reference to the drawings.

[0010] In flow diagram showing the procedure of an embodiment of the present invention
Referring now to FIG. 1, this embodiment illustrates a visible
Table to be updated that displays visible on the display screen of the reduction display device
Using the command dedicated to table processing, based on the change instruction procedure 1 for instructing the table name and the item column of the row or column, the addition or addition of the item name change, and the instruction of the change item,
The change processing procedure 2 for changing the table data stored in the table master 3 and the table management master 5 that manages the table name and the item columns that make up the rows or columns of the table are searched for and the item string to be changed is set. an item Ji E click Step 4 to obtain the table name with the same field strings, based on Table name is acquired,
Update processing procedure 6 that acquires the table data to be changed from the table master 3 and updates the item string of the table data, and the table management master 5
Step 7 of determining whether or not the search is completed .

2 (a), 2 (b), 2 (c), 2 (d), which illustrate application of this embodiment .
And FIG. 3 (a), FIG. 3 (b), FIG. 3 (c), FIG.
Referring to (d) , the procedure will be described. In A table 21 , B table 22 , C table 23 and D table 24 having item strings having mutual relations with each other, in A table 21 , the A table 21 is the item string XY in the column direction.
Z and row direction item sequence abc d , B table 22 is column direction item sequence αβγ and row direction item sequence XYZ, and C table 23 is column direction item sequence αβγ and row direction item sequence 1, 2.
3, 4 and D table 24 has item columns XYZ in the column direction and item columns 1, 2, 3, 4 in the row direction. These table names and item strings are registered in the table management master 5. The table name and its shape are registered in the table master 3 .
The operator inputs the table name to be changed is displayed visualization visualization display a table to be changed on the visual display screen. Then, the change contents of the item sequence are input to the table by a command. In A Table 21 illustrated that FIG. 2 (a), will enter an instruction to change an item column XYZ item column XYyZ (Step 1 in FIG. 1). Based on the change instruction,
The shape of the A table 21 is updated on the screen, and the updated table data is stored in the table master 3 (procedure 2). The table management master 5 is searched based on the item sequence XYZ of the change instruction. It is out of not look at the B table 22 having a field string XYZ (step 4). Then, the item sequence XYZ of the B table 22 is changed to the item sequence XYy.
Change to Z, to change the shape of the B Table 22, Table Table Master 3
Data is stored (step 6). The table management master 5 detects that the data in the B table 22 is not the end, and returns to the item check procedure 4 for searching the table management master 5 (procedure 7). Next, in the search for the table management master 5, D table 2
4 to leave not look at the (step 4). Item row XY for D table 24
Z is changed to the item string XYyZ, the shape of the D table 24 is changed, and the table data is stored in the table master 3 (step 6). Then, it is checked whether or not there is a table to be changed, and the process ends (procedure 7).

Referring to FIGS. 2 (a), (b), (c) and (d) exemplifying the change of the item sequence with respect to the above item sequence, one row is added to the row item sequence XYZ of A table 21. And XYy
Let Z. In B table 22, C table 23 and D table 24 related to A table 21, B table 2 having a column item sequence of XYZ
One column of y is added between Y and Z of 2. Also, D table 2
Y is added between the four YZ items. On the other hand, the C table 23 that does not have the XYZ item sequence is not updated. The A table 31, the B table 32, and the D table 34 having the above-mentioned updated item sequence and the C table 33 which is not updated are shown in FIG.
Shown in (a), (b), (c) and (d). That is,
The table A is changed to the row item column XYyZ, the B table 32 is changed to the column item XYyZ, and the D table 34 is changed to the row item column XYyZ. Furthermore, the following modifications can be made to the above embodiment.

When the above-mentioned item string is a series of item numbers, the table item registered in the table management master 5 is a process for re- numbering the item numbers from the row or column at the changed position of the item string to the sequence number. This can be performed on the column by the change processing procedure 2 and the update processing procedure 6.

[0014]

As described above, according to the present invention, when the item column of the row or column for one table is changed, the same change can be automatically made to the related tables having the same item column. . When there are a large number of related tables, the processing effect can be improved by changing the item sequence that spreads between the tables. In particular, the effect is remarkable in the inter-table calculation in which a plurality of tables are combined in a series of processes for calculation.

[Brief description of drawings]

FIG. 1 is a diagram showing a procedure flow of an embodiment of the present invention.

FIG. 2 is a diagram exemplifying a table to be changed in this embodiment.

FIG. 3 illustrates a table after implementation of changes in this example.
It is a figure .

Claims (2)

(57) [Claims] 1. The data is entered in each of the sections formed by the row-wise item row and the column-wise item row, and in the table used for tabulation and tabulation, the name of the table is designated and the item is specified. Changes that direct column changes
Whether the instruction procedure, the table specified by name and the shape of the table are the table master
Change process to obtain the above items and change the shape of the table
For the table management master that stores the table name and item sequence
Search the name of the table that has one item string and
Check procedure and the table of the name is obtained from the table master, and the table of the
An update processing procedure for changing the item string and a table having the same item string for the table management master are detected.
And a procedure for determining whether or not the search has been completed . 2. The change processing procedure and the update processing procedure
Forward the claim 1 any one of the items column in the row direction of the item column or row direction of the field string be a sequence number, characterized in that renumber the sequence numbers in order from changing points of the item column Chain update method of the described table.