A method that returns multiple values through SQL statements, one operation, multiple SQL execution in a form

Example:

<billc_ex_int01 datatype= "float" name= "duly cast"

Sql= "Select ISNULL (SUM (exbd_ex_num001), 0) as RESULT from Tex_business_data

WHERE (exbd_ex_str002= ' $current ()/billc_ex_str003$ ') and (exbd_ex_str003= ' duly cast ') ▓billc_ex_int02 SELECT SUM (Bill_ AMOUNT) as RESULT from Tbill

▓billc_ex_int03 Select SUM (bill_acc_amount) as RESULT from Tbill ">0</BILLC_EX_INT01>

Add a refresh button after the billc_ex_int01 field in the xsl:

<button class= "refresh_small_01" onclick= "Fn_call (' click_sql ', ' Get SQL result value by clicking ', ' billc_ex_int01 ', This.num)" >

<xsl:attribute name= "num" >

<xsl:value-of select= "@num"/>

</xsl:attribute>

</button>

Explanation: By clicking the Refresh button, the SQL statement is executed sequentially, the first sentence is written to its own field billc_ex_int01, followed by the "▓ form field name SQL query statement ▓ form field name SQL query statement ▓ form field name SQL query statement" form to execute separately, Write them back separately.

A method that returns multiple values through SQL statements, one operation, multiple SQL execution in a form