Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

Tree [105399] default tip /
History



File Date Author Commit
Images 2013-04-01 Philnext Philnext [105399] initial
source 2013-04-01 Philnext Philnext [105399] initial
AxBase.dpr 2013-04-01 Philnext Philnext [105399] initial
AxBase.dproj 2013-04-01 Philnext Philnext [105399] initial
AxBase.exe 2013-04-01 Philnext Philnext [105399] initial
AxBase_Icon1.ico 2013-04-01 Philnext Philnext [105399] initial
ReadMe.txt 2013-04-01 Philnext Philnext [105399] initial
axbase.Bat 2013-04-01 Philnext Philnext [105399] initial
bd1.mdb 2013-04-01 Philnext Philnext [105399] initial
pad_file.xml 2013-04-01 Philnext Philnext [105399] initial

Read Me

=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%%' "