> 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

do you use SELECT from SP? or EXECUTE?
If it's a selectable SP. use SELECT
Alan