We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Base: Call a MySQL Database Stored Procedure

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

ikopanas gravatar image

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

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

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

Ratslinger gravatar image


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


Thanks for the help! Really appreciate it!

ikopanas gravatar imageikopanas ( 2019-12-03 22:30:04 +0200 )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 +0200 )edit


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.

Ratslinger gravatar imageRatslinger ( 2020-01-19 15:17:25 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 285 times

Last updated: Dec 03 '19