TeleFlow Step 0825

From TeleFlow

Revision as of 07:13, 16 May 2008 (edit) Wikilib (Talk | contribs) (New page: Image:Iv_825.gif <strong><big>SQL End Transaction Step</big></strong><br> Ends the transaction defined by SQL Begin Transaction. The database can be returned to the state it was in bef...) ← Previous diff		Current revision (07:14, 16 May 2008) (edit) (undo) Wikilib (Talk | contribs)
Line 17:		Line 17:
	[[Image:Iv_815.gif]] [[TeleFlow_Step_0815|DB Lock]]<br>		[[Image:Iv_815.gif]] [[TeleFlow_Step_0815|DB Lock]]<br>
	[[Image:Iv_820.gif]] [[TeleFlow_Step_0820|SQL Begin Transaction]]<br>		[[Image:Iv_820.gif]] [[TeleFlow_Step_0820|SQL Begin Transaction]]<br>
-	[[Image:Iv_830.gif]] [[TeleFlow_Step_0825|SQL End Transaction]]<br>	+	[[Image:Iv_830.gif]] [[TeleFlow_Step_0830|SQL End Transaction]]<br>
	[[Image:Iv_835.gif]] [[TeleFlow_Step_0835|SQL Fetch]]<br>		[[Image:Iv_835.gif]] [[TeleFlow_Step_0835|SQL Fetch]]<br>
	[[Image:Iv_810.gif]] [[TeleFlow_Step_0810|SQL Statement]]<br>		[[Image:Iv_810.gif]] [[TeleFlow_Step_0810|SQL Statement]]<br>

---

Current revision

SQL End Transaction Step
Ends the transaction defined by SQL Begin Transaction. The database can be returned to the state it was in before the SQL Begin Transaction, or the recent changes can be committed, or saved permanently.

Note: Please refer to the SQL Users Guide for more information about SQL programming in TeleFlow.

Properties

Parameters: Determines whether the transaction defined by the SQL Begin Transaction are committed or rolled back, based on which radio button option is selected. The radio buttons are:

• Commit / Save changes to database
  
• Rollback / Discard changes
  

Action Steps

None.

Related Steps

DB Connect
DB Disconnect
DB Lock
SQL Begin Transaction
SQL End Transaction
SQL Fetch
SQL Statement