Hi guys,
I'm building a data driven presentation at the moment and some of the database tables I would like to return are using stored procedures. Have not had any luck getting one to work at the moment though, so thought Id ask whether or not the SQL Query Object supports providing a Stored Procedure Name to execute the query.
Cheers
Nick
Hello Ventuzians!
THE FORUMS ARE CLOSED!
Please join our discord server HERE!! << click me
We are shutting our Ventuz Forum, but don't worry, it will all be archived for you to search in if you have a query. From now on, please add all your comments, questions or observations into our Discord Server
Thanks for the great time - see you on discord!!
Dee, Karol, Daniel and the whoooole Product and Support team!
THE FORUMS ARE CLOSED!
Please join our discord server HERE!! << click me
We are shutting our Ventuz Forum, but don't worry, it will all be archived for you to search in if you have a query. From now on, please add all your comments, questions or observations into our Discord Server
Thanks for the great time - see you on discord!!
Dee, Karol, Daniel and the whoooole Product and Support team!
SQL Query Stored Procedure
Moderator: Support
- Daniel Willer
- Posts: 309
- Joined: 06 Jan 2012, 18:12
Re: SQL Query Stored Procedure
Hi there,
I guess we never tried out by ourselves. I will write a Ticket do a test for it. Do have a simple example that shows the probleme.
Regards
Daniel
I guess we never tried out by ourselves. I will write a Ticket do a test for it. Do have a simple example that shows the probleme.
Regards
Daniel
Re: SQL Query Stored Procedure
Hi,
i did some tests with Stored Procedures and our Query Nodes. It works fine.
In the Query itself you might have to respect the specifics of the database type or the SQL-dialect you are using. Also don't get confused by the SyntaxError Messages in the Script Editor. Hit Save&Close and check the Message Log for Errors.
I attach a small scene that uses the database from the helpscene for the Database Node.
Regards,
Götz
i did some tests with Stored Procedures and our Query Nodes. It works fine.
In the Query itself you might have to respect the specifics of the database type or the SQL-dialect you are using. Also don't get confused by the SyntaxError Messages in the Script Editor. Hit Save&Close and check the Message Log for Errors.
I attach a small scene that uses the database from the helpscene for the Database Node.
Regards,
Götz
- Attachments
-
- DatabasePro.vza
- (28.82 KiB) Downloaded 574 times