JPH06161733A - System and method for program generation - Google Patents

Abstract

PURPOSE:To perform the generation of a specific operation system by necessary irreducible minimum parameter input by utilizing the skeleton of a specific operation system which can be customerized. CONSTITUTION:A menu which prompts the input of a parameter is displayed on a display means and a parameter inputted from an input means according to the menu is analyzed; and the skeleton 30 is read out of an auxiliary storage means and a parameter based upon the analytic result is embedded in the read skeleton 30, and consequently a 2nd executable program is generated under the assistance of a 1st program. The number and names of items of the frame 31F of modified data records that the 2nd program has are concretely determined for a source frame 31B of the data records, and the frame 32F of codes is also determined for a source frame 32B correspondingly.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a program generation technique capable of creating a second program executed with the support of a first program, and further, specification with a degree of freedom that can be customized within a certain range. The present invention relates to a technology for generating a specific business system by using a skeleton (a model forming a skeleton) of the business system.

[0002]

2. Description of the Related Art Inventory management, financial accounting, customer management, sales management, etc. are available as a specific business system constructed by using a personal computer or a workstation. Such a business system can be programmed by using a programming language or can be constructed by using general-purpose application software such as a database or a spreadsheet. However, when using general-purpose application software, because of its versatility, the user must specify the design of the framework of the data record necessary for the specific business system, the item setting, and the registration and printing range setting for the data record. . For such processing, not only knowledge of the target specific work, but also commands or languages for programs prepared in the development system (program development system using a general-purpose programming language) or application software for various settings, etc. It is assumed that you are also familiar with, which is not easy for users. For this reason, conventionally, standard forms such as vertical and horizontal tabulation tables and address books corresponding to specific application software have been provided. Some forms have the required description of a programming language, such as a macro language, embedded in them.

[0003]

However, in the case of a simple fixed form, there is no degree of freedom in the number of items and the layout of the names and the items, and it is impossible to construct a required business system with this. Practically impossible. Also, if you try to change such a form,
The required description of the programming language such as the macro language embedded in the form must be changed accordingly, and the labor is no different from the labor of constructing the required business system from the beginning. Furthermore, the user is forced to perform work that is not directly related to the performance of the target business by using knowledge different from the knowledge of the target business system.

An object of the present invention is to use a skeleton of a specific business system having a degree of freedom that can be customized,
It is intended to create a specific business system by inputting the minimum necessary parameters. The above and other objects and novel features of the present invention will be apparent from the description of this specification and the accompanying drawings.

[0005]

[Means for Solving the Problems]

(1) The program generation system according to the present invention creates a second program that is executed under the support of the first program (in an environment in which the first program is executed or the processing result of the first program is executed). It is a possible program generation system and includes a storage unit, an input unit, a display unit, and an arithmetic control unit. The first program is a program development system that uses a general-purpose application program or a general-purpose programming language that is a basis for creating a required specific business system. The second program is an application program as a required specific business system. To generate the second program,
Use the skeleton of a specific business system with customizable degrees of freedom. In the present invention, the skeleton is
It is a basis for generating a primitive framework of at least the number of items and an item name undecided for the data record framework, and a code framework for data processing for the data record framework supported by the first program. Includes the source code framework. The storage means is for storing such a skeleton,
The input means can input a parameter for modifying the primitive framework of the data record and the primitive framework of the code, and the display means can display an input guide of the parameter. The arithmetic control means displays a parameter input guide on the display means, and analyzes the parameter input from the input means in response to the first control means, and reads the primitive framework of the data record from the storage means. A second control means for modifying the undetermined items of the source framework of the read data record based on the analysis result by the first control means, and a source control framework of the code from the storage means; And modifying the source code framework of the read code based on the analysis result by the first control means so as to correspond to the framework of the data record generated by the second control means to generate the code framework. And 3 control means. (2) When inputting a parameter, in order to recognize the correspondence between the input parameter and the format specified by the primitive framework of the data record so as to prompt the parameter input, the correspondence is sequentially described according to the parameter input. It may be displayed on the display means. (3) The data record framework is, for example, a table framework supported by the first program for spreadsheet, or a data record framework supported by the first program for database. The code framework is, for example, a processing code for registering, modifying, and printing a data record.

