JP2002196925A - Application creation support program for database processing - Google Patents

Abstract

(57) [Summary] [PROBLEMS] To minimize the amount of coding performed by a programmer. SOLUTION: An application creation support means 2 has a development component 5, and the development component 5 has a frame processing means 6. The frame processing means 6 creates a frame for storing application data on a display screen, and performs a predetermined process using the data stored in the frame. The frame processing means 6 has an attribute setting means 7 and a processing execution means 8. The attribute setting unit 7 sets an attribute for a predetermined operation, and the process execution unit executes a predetermined process.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

The present invention relates to a database processing application creation support program used when a programmer creates a database processing application.

[0002]

2. Description of the Related Art In various systems including a backbone business system, it is required to process a large amount of data quickly and accurately in order to promote efficiency of business, and therefore, access to a database is required. It is required to be performed efficiently. An application for database processing is software for enabling efficient access to such a database, and is usually created by a programmer using application creation support means called a development tool. As the application creation support means, there is, for example, Visual Basic of Microsoft Corporation of the United States having a GUI operation function. Conventionally, a programmer has performed an application creation work as follows.

For example, when a slip description table is created and the contents described in this table are to be registered in a database, the programmer dynamically assembles the SQL statement and displays the value to be described in a text on a display screen. , List boxes, radio buttons, and other various fields, and set the entered values in variables. At this time, it is necessary for the programmer to determine which column of the table is to be set, and to perform coding for describing the logic. Alternatively, in a case where the result of performing a search on the database is to be transferred to various fields on the display screen and displayed, the programmer performs coding that describes logic for the transfer display.

[0004] Also, when a specific key operation is performed, a function of automatically moving a cursor on a display screen to a predetermined position in accordance with the key operation is intended to be realized. The programmer coded to describe the logic for this cursor movement.

[0005]

However, in the above-described example of creating a slip description table, if there are a large number of rows or columns in the table, the amount of coding becomes enormous, and the programmer requires a great deal of labor. Result.

Further, in the conventional application creation support means, many logics relating to database access must be realized by coding, and thus the created application tends to have a large number of steps. Therefore, when it is necessary to change a certain logic after or during the creation of an application, it is necessary to change the logic of many places. It was difficult to grasp clearly.

As the amount of coding increases, the application reflects the individuality of the programmer. Therefore, in order for the user to customize the application, it is necessary to fully understand the coding method of the programmer,
The result was extra effort.

The present invention has been made in view of the above circumstances, and has as its object to provide a database processing application creation support program capable of minimizing the amount of coding that must be performed by a programmer. .

[0009]

According to a first aspect of the present invention, there is provided an information processing apparatus comprising: an input unit for outputting a logic control signal based on a predetermined input operation; Application creation support means for performing a predetermined operation for creating a database processing application based on a logic control signal;
And a database processing application creation support program functioning as a display control means for displaying contents based on a predetermined operation of the application creation support means on a display screen, wherein the application creation support means stores a frame for storing data of the application in the program. Frame processing means for performing predetermined processing using data created on the display screen and stored in the frame; and further comprising an attribute setting for setting an attribute for the predetermined operation. Means, and processing execution means for executing the predetermined processing.

According to the above configuration, a plurality of steps related to each other can be processed by the frame processing means. The frame processing means has an attribute setting means and a processing execution means, and by using these means, it is possible to perform a predetermined operation and a predetermined processing relating to the database processing with a small amount of coding.

According to a second aspect of the present invention, in the first aspect of the present invention, the attribute setting means includes a screen display line number setting means for setting a line number of a frame displayed on the display screen; Display start line designating means for designating a display start line among the lines in which the data is stored, current line designating means for designating a current line among the lines in which the data is stored and displayed, and displayed on the display screen. Line number setting means for setting the number of lines of a frame, wherein the processing execution means has a writing means for writing data stored in a row or a column set by the attribute setting means to a database. It is characterized by being.

According to the above arrangement, the number of rows and columns in the frame can be freely set by the number-of-rows setting means and the number-of-columns setting means. And columns can be displayed. Then, the data is sequentially stored in the row designated by the current row designation means, and finally, the writing means collectively writes the data in the frame into the database. That is, processing over a plurality of lines in a frame can be executed as if it were processing on one line.

