Ha! Det där är precis min uppfattning om Hansa oxå. Till råga på allt så kommer de säkert inte ens leverera en vettig lösning.
Det var därför jag ville göra det själv. Har kollat lite HAL och insett att det är för bökigt för att orka sätta mig in i dock.
Ingen här som har gjort det redan?
Hmm... Please excuse me if I have misunderstod your question, my Swedish is far from perfect..
But if I understod right, you want to extract data with SQL queries from Hansas native database (HANSA.HDB)? As far as I know, this is not possible with out a few tricks, as the Hansas database is not standards compliant in any way, and there is no documentation about any programming interface.
Possible ways to link with Hansa database:
- use ASCII file import / export, simplest to use, and easiesti to maintain since Hansa doesnt change export/import formats in every new version. If possible you can use the standard file format, or write your own export/import with HAL
- ODBC mirroring -.a few versions ago (3.9) it was possible to mirror the database transactions with ODBC into any comliant datastorage (database, Excel sheet, whatever)
- Open TCP/IP - it is possible to open one extra port into your Hansa server and send commands or queriers to the server in specified format. The licence is expensive, the documentation is non-existent, and there are only a handful of implementations
- use SQL database instead of Hansas own thinggy. Since version 4.1 it has been possible to use MS SQL Server as database backend instead of Hansas native HDB-format. This looks promising because that would eliminate a whole bunch of problems caused by Hansas native DB, but on the other hand the SQL database is still in beta stage.
Hope this helped.
