HI,
I am running on a Bisam database and I want to query the database on demand to make external services based on the Bisam data.

Currently, we are using job to export data periodically but the jobs system is quite uncertain. This will make another post...

Anyway, running SQL query on demand would be great.

Thank you for your time,
Fred

We have ERPJewels open source project (http://sourceforge.net/projects/baan2excel/) which uses dyanamic sql query to get on demand baan data (be it on SQL / oracle / bisam) from any baan table / report in excel . May be this can help .

For archiving purpose,
the tool qptool6.0 seems the same as iqtool6.0 on my version (MK).

I successfully made dynamic query to the Bisam database, using the regex parser "/[^\\s\"']+|\"([^\"]*)\"|'([^']*)'/" after a system call of iqtool6.0 through SSH.

Note that there is some escape backslashes in the regex since I work in PHP.

Note also that the resulting string con contain some weird fields that I call "not present if null" which will affect the field number for a row since the value will not be present if the field is null.

Hope it will help someone.

Fred