According to a third aspect of the present invention, in the first aspect of the present invention, the processing execution means determines processing contents for data stored in a row or a column in the frame,
Further, after this determination, data processing determination means for moving the cursor position to a predetermined position set in advance, and data processing reset means for resetting the processing content determined by the data processing determination means and the cursor position to the state before determination, A display start line designation for designating a display start line among the lines in which the data is stored, in accordance with a decision operation of the data processing decision unit or a reset operation of the data processing reset unit. Having means.

According to the above arrangement, the cursor position can be moved to a preset desired position every time the data processing determining means determines the processing content for the data in the frame. At this time, when it becomes necessary to change the display start line due to the definition of the processing content, the display start line designating means functions to make the change. Then, the processing contents once determined and the cursor position can be returned to the original state by the data processing resetting means.

[0015]

FIG. 1 is a block diagram showing functions of a computer realized by a program according to an embodiment of the present invention. In this figure, an input means 1 inputs an operation signal from an input device (not shown) such as a keyboard or a mouse, and sends a logic control signal to an application creation support means 2 (in this embodiment, Visual Basic is used). Output. The application creation support means 2 performs a predetermined operation for creating a database processing application, such as accessing the database 3. The display control means 4 displays contents based on a predetermined operation of the application creation support means 2 on a display screen.

The application creation support means 2 has a development component 5 (in this embodiment, a component called "Soludina OCX" is used), and this development component 5 has a frame processing means 6 (in this embodiment, "Soludina OCX"). S-Frame "). Further, the frame processing means 6 has an attribute setting means 7 (usually called "property") and a processing execution means 8 (usually called "method").

The frame processing means 6 creates a frame for data processing on the display screen and performs a predetermined process using the data stored in the frame.
The attribute setting unit 7 sets an attribute for a predetermined operation, and the process execution unit 8 executes a predetermined process.

FIG. 2 is a chart showing an example of the attribute setting means 7 and the processing execution means 8. As shown in this chart, the attribute setting means includes “Disp.
“Rows”, “TopRow” as a display start row designating unit, “Rows” as a row number setting unit, “Row” as a current row designating unit, and the like. "WriteData" as means, "CommitData" as data processing determination means, "ResetData" as data processing reset means, and the like are included. Since the frame processing means 6 has various kinds of attribute setting means and processing execution means which are related to each other, the number of application steps which can be created by easy coding is increased, and the work of the programmer can be reduced accordingly. .

Next, an example of an application creating operation performed by using each of the above-described units (in this example, an application creating operation related to slip processing) will be described with reference to FIG. The programmer first activates the application creation support means 2 and the development component 5 sequentially, and then activates the frame processing means 6. Then, a predetermined key operation is performed, and the number of screen display rows is specified by the screen display row number setting means DispRows (for example, six rows are specified), and
The number of rows in the data storage area is designated by the number-of-rows setting means Rows (for example, it is assumed that 10 rows are designated). Then, the number of rows designated as the number of screen display rows (hereinafter, referred to as “data storage rows”) is displayed.

FIG. 3 shows an example of this display, in which items include "line", "product name", "product number",..., "Remarks", and the like. Two data storage rows are displayed in table format. The programmer writes data in each item column in each data storage line of the displayed table. FIG. 3 shows a state in which the third to eighth lines are displayed, but of course, first, the first to eighth lines are displayed.
Up to the sixth line are displayed. That is, when the programmer finishes writing the data in the first to sixth rows,
Press the key or the down arrow key. Then, the top row of the data storage row changes to the second row, and the screen displays the second row to the second row.
The seventh line is displayed. When the Enter key or the down arrow key is further pressed, the uppermost row of the data storage row is changed to the third row, and the third to eighth rows are displayed as shown. As described above, the programmer can scroll the table contents by pressing the Enter key or the down arrow key to cause the display start row setting means TopRow to function, and write all ten rows set by the row number setting means Rows. Can be included.