[0006]

According to the above means, when the system is started up, the menu for prompting the input of parameters is displayed on the display means, the parameters input from the input means are analyzed according to the menu, and the skeleton is stored in the storage means. Is read, and a parameter based on the analysis result is set in the read skeleton, whereby the second program is generated. The framework of the modified data record held by the generated second program is such that the number of items and the item names are concretely determined with respect to the primitive framework of the data record before modification, and the framework of the generated code is also Determined according to the data record framework. In this way, the second program as an application program that matches the required specific business system is acquired by inputting the minimum necessary parameters related to the specific business.

[0007]

FIG. 4 shows an embodiment of the program generation system according to the present invention. The system according to this embodiment includes an arithmetic and control unit 1, a main storage unit 2, an auxiliary storage unit 3, an input unit 4, a display unit 5, an output unit 6, and a data transmission unit 7. The arithmetic and control unit 1 is not particularly limited,
It is mainly composed of a central processing unit and its operating system, and executes an application program read from the auxiliary storage unit 3 by using the main storage unit 2 as a work area and a temporary storage area for data. The various peripheral devices connected to the arithmetic and control unit 1 are operated under the control of the arithmetic and control unit 1. Although not particularly limited, the display device 5 is composed of a CRT display device, the input device 4 is a keyboard, the auxiliary storage device is a floppy disk device or a hard disk device, the output device 6 is a printer, and the data transmission device 7 is a modem.

FIG. 1 shows the basic configuration of the program generation system. This program generation system is a program generation system capable of creating a second program that is executed under the support of the first program, and the first program is a general-purpose application program that is the basis for creating the required specific business system. Is. The second program is an application program as a required specific business system. To generate the second program, the skeleton 30 of the specific business system having a customizable degree of freedom is used. The skeleton 30 is
A code for generating a primitive framework 31B of a data record in which at least the number of items and item names have not been determined for the framework of the data record and a framework of data processing for the framework of the data record, which are respectively supported by the first program. And a primitive framework 32B of The skeleton 30 is read-accessed from the storage medium of the auxiliary storage device 3 and supplied to the arithmetic and control unit 1. Data record primitive framework 31B and code primitive framework 32
Parameters for modifying B and embodying them are input from the input device 4. The display device 5 displays a parameter input guide in order to prompt an operating procedure when the parameter is input.

The arithmetic and control unit 1 causes the display unit 5 to display a guide for inputting parameters, and accordingly, the input unit 4
First control means 11 for analyzing parameters input from
Then, the primitive framework 31B of the data record is read from the auxiliary storage device 3, and the undetermined items of the primitive framework 31B of the read data record are identified by the first control means 11
The second control means 12 which modifies the frame 31F of the data record based on the analysis result of the above, and the source framework 32B of the code is read from the auxiliary storage device 3, and the source framework 32B of the read code is stored. First
Second control means 1 based on the analysis result by the control means 11.
The third control means 13 for generating the code framework 32F to be modified in correspondence with the data record framework 31F generated in 2; the data record framework 31F generated by the second control means 12; Third control means 1 for making write access to a predetermined area of the auxiliary storage device 3 with the code framework 32F generated by the third control means 13.
4 and are included. The data record framework 31F and the code framework 32F are the second program PG.
Configure M2.

