alaurentiu@... wrote:

> I use Firebird with Excel VBA and I manage to make SELECT, INSERT, DELETE.. etc BUT...

> I didn't find anywhere how to run a stored procedure

{[? =] Call MyProc (?,?)}

The ODBC driver knows to EXECUTE an executable procedure and to SELECT
from a selectable one.

> or a stored querry

Do you mean a VIEW? A view is not a stored procedure. You just
select from a view as for a table. INSERT, DELETE, etc., just the
same, too, provided the view is updatable.

If you mean a selectable stored procedure, then there is no way to
update the set produced from it. As mentioned above, you just use the
'call' verb and the driver will treat the SP according to its
definition.

> So, Please, can You help me with some examples or documentation
> about how to use stored procedures or running stored querry in Excel VBA?

Look at the old CHM help file in the \help\2004 subdirectory of your
ODBC installation. If you encounter problems, please subscribe to the
firebird-odbc-devel list on Sourceforge and present your question
there. Firebird-support is for database-related questions, not drivers.

Helen