Base: Call a MySQL Database Stored Procedure

ikopanas · December 3, 2019, 6:33pm

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();

Ratslinger · December 3, 2019, 6:50pm

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

ikopanas · December 3, 2019, 9:30pm

Thanks for the help! Really appreciate it!

ikopanas · December 5, 2019, 8:22am

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?

Ratslinger · January 19, 2020, 2:17pm

@ikopanas,

Sorry for this extremely late reply. Unfortunately the notifications on his site are not working correctly. It is only because of a recent question I found this.

If this question is still outstanding to you, please ask as a new question. This is a question and answer site. Additional questions get buried from others searching for the answer.