Download Latest Version SetupAxBase_1.1.0.0.exe (652.4 kB)
Email in envelope

Get an email when there's a new version of AxBase

Home / AxBase / 1.0.0.6
Name Modified Size InfoDownloads / Week
Parent folder
AxBase_Source_1.0.0.6.zip 2010-06-15 740.3 kB
AxBase_Source_Setup_1.0.0.6.zip 2010-06-15 811.7 kB
AxBase_Source_Setup1.0.0.6.exe 2010-06-12 838.0 kB
Totals: 3 Items   2.4 MB 0
=General :
 AxBase is an Open source MDB / SQL Server Database viewer and editor. 
 You can view & edit the tables (+ field descriptions) and execute SQL queries without Access licence. 
 Export Tables to CSV/ XLS, Compress & Repair MDB. Compile needs Delphi Pro.
 Compatible with Delphi 7 to Xe2 (pro).

=Version History :
 1.1.1.0 : some debug, '-c' compact line parameter option.
 1.1.0.0 : XE2 (and 2010/XE) compatibility & Suppress JCL/JVCL
 1.0.0.9 : Add trace for batch execution.
         : - Fix 'index error' message opening empty base.
 1.0.0.8 : Inline parameters for batch files
 1.0.0.7 : password for mdb files
 1.0.0.6 : add list of last queries + navigator
 1.0.0.5 : bug fixes.
 1.0.0.4 : add Table Navigator & change some file extension principes when save.
 1.0.0.3 : add 'delete table' & 'Open Xls Files' functions
 1.0.0.2 : bug fix for DBGRID 'error' on non SELECT (UPDATE/INSERT...) Query
 1.0.0.1 : add tools : export CSV & XLS
 1.0.0.0 : first release.

=Command line :
 Since ver. 1.0.0.8 Axbase may be used with command line option for automated query in batch files.

 *Syntax :
   axbase -s=<database name> [-q="<query>"]  [-f=<target file name>] [-c]

 With -s option only AxBase run the user interface and open the <database name> base.
 If -q option is used, AxBase open the <database name> base without the user interface, execute 
 the <Query> SQL query and close.
 With -f (needs -q)  a file is created with the result of query, the format is depending on the file extension, 
 only csv & xls are available.
 -c : compact the base, if used with a '-q' option, the query is executed before the base is compacted.
 
 *Exemples : 
   axbase  -s=C:\Datas\demo.mdb -q="update clients  SET CL_SDA='' WHERE  CL_DATEDEP IS NOT NULL AND CL_SDA <> ''"
   axbase  -s=C:\Datas\demo.mdb -q="SELECT * FROM CLIENTS" -f="c:\cl.csv"
 
 *Remark : replace wildcard % by %% in queries because problems to use % in windows batch files.

   axbase  -s=C:\Datas\demo.mdb -q="SELECT CLIENTS WHERE  CL_NOM LIKE 'T%%' "
Source: ReadMe.txt, updated 2013-03-07