FIG. 2 shows an example of a system configuration in which a vertical / horizontal tallying program corresponding to the first program for spreadsheet is generated as a second program PGM2. The primitive framework 31B of the data record at this time is the primitive framework of the vertical and horizontal tabulation table supported by the first program for spreadsheet calculation. The primitive framework 31B of the vertical-horizontal tabulation table defines a worksheet in which cells are arranged in a matrix in a matrix direction, and item names, the number of items, cell attributes, and the like are in an undecided state. Primitive framework of code 3 in this example
2B is a primitive framework of code such as macro code for realizing data input to the completed vertical and horizontal tabulation table, correction of input data, printing and reading and saving of the vertical and horizontal tabulation table, and graphing of the vertical and horizontal tabulation table. The parameters for arbitrarily embodying the skeleton as the above-mentioned primitive framework are the number of rows and each row item name, the number of columns and each column item name, the attribute of each item (whether the input numerical value is a monetary amount or a simple numerical value, etc.) ), The name of the entire vertical and horizontal tabulation table (name of the program). By giving such a parameter, the arithmetic and control unit 1 generates a worksheet integrally provided with a form as a frame of a vertical and horizontal tabulation table and a macro language description as a frame of a code defining a process for the form. To do. Such a worksheet is positioned as the main body of the second program. As for the code framework for the source code framework, the print range and the like are specifically specified according to the number of columns and the number of rows of the vertical and horizontal summary tables specified by the parameters. The second program thus generated is supported by the first program, in other words,
It is executed in an environment where the first program is executed in some sense or the processing result of the first program can be executed. It is possible to generate a description of a command that activates the first program in association with the second program.

FIG. 3 shows an example of a system configuration in which an address book type database program corresponding to the first database program is generated as a second program PGM2. Primitive framework 31B of data record at this time
Is the primitive framework of the unit record of the database supported by the first program for the database. The primitive framework 31B defines, for example, the item layout of the unit data record of the address book type and the format of the database record in which the item name is not set at all or the outline is determined with some degree of freedom. Is. The source code framework 32B in this example is a source code framework for implementing data registration, search, correction, deletion, printing, list display, and the like for a completed database record format. The parameters for embodying the skeleton as the above-mentioned primitive framework are data names and attributes for defining the database record format,
Furthermore, it is a type selection rather than a detail of the contents of the source framework of data records and codes. By giving such a parameter, the arithmetic and control unit 1 has a format of a database record such as an address book or a book management,
An application program integrally provided with a programming language description as a framework of a code that defines data processing for the format is generated. Such an application program is positioned as the main body of the second program supported or processed by the first program. The code framework for the source code framework includes, for example, searchable items that are specifically specified according to the items of the data record determined by the input parameters. The second program generated in this way is the first
It is executed under the support of the program, in other words, in an environment in which the first program is executed in some sense or the processing result of the first program can be executed.

Next, a specific example of the processing of the arithmetic and control unit 1 in the second program generation system relating to the vertical and horizontal tabulation table of FIG. 2 will be described.

FIG. 5 shows a main flowchart of processing by the arithmetic and control unit 1. First, when the process for generating a program is started, as shown in FIGS. 11 and 12, an opening message, an outline of a vertical and horizontal tabulation table to be created and an operation guide for advancing the process are displayed on the display device 5. It is displayed (S1). When a key operation according to this operation guide is performed by the input device 4, a display prompting the user to input a line item name (“line item name:” in FIG. 13) and a display of the input line item name (“line in FIG. 13”). The line item name: "Yamada" on the right side is sequentially displayed on the display device 5, and the input line item name is stored in, for example, a work area or a temporary file on the main storage device 2 (S2). Next, when a key operation (pressing the enter key with the line item left blank) is performed by the input device 4 according to the operation guide, the process proceeds to the process of inputting the column item name, as shown in FIG. The required number of row item names input so far are displayed in one column, and a display prompting the user to enter a column item name (“Column item name:” in FIG. 14) and a display of the entered column item name (FIG. 14) "1" to the right of "Column item name:" is sequentially performed on the display device 5, and the input column item name is stored in, for example, a work area or a temporary file in the main storage device 2 (S3). . When a key operation (pressing the enter key with the column item left blank) is performed by the input device 4 according to the operation guide, the process proceeds to the process of inputting the title name of the table, as shown in FIG. The required number of row item names and column item names that have been input up to that point are displayed, and a display prompting you to enter the title name of the table below (“Summary table title:” in FIG. 15) and the table being entered. The title names are displayed ("Sales" on the right side of "Title of summary table" in FIG. 15) sequentially on the display device 5, and the input program name is stored in the work area or the temporary file on the main storage device 2, for example. It is stored (S4). Next, as shown in FIG. 16, a display prompting the user to determine the attribute of the input numerical value (“Is the input numerical value an amount? (Y / n):” in FIG. 16) and a response thereto, for example, a response of “yes” ("Y" on the right side of "Is the input numerical value an amount? (Y / n):" in Fig. 16) is displayed, and the input response contents are stored in, for example, a work area or a temporary file on the main storage device 2. (S5).

