Name | Modified | Size | Downloads / 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%%' "