JP3358194B2 - Data processing device - Google Patents

Description

The present invention relates to a data processing device for checking the validity of input data in an office computer or the like.

2. Description of the Related Art Conventionally, in an office computer or the like, a check function of input data exists as a part of a function generally called a data dictionary, and this check function includes various check contents determined in advance for each input item. That is, the validity of input data is checked by checking whether or not the character type, the number of digits, or the number satisfies the inputtable range value.

[Problem to be Solved by the Invention] As described above, conventionally, only input conditions that are fixedly determined in advance as input conditions can be checked.

Therefore, in order to be able to check other input conditions, it is sufficient to describe the check details in the input program in advance. However, it is difficult for general users, etc. to describe the check details individually in the input program. In addition to being extremely difficult, the same check may be present in each program, which may cause a reduction in system efficiency.

An object of the present invention is to allow a user to arbitrarily register a reference file and a reference key, and to easily check data for an input item that does not exist in the reference key of the reference file at the time of input, regardless of program description. That is.

[Means for Solving the Problems] A check table storage means for storing, for each input item, file designation data for designating a reference file and key designation data for designating key information to be referenced from the reference file. A check table registration unit for arbitrarily registering the file designation data and the key designation data in the check table storage unit; and when the data corresponding to the input item is input, refer to the check table storage unit. Determining means for determining whether or not data corresponding to the key information specified by the key specification data exists in the reference file specified by the file specification data; The key information specified by the key specification data And notifying means for notifying that the corresponding data does not exist when it is determined that the corresponding data does not exist.

Therefore, the user can arbitrarily register the reference file and the reference key, and can easily check the data for the input item that does not exist in the reference key of the reference file at the time of the input, regardless of the program description.

[Explanation of Functional Block Diagram] FIG. 1 is a functional block diagram of the present invention. In the figure, 1 is a check table storage means, 2 is a check table registration means, 3 is a judgment means, and 4 is a notification means.

Embodiment An embodiment will be described below with reference to FIGS. 2 to 10.

FIG. 2 is a block diagram showing a basic configuration of the data processing device.

The keyboard 11 is a key input device for inputting various data, commands, and the like. Slip data and the like input from the keyboard 11 are sent to the input processing unit 12 for processing. That is, the input processing unit 12 processes the data input from the keyboard 11 in accordance with the setting contents set in the input table memory 13, and writes the data for one record thus obtained into the input file memory 14. At this time, the input processing unit
Reference numeral 12 checks input data by referring to the check table memory 15.

Here, the input table set in the input table memory 13 is configured as shown in FIG.

That is, the input table is arbitrarily set by the user, and the processing type and processing content are sequentially set for each word in the input table memory 13 corresponding to the input label. Here, the input labels are "Date", "Contact code", "Contact name", "Product code", "Product name",
Word names of input items indicating “quantity”, “unit price”, “amount”, and the like. The processing type indicates "reference", "input", "calculation", etc., "reference" defines that word data should be created with reference to the reference file memory 16 or the like, and "input" It defines that the input data should be word data, and “operation” defines that the data obtained by calculation should be word data. When the processing type is “reference”, the processing content defines, for example, that the clock circuit unit 17 should be referred to, and which file in the reference file memory 16 should be referred to.

Various reference files stored in the reference file memory 16 are configured as shown in FIG.

That is, FIG. 4A shows a personnel master file, which is composed of data indicating an employee name, a joining date, an address, and an age according to an employee code. FIG. 4B shows a product master file. The product master file includes data indicating a product name, a unit price, a release date, and a sales suspension flag corresponding to a product code.

The check table set in the check table memory 15 is configured as shown in FIG.

That is, the check table is arbitrarily set by the user, and various check contents (format, number of digits, reference master, reference master key, key condition, secondary check) are stored in the check table memory 15 in accordance with the input label. Here, “format” indicates the character type to be input, “digits” indicates the number of input digits, and “reference master” indicates which of the master files stored in the reference file memory 16. Specify whether to refer to the master file, "Reference master key" specifies which keyword should refer to the master file to be referenced, and "Key condition" refers to the master file with the keyword indicated by "Reference master key" At that time, for example, a condition such as that data corresponding to the keyword exists in the master file is designated, "Secondary check contents" indicates other check contents.