After the parameters are input in steps S2 to S5, the second program relating to the vertical and horizontal tabulation table is automatically generated using the parameters and the skeleton. The generation process is not particularly limited, but a process of generating a creation and execution macro of a worksheet and a support macro (S6), a process of generating a worksheet call execution macro (S7), and a process of generating a macro execution control program ( S8). Creation of worksheet and support macro Processing to generate execution macro (S6)
Generates a macro that generates a worksheet based on the input parameters, a macro that supports the worksheet, and a macro that executes the macro.
The worksheet will consist of a vertical and horizontal tabulation table (an example of a data record framework) and a resident macro (an example of a code framework) for menu operations on the table. The process of generating the worksheet call execution macro (S7) is
Although it is not an essential element of the system, it is necessary in this embodiment, and a macro for calling and executing a worksheet already generated by the macro execution control program is generated. The first time the macro execution control program creates the worksheet and the support macro
From the second time onward, it is a program that controls to use the worksheet call execution macro.
It is generated in 8). Therefore, when the macro execution control program is first started, the worksheet and the support macro creation execution macro are executed, thereby generating the worksheet reflecting the input parameters and the macro supporting the worksheet. To be done.
The worksheet thus generated will be composed of a vertical and horizontal tabulation table (an example of a data record framework) and a resident macro (an example of a code framework) for menu operation of the table. Make up. Next, when the macro execution control program is started, the worksheet call execution macro is executed, the generated worksheet is called, and the resident macro can be executed. Since each macro is a macro of the first program for spreadsheet calculation, the macro execution control program also starts the first program when it is started.

FIG. 6 shows an example of an overall procedure of the process (S6) for generating the worksheet and the support macro generation execution macro. First, a file (worksheet / support macro creation / execution macro file) in which a worksheet / support macro creation / execution macro to be created is stored is opened. The file name is, although not particularly limited, “program name (inputted by parameter) .I20”. Then, a macro that creates a form of a horizontal and vertical tabulation table based on the source framework of the data record and the analysis result of the input parameter, and a macro that operates the vertical and horizontal tabulation table based on the source framework of the code and the analysis result of the input parameter. Is generated and written in the file (steps S61 and S62).
Next, a macro for writing a table created by executing a macro for creating a form of the vertical and horizontal tabulation table (also simply referred to as a table) and a macro for operating the table to a predetermined file as a worksheet is a worksheet and Creation of support macro It is written to the execution macro file (S6
3). At this time, "program name (input by parameter) .W20" is assigned to the file name in which the worksheet is to be written. Then, the jump macro to the macro start cell in the worksheet is written to the worksheet and support macro creation execution macro file (S64), and the worksheet and support macro creation execution macro file is closed (S6).
5). The jump macro to the macro start cell in the worksheet is a resident macro in the worksheet (macro for menu operation of vertical and horizontal tabulation tables) immediately after the worksheet is created by the creation and execution macro of the worksheet and support macro. ) Is to realize the function for enabling.

