Wiki

Scale Your Enterprise

User Tools

Site Tools

Trace: • contact • Control Types • Decision Tool • Introduction to Error Handling • HANA SQL Tips • Report Data Source Types • sap_business_one_integration_for_sql_server_databases • Introduction (GraphqL) • File Operations Tool • Salesforce.com API
bizweaver:sql

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
bizweaver:sql [2024/09/24 15:36]
dlee [Post Execution Query (SQL Server only)] 		bizweaver:sql [2024/09/24 15:37] (current)
dlee [SQL Tips]
Line 79: Line 79:
  
  
-====== User Notes ======+===== User Notes =====
  
   - Any “calculated” value in a SQL statement must have an alias assigned for it to be available in Bizweaver. This applies to numeric calculations, concatenated text values, CASE values, and any other instance where the value is not a column name in a table. Standard syntax rules apply for assigning alias names.   - Any “calculated” value in a SQL statement must have an alias assigned for it to be available in Bizweaver. This applies to numeric calculations, concatenated text values, CASE values, and any other instance where the value is not a column name in a table. Standard syntax rules apply for assigning alias names.
Line 87: Line 87:
  <code>'WorkFlow(GetData).Get({FIELD_ItemCode})'</code>  <code>'WorkFlow(GetData).Get({FIELD_ItemCode})'</code>
  
-====== SQL Test Run Option ======+===== SQL Test Run Option =====
 Bizweaver version 2.3 introduces the **Execute** option in the SQLCommand tool.  This option allows you to test SQL functions without running through the entire workflow.  It also allows you to test SQL steps where the input involves variables from previous steps.  The example here uses the following SQL statement. Bizweaver version 2.3 introduces the **Execute** option in the SQLCommand tool.  This option allows you to test SQL functions without running through the entire workflow.  It also allows you to test SQL steps where the input involves variables from previous steps.  The example here uses the following SQL statement.
  
Line 110: Line 110:
 </WRAP> </WRAP>
  
-====== SQL System Variables ======+===== SQL System Variables =====
  
 ^ Name           ^ Description         ^ ^ Name           ^ Description         ^
Line 123: Line 123:
  
  
-======SQL Tips======+=====SQL Tips=====
   * **[[bw2:sql tools|Strip HTML Tags From Input String]]**   * **[[bw2:sql tools|Strip HTML Tags From Input String]]**
  
bizweaver/sql.1727206567.txt.gz · Last modified: 2024/09/24 15:36 by dlee

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial 4.0 International
CC Attribution-Noncommercial 4.0 International Valid HTML5 Valid CSS Driven by DokuWiki