JPH03141470A - Table processor - Google Patents

Abstract

PURPOSE:To change the output form of data into an easy-to-see form and to perform the output of data by fixing the items serving as the data arrangement conditions including the sort, etc., at a specific position of a record via a means which automatically changes the arrangement of items within the record. CONSTITUTION:A control means 2-4 outputs the data arranged under the data arrangement conditions received from an input means 2-3 to an output means 2-1 in a table form. In this case, the means 2-4 changes the arrangement order of items in a line and fixes the items to which the data arrangement conditions are set at a specific position of the line. Thus it is possible to instantaneously obtain the easy-to-see output result in response to the change of the data arrangement conditions. In addition, it is not required to develop such a program that outputs data with mapping to an output format produced separately.

Description

DETAILED DESCRIPTION OF THE INVENTION [Field of Industrial Application] The present invention relates to a table processing device for processing accumulated data.

[Conventional technology]

When outputting stored data to an output device, the output format of the data is generally to output the data as stored unless an output format is provided from outside.

For example, the items of one data item are arranged in the order in which the database file was defined. There are two possible ways to rearrange the items of one data item:

(1) Change the order of the stored data itself by changing the definition of the database file.

(2) Create a separate format document to output and map to it.

[Problem to be solved by the invention]

According to the prior art, (1) It is necessary to change the definition of the database file each time the output format changes, which makes operations cumbersome.

■It is necessary to separately create a format document to be output and develop a program for mapping to it, resulting in a large-scale system.

There are problems like this.

SUMMARY OF THE INVENTION An object of the present invention is to provide a table processing device that changes the output format of data into an easily viewable format without performing any special external operations.

[Means to solve the problem]

The above purpose is achieved by using items for which conditions for organizing data are set when organizing data.

[Effect]

The means for automatically changing the order of items in a record is solved by fixing the items at specific positions in the record, which is a data organization condition such as sorting.

〔Example〕

An example in which the present invention is implemented on a Japanese word processor will be described below with reference to the drawings.

In this embodiment, the item that is the condition for data organization is fixed at the top position of the record, but the fixed position has no bearing on the original idea of the present invention. Furthermore, since the data organization itself is not directly related to the invention, only the method for creating data to be output from the organized results will be described.

When outputting organized data, the data in a record may be output in the same order as it is, but the specification method and output method will be omitted.

FIG. 1 is an example of displaying the results of processing a table with different sorting conditions. As shown in 1-1, one piece of data is originally stored in the order of "branch name,""productname,""salesamount," and "person in charge." For example, the result of executing with "Product Name" as the sorting condition is "Product Name", "
Branch name".

``Sales'' and ``Person in charge'' are sorted, and when executed with ``Person in charge'' as the sorting condition, the result is ``Person in charge'', ``Branch name'', ``Product name'', ``Sales'' as shown in 1-3. ``High''. In this embodiment, a case will be described in which results 1-3 are obtained using the product name as a sorting condition.

FIG. 2 is a block diagram of the hardware configuration of a keyboard-type Japanese word processor to which the present invention is applied. 2
-1 is a display device for displaying data arrangement results, etc., 2-2
is data, character font.

A memory bag for storing programs, etc. [, 2-3 is an input device,
2-4 is a control device that controls each of the devices 2-1 to 2-3.

3, 4, and 5 are tables used in this embodiment, and exist in the storage device 2-2. 3-1 is an item management table for managing record items. 3-
1-1 is the item name "branch name".

This is information such as "product name". 3-1-2 is the number of characters that can be input into that item. 3-2 is the number of items that make up the code. The above 3-1.3-2 is created at the time of database definition.

FIG. 4 shows the internal structure of the database in which input data is stored. Data is stored in order for each code, and the data within a code is arranged in the order of the items that define the database. In this case, "branch name"
,"product name".

The items are stored in the order of "Sales amount" and "Person in charge".

FIG. 5 shows the interface area with the data reduction program. 5-1 is a table in which record numbers to be displayed are stored in the order in which they are displayed. For example, when sorting is performed, the sorted record sequence is stored. In this case, this is the result of executing with the product name as the sorting condition.

5-2 is a code (E
OR: End Of Record) is stored.

5-3 stores the item names that are the conditions for data organization, and stores the [product name] that is the sorting condition.

FIGS. 6 and 7 are flowcharts for realizing one embodiment.

FIG. 6 shows the main program. Block 6-1 determines whether there is data to be output.

If there is no data, the process ends. Block 6-2 initializes pointer P1 for referring to table 5-1 in which record numbers to be displayed are stored. Block 6
-3 calls a subprogram that creates display data. At that time, the record number of the data to be created is passed as a parameter. Block 6-4 calls a program for displaying the data created in block 6-3. Block 6-4 updates the record number reference pointer P1. Block 6-6 determines whether the end of table 5-1 in which record numbers to be displayed are stored has been displayed. Specifically, the process ends when a code identifying the end of a valid record in 5-2 is detected. If there is display data, the process returns to block 6-3 to continue displaying.

FIG. 7 shows a subprogram that creates display data, and the record number of the data to be created is passed as a parameter. Block 7-1 initializes the interface area for creating display data.

Block 7-2 initializes pointer P2 for setting data in the interface area. Block 7-3 initializes pointer P3 for referring to item management table 3-1 in order to search for key items. Blocks 7-4 and 7-5 search for the corresponding entry in the item management table 3-1 based on the item name 5-3, which is a condition for data organization. In this case, the item "product name" is searched. Block 7-6 sets the corresponding data from the database 4 for the corresponding number of characters in 3-1-2 from the beginning of the interface area for creating display data, based on the record number and key item passed as parameters. .

Block 7-7 updates pointer P2 by the set number of characters. Block 7-8 determines whether there is one item to be displayed, and if there is one item, the process ends.

Block 7-9 initializes pointer P4 that refers to item management table 5-3 in order to set the remaining item data. Block 7-10 determines whether data has already been set as a key item. If set, jump to block 7-13.

Block 7-11 sets the corresponding data from the database 4 for the corresponding number of characters 3-1-2 at the position indicated by pointer P2 in the display data creation interface area. Block 7-12 updates pointer P2 by the set number of characters. Block 7-13 updates pointer P4.

Block 7-14 compares the number of items in 3-2 with the item management table reference pointer P4 to determine whether all item data has been set.

If there are any unset items, the process returns to block 7-10 and repeats the process.

〔Effect of the invention〕

According to the present invention, (1) Even if the conditions for organizing data change, easy-to-read output results can be obtained immediately in response to the change.

■There is no need to develop a program to create a separate output format and map output data to it.

It has the effect of saying.

[Brief explanation of the drawing]

Fig. 1 is a diagram showing an example of displaying results when sorting conditions are changed, Fig. 2 is a block diagram of an apparatus for implementing the present invention, and Figs. 3, 4, and 5 are examples of this embodiment. 6 and 7 are flowcharts for realizing the embodiment. 2-1...Display device, 2-2...Storage device, 2-3
...Input device, 2-4...Control device, 3-1...
Item management chiful, 3-2...Number of items, 5-1...
Record number storage area, 5-2...Record end symbol, 5-3...Number of records. Fig. 1 Fig. Fig. Fig. 6

Claims (1)

[Claims] 1. Storage means for storing input data, character fonts and programs, input means for inputting conditions for organizing data such as sorting, output means for outputting the results of the organized data, and control means for controlling these. In the data processing of the database provided with the database, when outputting the data organized according to the data organizing conditions to the output means in a tabular format, the order of the items in one line is changed, and the items for which the data organizing conditions are set are changed. A table processing device characterized in that output is fixed at a specific position in a row.