QB64.org Forum

Active Forums => QB64 Discussion => Topic started by: MLambert on March 28, 2019, 08:32:56 pm

Title: MySQL stored procedure
Post by: MLambert on March 28, 2019, 08:32:56 pm

Hi
Does anyone have an example of executing a stored procedure from QB64 ?
Thks

Title: Re: MySQL stored procedure
Post by: Ashish on March 29, 2019, 11:09:04 am

Hi MLambert!
MySQL related procedure is explained very neatly here -
http://qb64.org/wiki/SQL_Client

Title: Re: MySQL stored procedure
Post by: MLambert on March 29, 2019, 07:36:52 pm

The way I read this example is that it shows you how to interface mysql and qb64... which i use. It does not have a reference to stored procedures.

Title: Re: MySQL stored procedure
Post by: Ashish on March 30, 2019, 09:47:23 am

Sorry then. I don't know how to do that. Maybe, there is a someone else who might know this.

Title: Re: MySQL stored procedure
Post by: MLambert on March 31, 2019, 07:53:17 pm

Hi Ashish,,

Worked it out ... just pass the full query including the exec command for the stored procedure to the DB_QUERY function

Mike

Text Only | Text with Attachments