http://www.sqltree.net/wiki/basis-cgi/ 2008-12-31T06:39:36+01:00 http://www.sqltree.net/wiki/basis-cgi/ http://www.sqltree.net/wiki/basis-cgi/lib/images/favicon.ico text/html 2007-10-11T16:43:54+01:00 Jonathan Gill http://www.sqltree.net/wiki/basis-cgi/doku.php?id=welcome&rev=1192113834&do=diff1192113834 Welcome to the SQLTree Wiki. Version 1.1 is now out. Documentation in progress. Introduction The Basics Action Types Execution About History text/html 2007-08-20T08:35:57+01:00 Jonathan Gill http://www.sqltree.net/wiki/basis-cgi/doku.php?id=codeplain_actiontype&rev=1187591757&do=diff1187591757 A “Code - Plain” action is an action that you can write and execute C# code with. In order to see whether the code will compile, select the “Build\Compile” menu item. Any errors will be output to a message box. Unfortunately the line numbers in the error messages currently do not match up with the actual lines in the script. This will be rectified in a future release. text/html 2007-07-17T12:29:22+01:00 Jonathan Gill http://www.sqltree.net/wiki/basis-cgi/doku.php?id=setup_actiontype&rev=1184668162&do=diff1184668162 Setup Action A setup action is an action that is used to establish a connection with a data source (eg. a SQL Server database). This connection is then used by other actions (like “SQL Script” and “Code - Modify Column” actions) to execute their code with. You can change the current connection by simply inserting a new setup action at the required position in the action tree. The fields are the usual SQL Server connection parameters (server, database, authentication type & detail… text/html 2007-07-17T11:58:41+01:00 Jonathan Gill http://www.sqltree.net/wiki/basis-cgi/doku.php?id=action_types&rev=1184666321&do=diff1184666321 SQLTree Action Types SQLTree currently supports these type of actions: * Setup * SQL Script * Folder * Code - Plain * Code - Modify Column * Global Variables text/html 2007-07-17T04:26:15+01:00 Jonathan Gill http://www.sqltree.net/wiki/basis-cgi/doku.php?id=folder_actiontype&rev=1184639175&do=diff1184639175 Folder Action Type A Folder action just acts as an empty action you can use to group related actions together. You can give it a description for documentation purposes or to clarify what this group of actions is all about. A folder action will not do anything of itself when executed. text/html 2007-07-17T04:19:29+01:00 Jonathan Gill http://www.sqltree.net/wiki/basis-cgi/doku.php?id=sqlscript_actiontype&rev=1184638769&do=diff1184638769 SQL Script Action A “SQL Script” action is an action that (big surprise...) lets you write and execute a SQL script. In order for it to run you will need to have a Setup Action in front of it. This ensures there is a valid data connection available to execute the SQL statements against. Separate SQL statements with a semi-colon (;), and batches with the “GO” command (”GO” has to be followed by a newline in order to work). Comments are prefixed with either two dashes (--) or…