Then, after completing the above-mentioned writing, the programmer writes this current line to the database by the writing means WriteData. That is, the programmer can perform the writing process to the database over a plurality of rows in the frame without coding like the processing of one row, and the writing process can be performed efficiently.

Further, when writing data in each item of the table shown in FIG. 3, the programmer presses, for example, an enter key to sequentially determine data on the display screen by the data processing defining means CommitData. . In this case, the function of CommitData can be set so that the cursor position automatically moves to a predetermined position every time the enter key is pressed. For example, in the fourth line of FIG. 3, the programmer enters the “product number” and presses the enter key to confirm the display of the product number on the screen. At this time, the cursor position is automatically set. Then, move from the column of "product number" to the position of "unit price". Then, when the programmer similarly enters the "unit price" and presses the enter key, the cursor position automatically moves to the "stock quantity". When the "stock quantity" is entered, the entry of all items in the fourth row has been completed, so the display start row designating means TopRow moves down the display start row from the third row to the fourth row. That is, the fourth to ninth lines are displayed on the screen.

Further, the programmer can return the display contents of the screen to the original state, that is, the state before the enter key is pressed by operating the data processing reset means RsetData. For example, if the user enters the unit price and presses the enter key, and immediately notices that an incorrect numerical value has been entered, the programmer presses a predetermined key to activate the data processing reset means RsetData, and The numerical value in the "unit price" column is deleted, and the cursor position already moved to the position in the "stock unit" column is returned to the position in the "unit price" column. As a result, the programmer can quickly and easily execute the subsequent correction work even when a data entry error is made.

[0024]

As described above, according to the present invention, various related properties (attribute setting means) and methods (processing executing means) are provided as processing functions for performing processing in a frame. Thus, the amount of coding can be reduced, and the effort of the programmer can be reduced.

Therefore, even if the logic is changed after or during the creation of the application, the number of places where the logic needs to be changed is reduced, and the number of steps of the programmer can be easily grasped.

In addition, since the amount of coding is reduced, the user can easily customize the application without knowing the coding method of the programmer.

[Brief description of the drawings]

FIG. 1 is an exemplary block diagram showing functions of a computer realized by a program according to an embodiment of the present invention.

FIG. 2 is a table showing an example of types and an outline of an attribute setting unit 7 and a process execution unit 8 in FIG. 1;

FIG. 3 is an explanatory diagram showing an example of a screen displayed by a frame processing unit 6 in FIG. 1;

[Explanation of symbols]

 1 input means 2 application creation support means 3 database 4 display control means 5 development parts 6 frame processing means 7 attribute setting means 8 processing execution means

Claims (3)

[Claims] 1. An input means for outputting a logic control signal based on a predetermined input operation to a computer, and an application creation support for performing a predetermined operation for creating a database processing application based on the logic control signal from the input means. Means, and a database processing application creation support program functioning as display control means for displaying contents based on a predetermined operation of the application creation support means on a display screen, wherein the application creation support means comprises a frame for storing data of the application. On the display screen, and performs a predetermined process using data stored in the frame. The frame processing unit further sets an attribute for the predetermined operation. Attribute setting means And a process execution means for executing the predetermined process. A database processing application creation support program, comprising: 2. An attribute setting unit, comprising: a screen display line number setting unit for setting a line number of a frame displayed on the display screen; and a display for designating a display start line among lines in which the data is stored. Starting line designating means; current line designating means for designating a current line among the lines in which the data is stored and displayed; and line number setting means for setting the number of lines of a frame displayed on the display screen. 2. The database processing according to claim 1, wherein the processing execution unit includes a writing unit that writes data stored in a row or a column set by the attribute setting unit into a database. Application creation support program. 3. A data processing determining means for determining processing contents for data stored in a row or a column in the frame, and moving a cursor position to a predetermined position after the determination. And a data processing reset unit that resets the processing content and the cursor position determined by the data processing determining unit to a state before the determination, and wherein the attribute setting unit determines the operation of the data processing determining unit, or 2. The database processing apparatus according to claim 1, further comprising a display start line specifying unit that specifies a display start line among the lines in which the data is stored, in response to a reset operation of the data processing reset unit. Application creation support program.