Subject | View from stored procedure |
---|---|
Author | Kulheim Jaroslav |
Post date | 2003-12-04T09:54:53Z |
Hello,
I need load data from Stored Procedure into Excel, but MSQuery knows only tables and views.
Instead of MSQuery I tried OpenOffice but the same problem.
Then tried create view: CREATE VIEW A (id) AS SELECT id FROM P13500(:ms,:vc)
but "Token unknown (".
Howto create view from stored procedure with input parameters ?
Howto load data into Excel or Openoffice from SP or view with input parameters?
Used sw:
IBPhoenix ODBC Driver - Snapshot release June 2003 on WinXP
Interbase 6.0 on Linux
Excel 2002
OpenOffice 1.1
Thanks,
Jaroslav Kulheim
[Non-text portions of this message have been removed]
I need load data from Stored Procedure into Excel, but MSQuery knows only tables and views.
Instead of MSQuery I tried OpenOffice but the same problem.
Then tried create view: CREATE VIEW A (id) AS SELECT id FROM P13500(:ms,:vc)
but "Token unknown (".
Howto create view from stored procedure with input parameters ?
Howto load data into Excel or Openoffice from SP or view with input parameters?
Used sw:
IBPhoenix ODBC Driver - Snapshot release June 2003 on WinXP
Interbase 6.0 on Linux
Excel 2002
OpenOffice 1.1
Thanks,
Jaroslav Kulheim
[Non-text portions of this message have been removed]