Hello,

I am connecting to Firebird from a program with ODBC.

In the program it allows me to select from tables and views
but not Stored Procedures and match the fields in those
tables up to the programs fields.

The program seems to be limited in that it expects
a flat file of shipping info with all the addresses, ...
for a package in a single record. We don't store it that
way.

The program I am trying to setup is UPS WorldShip and
I can get it to connect and pull data, just as things
are I will be forced to create another file and update
it every time the order records are changed.

So, I was wondering if there is a way where I could fire
a trigger on a select? Or trick ODBC into reporting a
stored procedure as a file? Or does anyone have another
suggestion?

Thanks
Michael L. Horne