Database Command Executor v2.3.4.28

Copyright (c) 2008 - 2011  Precision software & consulting.
All rights reserved.

This is a simple utility that can perform a sql commands on a database.
You can execute an insert, update or delete commands as well as select statements.
Utility returns the number of processed records as its ExitCode and you can
also save the results (selected records or the processed records number) to the specified
XML, CSV or TXT file.

It is possible to immediately transform the resulting XML file by the selected XSL stylesheet template,
so you can export the result to as many text based formats as you want.

The sql statement may include parameters prepended with a colon (ie. :NAME or :CITY, etc.).
Then the user can enter the parameter values in the simple editable grid of parameters.
Statement is run as many times as rows in the grid, the user defines.

If you run the utility without command-line parameters, the full GUI is displayed,
so you can specify and save the parameters, that you can use later by a command-line execution.

This utility uses the dbExpress technology for database connection.
MySQL, Interbase, Firebird and BlackfishSQL databases are supported by default,
as well as the common connection via the ODBC drivers.
You can extend this list by any dbExpress v4 driver (ie. Oracle, MSSQL, Sybase, etc.).

This utility is a part of Precision Builder Express product.


Requirements:
  Microsoft Windows 2000/XP/2003/Vista/7/2003 Server
  Appropriate database driver libraries and system configuration


Change log:
  v2.3.4.28 (13.8.2011, a minor update)
  - added: Welcome page (to manage your stored command options)
  - improved: Load/Save buttons are available also on Results page
  - improved: Advanced parameters can be pre-filled via new menu item
  - improved: Navigation through the wizard via keyboard (using the RETURN/ESCAPE keys)
  - improved: Entered parameter values are stored in the resulting XML output
  - improved: Firebird Connection driver has been updated

  v2.0.1.14 (26.4.2010, a major update that brings a lot of improvements)
  - added: any dbExpress (version 4) driver can be added and configured to use with this utility
  - added: ODBC, AS400 and Firebird (native) driver included by default
  - added: support for any additional connection parameter (charsets, blobsize, etc.)
  - added: syntax highlighting in the SQL command definition and on the results page
  - added: saving results to the XML and fixed width TXT formats
  - added: possibility to immediately transform the XML result by the selected XSL stylesheet template,
           so you can export the result to as many text based formats as you want
  - added: option to immediately open the resulting file after processing the command
  - added: option to save results to the clipboard instead of file
  - added: automatic generation of the command-line form
  - added: a lot of minor improvements
  
  v1.0.1.1 (14.4.2010)
  - first release


Syntax:
  dbexec.exe [-oOptionsFile] [-hServer] [-wPort] [-xDriver] [-dDatabase] [-uUserName] [-pPassword]
             [-rRoleName] [-aDBParams] [-sSQL] [-fFileName] [-cFormat] [-qQuote] [-mDelimiter] [-i]
             [-nColWidth] [-zStylesheet] [-tTitle] [param=value [param2=value2 [...]]]
             [-ha] [-hc] [-hl] [-hs] [-hd] [-hr] [-ho] [-bb] [-fr]

  -oOptionsFile   File with predefined options
  -hServer        Server name or IP address
  -wPort          Port
  -xDriver        Database driver (MySQL, Interbase, Oracle, etc.)
  -dDatabase      Database schema name or file name
  -uUserName      Login user name
  -pPassword      Login password
  -rRoleName      Login role name
  -aDBParams      Advanced or extra parameters for database connection (param=value;param2=value2;...)
  -sSQL           SQL command to execute
  -fFileName      Save results to a specified file (csv, txt or xml format)
  -cFormat        Save results to the clipboard in specified format (csv, xml, html or txt)
  -qQuote         Quote for resulting csv file format
  -mDelimiter     Delimiter for resulting csv file format
  -i              Include the header row in resulting csv file or txt file
  -nColWidth      Max. column width for resulting txt file format
  -zStylesheet    Transform the xml result by stylesheet
  -tTitle         Window title

  param=value     Parameter values for 'Data entry' section (param=value param2=value2 "param3=black or white" ...)

  -ha             Do not show any GUI (process the command and exit)
  -ht             Do not show task selection page
  -hc             Do not show connection page (connection must be configured)
  -hl             Do not show login page (login must be configured)
  -hs             Do not show SQL command page (sql must be configured)
  -hf             Do not show Save to file options
  -hd             Do not show data entry page (sql without a parameters or a data source is required)
  -hr             Do not show results page
  -ho             Do not show the option buttons (Load, Save and More)
  -bb             Do not show back button
  -fr             Do not show role name field

ExitCodes:
  -2              Database error, xslt transformation error, or any other exception
  -3              User break
  any other       Number of processed records
  

Database drivers:
  This utility uses the dbExpress technology to connect to databases. Installed drivers and its configurations
  are defined in the 'dbxdrivers.ini' file, supporting libraries must be located in the utility installation folder
  or in the system path.
  
  You can freely extend the default configuration by your dbExpress (version 4) drivers.

  List of preinstalled drivers:
  MySQL - Embarcadero Technologies, www.embarcadero.com
  Interbase - Embarcadero Technologies, www.embarcadero.com
  BlackfishSQL - Embarcadero Technologies, www.embarcadero.com
  Firebird - Embarcadero Technologies, www.embarcadero.com, FirebirdSQL Server, http://www.firebirdsql.org/
  FirebirdConnection - Chau Chee Yang, http://sites.google.com/site/dbxfirebird/home, FirebirdSQL Server, http://www.firebirdsql.org/
  dbxODBC - Edward Benson, http://open-dbexpress.sourceforge.net/
  AS400 - Peter Sawatzki, http://www.sawatzki.de
  

Precision software & consulting
e-mail: info@be-precision.com
www:    http://www.be-precision.com
