Statement - Revision history

G.dimaio: /* {{GVESB}} Configuration */

2017-04-06T20:16:57Z

‎{{GVESB}} Configuration

A.capaldo: /* {{GVESB}} Configuration */

2016-04-05T11:19:03Z

‎{{GVESB}} Configuration

A.capaldo: /* {{GVESB}} Configuration */

2016-04-05T10:56:57Z

‎{{GVESB}} Configuration

Anonymous: /* {{GVESB}} Configuration */

2012-11-12T13:40:33Z

‎{{GVESB}} Configuration

Anonymous: /* {{GVESB}} Configuration */

2012-11-12T13:30:57Z

‎{{GVESB}} Configuration

Anonymous: /* {{GVESB}} Configuration */

2012-11-12T13:28:55Z

‎{{GVESB}} Configuration

Anonymous: /* {{GVESB}} Configuration */

2012-11-12T13:21:33Z

‎{{GVESB}} Configuration

Anonymous: Replaced content with "==Description== This element defines the statement to be evaluated. Can contains placeholders that will be replaced at runtime. =={{GVESB}} Configuration== The elemen..."

2012-11-12T13:19:11Z

Replaced content with "==Description== This element defines the statement to be evaluated. Can contains placeholders that will be replaced at runtime. =={{GVESB}} Configuration== The elemen..."

Anonymous at 08:56, 10 April 2012

2012-04-10T08:56:52Z

Anonymous: /* ParamResolver */

2012-04-04T12:51:46Z

‎ParamResolver

@@ Line 56: / Line 56: @@
 </syntaxhighlight>
 Can specify multiple keys separated by commas.
 The attribute's value cannot be null.
 |}
 Does not contain subelements.

@@ Line 42: / Line 42: @@
 * Update: identifies the statement to be used to process the input row parameters.
 The attribute's value cannot be null.
 |-
 | keys || optional || Only useful in DBOSelect.

@@ Line 42: / Line 42: @@
 * Update: identifies the statement to be used to process the input row parameters.
 The attribute's value cannot be null.
 |-
 | keys || optional || Only useful in DBOSelect.

@@ Line 38: / Line 38: @@
 The attribute's value cannot be null.
 |-
-| id || optional || The attribute's value cannot be null.
+| id || optional || Statement identifier. Default is 0. It is used as value of row/@id attribute:
 |-
 | keys || optional || Only useful in DBOSelect.

@@ Line 46: / Line 46: @@
 specifying the attribute keys = "2", the result would be:
 <syntaxhighlight lang="XML"><RowSet>
-<data key_2="GreenVulcano">
+   <data key_2="GreenVulcano">
-<row><col>19</col> <col>pippo</col> </row>
+      <row><col>19</col><col>pippo</col></row>
-<row> <col>25</col> <col>pluto</col> </row>
+      <row><col>25</col><col>pluto</col></row>
- </data>
+   </data>
 </RowSet>
 </syntaxhighlight>

