Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Method for resolving problem of unable outward variable transfer of executive character string under action domain limitation

A technology for executing characters and scopes, applied in the direction of program control devices, etc., can solve the problem that strings cannot directly transfer variables, transfer variables, etc., and achieve the effect of reducing code writing workload, reducing CPU load, and improving computing performance.

Inactive Publication Date: 2009-03-25
BEIJING SIRUAN TECH
View PDF0 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The present invention is a relatively convenient method for solving the problem that the execution string is limited by the scope and cannot directly transmit variables
[0005] The solution method of the present invention is realized like this: in stored procedure or batch processing, first create temporary table, then insert or update data to temporary table in execution string, then query the data of temporary table outside execution string, thereby solve The problem that variables cannot be passed from inside to outside of the execution string

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method for resolving problem of unable outward variable transfer of executive character string under action domain limitation

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0013] Referring to the accompanying drawings, we will illustrate the specific implementation of the present invention with a simplified example.

[0014] The accompanying drawings show a part of an executable unit from the beginning to the end, and the executable unit should have other processing, including the definition of variable @C, etc., only the parts directly related to the present invention are listed here, and other parts have been omitted .

[0015] Step 2 of the accompanying drawing shows a part of an execution string, and the execution string should have other processing, including the definition of the variable @B, etc., only the parts directly related to the present invention are listed here, and other parts have been omitted.

[0016] Step 1 is to create temporary table #A.

[0017] Step 2 is to insert the value of variable @B into temporary table #A in the execution string.

[0018] Step 3 is to query from the temporary table #A and assign it to the variabl...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention provides a method which aims at solving the problem that a variable in an execution character string can not be transferred to the outside due to the limitation of an effect scope and is applied to the program design of the storage process or batch processing in a relational data base based on the structured query language. In the program design, by utilizing the execution character string method, a query statement can be dynamically formed, which makes the program design more flexible; however, the execution character string has the independent scope, and the variable defined in the execution character string can not be directly transferred out of the execution character string; aiming at the problem, the method is characterized in that during the storage process or batch processing, a temporary table is established first; in the execution character string, data are inserted or updated; and outside the execution character string, the data of the temporary table are queried, so that the problem that the variable in the execution character string can not be transferred to the outside is solved. With the method, the application of the execution character string is more flexible and wider, the programming complexity is effectively simplified, and the operational performance of a computer is improved.

Description

Technical field: [0001] The present invention relates to software design, especially application software program design using stored procedure or batch processing in relational database system based on structured query language. Background technique: [0002] The relational database system based on structured query language is the most commonly used and the most efficient database system, and is widely used. In the specific program design of stored procedures or batch processing in the relational database system of structured query language, it is often necessary to write a large number of similar query statements, and the changed parts are mainly table names, column names and other objects that cannot use variables. This requires dynamically constructing query statements from long strings created with concatenation operators such as strings and string variables, and then using the execute string function to execute. This method makes program design more flexible, can effe...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F9/44
Inventor 董为卿
Owner BEIJING SIRUAN TECH
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com