When the input processing unit 12 checks the input data according to the setting contents of the check table memory 15 and detects an input error, it causes the display unit 18 to display and output message data indicating the error.

Upon receiving a file update command from the keyboard 11, the file processing unit 19 refers to the setting contents of the update table memory 20 and various update files stored in the update file memory 21, ie, A file, B file,. Of the update target file is opened, an update record is created based on the input records read out one record at a time from the input file memory 14, and file processing for updating the update target file one record at a time is performed. In this case, the file processing unit 19 updates the record using the record memory 22.

The update table set in the update table memory 20 is configured as shown in FIG.

That is, the update table is arbitrarily set by the user, and the update table memory 20 stores “B
"File" is set as the file name to be updated, "Add" is set as the update type indicating the update content, and the file label corresponding to the input label is set as the word name to be actually updated.

Next, the operation of this embodiment will be described with reference to FIGS.

FIG. 7 is a flowchart showing an operation when the user sets an arbitrary check table in the check table memory 15. In this case, the input processing unit 12 displays guidance on the data to be set on the display unit 18, thereby taking in the data input from the keyboard 11 and sequentially setting the data in the check table memory 15.

First, a message prompting the user to input an "input label" is displayed (step A1), and the input label thus input is set in a corresponding area of the check table memory 15 (step A2). Next, a message prompting the user to input a "format" is displayed (step A3), and the input format is set in the check table memory 15 (step A4). At this time, the input format is set in step A2. Is set in the area corresponding to the input label.

Hereinafter, similarly, a message prompting the user to input “number of digits”, “reference master”, “reference master key”, “key condition”, and “secondary check content” is displayed (steps A5, A7,
A9, A11, A13), and as the data is sequentially input, the input data is sequentially set in the check table memory 15 (steps A6, A8, A10, A12, A1).
Four). At this time, these data are stored in the "input label" described above.
Unlike “digits” and “digits”, it is data set as needed. If a message is displayed for data that does not need to be set (step A5,
When the skip key is operated (A7, A13), the corresponding setting process (steps A6, A8, A14) is skipped, and the data is not set. Also, if you set “Reference Master”, “Master Key” and “Key Condition”
Must be set, but if "reference master" is not set, the process proceeds from step A7 to step A13 on the condition that the skip key is operated, and a message prompting the input of "secondary check contents" is displayed. Done.

Such a setting process is repeated until the operation of the setting end key is detected in step A15. As a result, a check table having contents as shown in FIG. 5 can be set in the check table memory 15.

FIG. 8 is a flowchart showing the operation when inputting slip data and the like input from the keyboard 11.

Now, it is assumed that the input table memory 13 stores an input table arbitrarily set by the user as shown in FIG.

First, the input processing unit 12 reads the setting contents of one word from the first word of the input table memory 13 (step B).
1), the type is determined (step B2). Now, the type of the head word is “reference”, and therefore, the process proceeds to step B7, and the clock data obtained by the clock circuit unit 17 is read based on the processing content of the word “clock”. Then, the process proceeds to step B10, and the time measurement data is stored as word data in the internal memory of the input processing unit 12. Next steps
In A11, it is checked whether or not the set contents of the input table memory 13 have been read up to the last word. However, since the set contents of the first word have been read, the process returns to step B1.

As a result, the setting content of the second word is read from the input table memory 13, but since the type of this word is "input", the process proceeds to step B3, and a message prompting data input is displayed. When the person in charge code is input from the keyboard 11, the input processing unit 12 refers to the check table set in the check table memory 15 and executes an input check process described later (step B).
Five). As a result, if an input error is detected in step B6, the process proceeds to step B3, and a message prompting re-input is performed.If the input data is correct, the process proceeds from step B6 to step B10, where the input person is entered. The data is stored in the internal memory of the input processing unit 12 as word data.

Thus, the setting content of the third word is read from the input table memory 13, and this word has a type of "reference".
Therefore, the process proceeds to step B7 in the same manner as described above, but in this case, the personnel master file (see FIG. 4A) stored in the reference file memory 16 is assigned to the person in charge code (input in the previous word processing). The person in charge (employee name) is searched as a keyword, and the person in charge (employee name) is read from this master file.

