Calling MySQL Stored Procedure within View Object SQL Statement?
490060Apr 14 2006 — edited Apr 16 2006I'm trying to call a MySQL stored procedure within the SQL Statement area of the View Object Editor: 'call testproc(?)'
The View Object SQL Statement Editor automatically appends a SELECT statement resulting in:
SELECT * FROM (call testproc(?)) QRSLT WHERE 1=2
Since this is a non-Oracle database, I can not use the Query Builder to freeform enter the Query.
How can I get around this so I can call the MySQL Stored Procedure from the View Object without the Original SQL being edited?
thanks
Tom