| Name | Modified | Size | Downloads / Week |
|---|---|---|---|
| Parent folder | |||
| 1.1.1.0 | 2013-03-07 | ||
| 1.1.0.0 | 2012-01-04 | ||
| 1.0.0.9 | 2012-01-04 | ||
| 1.0.0.7 | 2011-10-07 | ||
| 1.0.0.6 | 2010-06-15 | ||
| 1.0.0.4 | 2010-06-12 | ||
| ReadMe.txt | 2013-03-07 | 2.1 kB | |
| Totals: 7 Items | 2.1 kB | 6 | |
=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%%' "