In this way, the set contents are sequentially read from the input table memory 13 word by word and processed. When the setting content of the last word is read from the input table memory 13, since the type of the word is "operation", the process proceeds to step B9, and the data based on the arithmetic expression defined by the processing content of the word is obtained. Perform the operation,
The calculation result is stored as word data in the internal memory of the input processing unit 12 (step B10). in this case,
Since the end of the process is detected in the next step B11, the process proceeds to the next step B12, where various word data stored in the internal memory of the input processing unit 12 are read out as data for one record, and the data is read out to the input file memory 14. Write.

FIG. 9 shows the input check processing (steps) shown in FIG.
It is a flowchart for demonstrating the specific processing content of B5).

First, an input label (for example, a person-in-charge code) of a word read from the input table memory 13 in the input processing described above.
, The input table is checked based on the corresponding format and the number of digits (step C1). Here, if the input data does not satisfy both the format and the number of digits, an input error is detected in step C2, but if both are satisfied, other check contents are set. Then, a check of a type corresponding to the setting content is performed.

That is, on the condition that the “reference master” is set (step C3), data corresponding to the “reference master key” is stored in the master file indicated by the “reference master” according to the “key condition”. It is checked whether or not there is (Step C4). As a result, if no input error is detected in step C5, the process proceeds to step C6.

On the condition that "secondary check contents" are set (step C6), it is checked whether or not the input data satisfies the second check contents (step C7).
As a result, if no input error is detected in step C8, the process ends assuming that the input data is correct.

FIG. 10 is a flowchart showing the operation of the file processing unit 19. When receiving the file update command from the keyboard 11, the file processing unit 19 opens the corresponding file in the update file memory 21 based on the file name set as the update target in the update table memory 20 (step D1). Then, from the input file memory 14 to 1
Read the data for the record (Step D2) and create an update record based on this input record (Step D2)
D3). In this case, the file processing unit 19 sequentially updates the type according to the update type set in the update table memory 20 for each word. The content of the file to be updated is updated with the update record created in this way (step D4).

Then, in step D5, it is checked whether or not an input record remains in the input file memory 14.
And the above file update is repeated one record at a time. If the end of the file update is detected in step D5, the file to be updated is closed (step D5).
6), the process ends.

In the above embodiment, the input data is processed while referring to the setting contents of the input table memory 13. However, the present invention is not limited to such input processing, and can be applied to input processing in a normal program format. .

[Effects of the Invention] According to the present invention, a user can arbitrarily register a reference file and a reference key for checking data corresponding to an input item, and register when a data corresponding to the input item is input. The validity of the input data is checked by referring to the reference file and the reference key that have been input. Therefore, regardless of the program description, the data for the input items that do not exist in the key information of the file can be easily checked at the time of the input. can do.

[Brief description of the drawings]

FIG. 1 is a functional block diagram of the present invention, FIGS. 2 to 10 show an embodiment, FIG. 2 is a block diagram of a data processing device,
FIG. 3 is a diagram showing an input table set in the input processing unit 12, FIG. 4 is a diagram showing various reference files stored in a reference file memory 16, and FIG. FIG. 6 shows the set check table, FIG. 6 shows the update table set in the update table memory 20, and FIG.
8 is a flowchart showing the input processing, FIG. 9 is a flowchart showing the specific contents of the input check processing shown in FIG. 8, and FIG. 10 is a flowchart showing the file update processing. It is a flowchart shown. 11 ... keyboard, 12 ... input processing unit, 15 ... check table memory, 16 ... reference file memory, 18 ... display unit.

Claims (1)

(57) [Claims] 1. Check table storage means for storing, for each input item, file specification data for specifying a reference file and key specification data for specifying key information to be referenced from the reference file, and the file specification is stored in the check table storage means. Check table registration means for arbitrarily registering data and the key designation data; and when the data corresponding to the input item is inputted, the check table storage means is referred to and a reference file designated by the file designation data is referred to. Determining means for determining whether there is data corresponding to the key information specified by the key specifying data; and this determining means specifies the reference file specified by the file specifying data by the key specifying data. The data corresponding to the key information does not exist The data processing apparatus is characterized in that anda informing means for informing to that effect when it is determined.