← Older revision		Revision as of 13:28, 12 November 2012
Line 18:		Line 18:
	* [[DBOUpdateOrInsert]]		* [[DBOUpdateOrInsert]]
	* [[Excel-call#Sheet\|Sheet]]		* [[Excel-call#Sheet\|Sheet]]
		+
		+	Its attributes are:
		+	{\|class="gvtable"
		+	! Attribute !! Type !! Description
		+	\|-
		+	\| type \|\| required \|\| Must be:
		+	* DBOSelect : select
		+	* DBOInsert : insert
		+	* DBOUpdate : update
		+	* DBOInsertOrUpdate : insert\|update
		+	* DBOUpdateOrInsert : insert\|update
		+	* DBOCallSP : callsp
		+	* Excel Sheet : select
		+	The attribute's admitted values are:
		+	* select
		+	* insert
		+	* update
		+	* callsp
		+	The attribute's value cannot be null.
		+	\|-
		+	\| id \|\| optional \|\| The attribute's value cannot be null.
		+	\|-
		+	\| keys \|\| optional \|\| Only useful in DBOSelect.
		+	Specifies the index of select output on which group the results.
		+	The corresponding values are specified as attributes of 'data' element within the 'RowSet' element.
		+	For example, in the select: SELECT id,company_code,name FROM employees
		+	specifying the attribute keys = "2", the result would be:
		+	<syntaxhighlight lang="XML"><RowSet>
		+	<data key_2="GreenVulcano">
		+	<row><col>19</col> <col>pippo</col> </row>
		+	<row> <col>25</col> <col>pluto</col> </row>
		+	</data>
		+	</RowSet>
		+	</syntaxhighlight>
		+	Can specify multiple keys separated by commas.
		+	The attribute's value cannot be null.
		+	\|}
		+
		+	Does not contain subelements.

@@ Line 17: / Line 17: @@
 * [[DBOUpdate]]
 * [[DBOUpdateOrInsert]]
-* [[Sheet]]
+* [[Excel-call#Sheet|Sheet]]

@@ Line 1: / Line 1: @@
 ==Description==
-The [[Statement]] element contains the statement to be evaluated. Those statements might contain [[placeholders]] that will be replaced at runtime.
+This element defines the statement to be evaluated.
-It is used by: [[DBOperations]].
+Can contains [[placeholders]] that will be replaced at runtime.
-The following table shows its attributes:
+=={{GVESB}} Configuration==
-Might contain the sub-elements:
+The element statement can be used by:
-* [[#StatementValue|StatementValue]]
+* [[CallDescriptor]]
-* [[#ParamResolvers|ParamResolvers]]
+* [[DBOFlatSelect]]
+* [[DBOInsert]]
-===StatementValue===
+* [[DBOInsertOrUpdate]]
+* [[DBOMultiFlatSelect]]
-StatementValue contains the value of the statement to be performed.
+* [[DBOSelect]]
+* [[DBOThreadSelect]]
-The StatementValue Element is used by: [[Statement]].
+* [[DBOUpdate]]
+* [[DBOUpdateOrInsert]]
-===ParamResolvers===
+* [[Sheet]]

@@ Line 1: / Line 1: @@
-[[Statement]] element contains the statement to be evaluated. Those statements might contain [[placeholders]] that will be replaced at runtime.
+==Description==
 It is used by: [[DBOperations]].
-The Statement element has the following parameters:
+The following table shows its attributes:
 {|class="gvtable"
 ! Attribute !! Type !! Description
@@ Line 19: / Line 20: @@
 * [[#ParamResolvers|ParamResolvers]]
-==StatementValue==
+===StatementValue===
 StatementValue contains the value of the statement to be performed.
@@ Line 25: / Line 26: @@
 The StatementValue Element is used by: [[Statement]].
-==ParamResolvers==
+===ParamResolvers===
 This element contains the list of Resolver used to resolve the parameters included in the statement.
@@ Line 36: / Line 37: @@
 * [[#ParamResolver|ParamResolver]]
-===ParamResolver===
+====ParamResolver====
 This element represents the type of a resolver to use for solving the parameters included in the statement.
@@ Line 46: / Line 47: @@
 * [[#XPathParamResolver|XPathParamResolver]] or [[#GVBufferParamResolver|GVBufferParamResolver]]
-====XPathParamResolver====
+=====XPathParamResolver=====
 Defines the type of Resolver based on XPath.
@@ Line 64: / Line 65: @@
 * [[#Param|Param]]
-=====Param=====
+======Param======
-This element defines the parameter to be solved according to an XPath expression applied to the body of GVBuffer.
+This element defines the parameter to be solved according to an XPath expression applied to the [[GVBuffer]] body.
 The Param Element is used by: [[#XPathParamResolver|XPathParamResolver]].
@@ Line 99: / Line 100: @@
-====GVBufferParamResolver====
+=====GVBufferParamResolver=====
 This element defines the Resolver based GVBuffer fields.
@@ Line 118: / Line 119: @@
 * [[#GVBufferParam|GVBufferParam]]
-=====GVBufferParam=====
+======GVBufferParam======
 This element represents the field of GVBuffer which is inserted in the statement.