Execute single SQL query

Function description

  Execute SQL statement query in the target database and the first record in the query result set. It needs to be used together with the database connection component.

instructions

  After adding the SQL query component of the execution order to the visual editing area, the attribute & ldquo; Output to variable & rdquo; Set the output content variable parameter in & ldquo; Target database object & rdquo; Enter the variable name of the database object in & ldquo; SQL statement & rdquo; Enter the SQL statement to be executed in & ldquo; SQL statement parameters & rdquo; Enter the parameter value in & ldquo; Display Dictionary & rdquo; Select whether to display the dictionary in the setting. After the attribute value is set, it runs successfully. Print the returned value content to get the execution result. As shown in the figure.  

 

Attribute description

• Target database object: the previously opened database link.
• SQL statement: SQL statement without parameters 

 

  With parameters

 

• SQL statement parameters: SQL statement parameters. Single parameter: ['1 '], multi parameter: ['1','2 ','3'].
• Display Dictionary: displays the key in the returned value.

  Do not return Dictionary:

  

  Return to Dictionary:

 

• Output to: output to the variable.

Code description

• Code example  

    

• Parameter description

    

• Return value description