7 and 8 show a detailed example procedure of the macro generation process (S61) for creating the form of the vertical and horizontal tabulation tables. In the process shown in FIG.
As shown in 610 to S619, a table title display macro, a heading display macro for each row, a macro for displaying the heading Total in the bottom row of the heading, a macro for writing the column sum function in each cell in the bottom row of the table, Macro that displays the column headings, Macro that displays the heading Total in the rightmost row of the table, Macro that writes the row total in each cell in the rightmost row of the table, Display the amount of money when the cell attribute is monetary amount A macro that encloses the table with a grid is generated. The title of the table in step S610 reflects the program name input as a parameter. Step S61
The line heading in 1 corresponds to the line item name input by the parameter, and the number of input items is set by centering. Similarly, the column headings in step S614 correspond to the column item names for which parameters have been input, and the number of input items is set by centering. In step S613, the total number of cells in which the column sum function is written is set to the parameter input column item number + 1. The number of cells to write the row sum function in step S616 is matched with the number of row items parameter-input. In the determination in step S617, the parameter-inputted cell attribute is taken into consideration, and the process of step S618 is executed only when the cell attribute is the amount of money. At this time, the amount of money target cell area is (the number of column items +
1) × (number of line items + 1) matrix area. Then, the ruled line target cell area in step S619 is a matrix area of (column item number + 2) × (row item number + 2). Therefore, the contents of the input parameters are automatically reflected in the form of the table generated by executing these various macros.

FIG. 9 shows a detailed example procedure of the macro generation process (S62) for menu-operating the table. First, a macro for displaying, selecting, and branching the operation menu is generated (S620). The operation menu is not particularly limited, but for example, data input / correction (I), print (P),
Data saving (S), data reading (L), graphing (G), end (E), and stop (Q) are performed. Next, in order to realize the processing corresponding to each menu, as shown in steps S621 to S627, a macro that performs input / correction, a macro that performs printing processing, a macro that performs data saving processing, and a macro that performs data reading processing. , A macro for selecting and printing a graph type, a macro for saving a worksheet and ending, and a macro for stopping and ending a process are generated. The print range in step S622 is the title row of the table and the matrix area of (column item number + 2) × (row item number + 2). Step S623
Both the storage range in and the read range in step S624 are a matrix area of (the number of column items + 2) × (the number of row items + 2). In this way, steps S622 to S6
The contents of the input parameters are automatically reflected in the macro generated at 24.

FIG. 10 shows a detailed example procedure of the worksheet calling execution macro generation processing (S7). First, a file (worksheet call execution macro file) in which a macro for calling a worksheet already created and stored in a file is to be stored is opened (S70). Although this file name is not particularly limited, it is eventually set to "program name (input by parameter) .C20", but initially at the transitional stage of the process described later, "program name (input by parameter)". ) .X20 ". Then, a macro for calling the worksheet from the file is generated and written to the worksheet call execution macro file (S71), and a jump macro to the macro start cell in the worksheet is generated to call the worksheet. It is written to the execution macro file (S72), and finally the worksheet call execution macro file is closed. The jump macro to the macro start cell in the worksheet realizes a function for activating a resident macro (macro for menu operation of a table) in the worksheet opened by the worksheet execution macro. .

