Ask Your Question
0

Base: Call a MySQL Database Stored Procedure

asked 2019-12-03 19:33:49 +0100

ikopanas gravatar image

updated 2019-12-03 19:40:47 +0100

I connect to a MySQL database with Base and there I have some stored procedures. How I may call them from Base and get the results?

Example: CREATE PROCEDURE GetAllProducts() BEGIN SELECT * FROM products; END

Is it possible to call the "GetAllProducts() stored procedure from BASE within a BASE QUERY?

e.g. SELECT * FROM GetAllProducts();

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2019-12-03 19:50:51 +0100

Ratslinger gravatar image

Hello,

MySQL Stored Procedures need a CALL statement to run (see-> CALL Statement). This cannot be done from the Query section.

They can be run from a macro. See -> Calc: call a stored procedure

edit flag offensive delete link more

Comments

Thanks for the help! Really appreciate it!

ikopanas gravatar imageikopanas ( 2019-12-03 22:30:04 +0100 )edit

Suppose we have a form with a button. When button pressed we run the macro that runs the stored procedure... how can we display the results in a table (grid) format in the form?

ikopanas gravatar imageikopanas ( 2019-12-05 09:22:10 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-12-03 19:33:49 +0100

Seen: 23 times

Last updated: Dec 03