Through the above procedure, the creation execution macro of the worksheet and the support macro and the worksheet call execution macro are generated, and these are processed by the macro execution control program in the following procedure. Although not particularly limited, the file name of the worksheet call execution macro is initially set to "program name.X20" in the worksheet call execution macro generation process (step S7). Then, in the execution macro file “program name.I20” for creating the worksheet and the support macro, immediately before the description of the jump macro to the macro start cell in the worksheet, the worksheet call execution macro file name is “program name.I20”. The description of the process of rewriting from "X20" to "program name.C20" is included.
Therefore, once the worksheet and support macro creation / execution macro is executed, the worksheet call execution macro file name is changed to "program name.C20". Although the macro execution control program name is not particularly limited, it is “program name.BAT”, and when the macro execution control program is started, this program starts the spreadsheet program as the first program. However, at this time, which of the worksheet and support macro creation execution macro and the worksheet call execution macro is executed is as follows. That is, when the file of “program name.C20” does not exist (when the file of “program name.X20” exists), a worksheet and a support macro creation execution macro file (“program name.I2”) are created.
0 ") is opened to create a worksheet as the second program, and the file of" program name.C20 "exists (the file of" program name.X20 "becomes the file name of" program name.C20 "). If it has been changed), the file name “program name.C
The worksheet call execution macro file "20" is opened, and the worksheet as the second program is made available. With such control by the macro execution control program, the creation execution macro of the worksheet and the support macro is made available for the first time, and the worksheet call execution macro is made available for the second time and thereafter. The number of processing steps for switching macros to be used can be reduced and the processing speed can be improved.

FIG. 17 shows a state in which a part of the worksheet as the second program created in the system of this embodiment is displayed on the display device 5. The display state of FIG. 17 is a state in which data is input to some cells, and when data is input, the total value is automatically displayed in the total column.

As is clear from the above description, such a second program is created only by the user inputting the parameters, and the number of items in the vertical and horizontal tabulations, the item names, the cell attributes, etc. are set by the user. It is determined according to desired input parameters. Therefore,
The second program as a required business system can be created with a relatively high degree of freedom.

Although the invention made by the present inventor has been specifically described based on the embodiments, the present invention is not limited thereto, and needless to say, various modifications can be made without departing from the scope of the invention. Yes. For example, the second program described in the above embodiment has been described by taking an address book type database and a vertical / horizontal tabulation table as an example, but the present invention is not limited to this, and various business systems such as inventory management, financial accounting, customer management, and sales management. Furthermore, it can be applied to the creation of a transcribing system from slips to tables, a technical term dictionary system, a data management system with menu guidance, and the like. It is also possible to prepare a primitive framework of data records and codes for each business type, display this in a list menu, and select a business type by inputting parameters to generate a desired business system. Further, the second program is not limited to the form in which the macro is embedded in the form, and can be configured in the programming language supported by the first program. Further, the storage means capable of read-accessing at least the area for storing the source frame of the data record and the source frame of the code whose item name and item name are undetermined are not limited to the auxiliary storage device as described in the embodiment, and the main storage It may be a device or a storage device having another configuration.

[0023]

According to the invention disclosed in the present application, the following effects are obtained. (1) Using a skeleton of a specific business system with a degree of customizability, the specific business system can be easily created by inputting the minimum necessary parameters. That is, such a specific business system is not only a form-like data record framework,
A code framework for data processing of the form is also included, and when the desired form is embodied by a desired parameter input from the user, the code framework is also determined accordingly. So the user
Even if you don't have any program knowledge about the first program,
Even if you are not familiar with the operation system of the first program, you can create a business system as the second program according to your needs and preferences by entering the minimum required parameters according to the input guidance display. You can
In other words, the user (user) may have little knowledge about the business. Further, it becomes possible to enjoy the know-how in performing the work contained in the skeleton of the specific work system. (2) When inputting a parameter, the correspondence between the input parameter and the format defined by the primitive framework of the data record is sequentially displayed on the display means in accordance with the parameter input, and the parameter input can be urged so that the correspondence can be recognized. And a good man-machine interface can be realized.

[Brief description of drawings]

FIG. 1 is a basic configuration diagram of a program generation system according to an embodiment of the present invention.

FIG. 2 is a system configuration diagram of an embodiment in which a vertical and horizontal totaling program corresponding to a first program for spreadsheet is generated as a second program.

FIG. 3 is a system configuration diagram of an embodiment in which an address book type database program corresponding to the first database program is generated as a second program.

FIG. 4 is a system block diagram of one embodiment of the program generation system of the present invention.

FIG. 5 is a main flowchart of processing by the arithmetic and control unit 1.

FIG. 6 is a flowchart of a process of creating a worksheet and a support macro creation execution macro.

FIG. 7 is a flowchart showing a first half processing procedure of macro generation processing for creating a form of a vertical and horizontal tabulation table.

FIG. 8 is a flowchart showing a processing procedure in the latter half of the macro generation processing for creating a form of a vertical and horizontal tabulation table.

FIG. 9 is a flowchart of a macro generation process for menu-operating a table.

FIG. 10 is a flowchart of a process of generating a worksheet call execution macro.

FIG. 11 is an explanatory diagram showing a display example of an opening message displayed at the start of the process for generating the second program and an outline of a vertical and horizontal tabulation table to be created.

FIG. 12 is an explanatory diagram showing a display example of an operation guide displayed at the start of processing for generating a second program.

FIG. 13 is an explanatory diagram showing a display prompting for input of a line item name and a display example of the input line item name.

FIG. 14 is an explanatory diagram showing a display example when the process proceeds to a column item name input process.

FIG. 15 is an explanatory diagram showing a display example when a program name input process is performed.

16A and 16B are explanatory diagrams showing a display prompting to determine the attribute of the input numerical value and a display example of the response.

FIG. 17 is an explanatory diagram showing a display example of a part of the worksheet as the second program created in the system of this embodiment.

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 1 arithmetic control means 2 main storage device 3 auxiliary storage device 4 input device 5 display device 11 first control means 12 second control means 13 third control means 14 fourth control means 30 skeleton 31B primitive frame of data record 31F of data record Framework 32B Code primitive framework 32F Code framework PGM2 2nd program

Claims (7)

[Claims] 1. A second program, which includes a data record framework and a code framework for data processing corresponding to the framework, which are respectively supported by the first program, and is executed with the support of the first program. And a storage unit, an input unit, a display unit, and an operation control unit, wherein the storage unit corresponds to at least a primitive framework of a data record whose item number and item name are undecided. The input means is for storing the source code framework and the input means is capable of inputting a parameter for modifying the source code framework and the source code framework, and the display means is a parameter Input guidance can be displayed, and the arithmetic and control unit causes the display unit to display the input guidance of parameters. Correspondingly, the first control means for analyzing the parameters inputted from the input means, and the primitive framework of the data record are read from the storage means, and the undetermined matter of the primitive framework of the read data record is determined by the first control means. Second control means for generating a frame of the data record by modifying based on the analysis result according to, and reading the source framework of the code from the storage means, and analyzing the source framework of the read code by the first control means. And a third control means for modifying the data record framework generated by the second control means to correspond to the framework of the data record and generating the code framework. system. 2. The first control means is capable of sequentially controlling the display of the input parameters on the display means in a format defined by the primitive framework of the data record together with the input guidance display of the parameters. The program generation system according to claim 1, wherein: 3. The program generation system according to claim 1, wherein the framework of the data record is a framework of a table supported by the first program for spreadsheet. 4. The program generation system according to claim 1, wherein the framework of the data record is a framework of a data record supported by the first program for a database. 5. The program generation system according to claim 1, wherein the framework of the data record is a framework of data representation supported by the first program for data processing. 6. The code framework includes at least one or a plurality of types of codes selected from processing codes for registering, modifying, and printing data records. The program generation system according to any one of claims. 7. A second program including a data record framework and a code framework for data processing for the framework supported by the first program, the second program being executed with the support of the first program. Is a program generation method for generating based on a skeleton including at least a primitive framework of data records whose item number and item name are undetermined, and a primitive framework of code corresponding to the primitive framework of data records. And a step of displaying on the display means a menu for prompting the input of parameters for modifying the parameter, a step of analyzing the parameters input from the input means, a step of reading the skeleton from the storage means, and a parameter for the read skeleton. Incorporate the analysis results of to confirm the undetermined items of the skeleton. Program generating method characterized by comprising the steps of generating a second program is, the.