« previous next »
Pages: [1]   Go Down

Author Topic: MySQL stored procedure  (Read 2410 times)

0 Members and 1 Guest are viewing this topic.

Offline MLambert

  • Forum Regular
  • Posts: 115
    • View Profile
MySQL stored procedure
« on: March 28, 2019, 08:32:56 pm »
Hi
Does anyone have an example of executing a stored procedure from QB64 ?
Thks
Logged

Offline Ashish

  • Forum Resident
  • Posts: 630
  • Never Give Up!
    • View Profile
Re: MySQL stored procedure
« Reply #1 on: March 29, 2019, 11:09:04 am »
Hi MLambert!
MySQL related procedure is explained very neatly here -
http://qb64.org/wiki/SQL_Client
Logged
if (Me.success) {Me.improve()} else {Me.tryAgain()}


My Projects - https://github.com/AshishKingdom?tab=repositories
OpenGL tutorials - https://ashishkingdom.github.io/OpenGL-Tutorials

Offline MLambert

  • Forum Regular
  • Posts: 115
    • View Profile
Re: MySQL stored procedure
« Reply #2 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.
Logged

Offline Ashish

  • Forum Resident
  • Posts: 630
  • Never Give Up!
    • View Profile
Re: MySQL stored procedure
« Reply #3 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.
Logged
if (Me.success) {Me.improve()} else {Me.tryAgain()}


My Projects - https://github.com/AshishKingdom?tab=repositories
OpenGL tutorials - https://ashishkingdom.github.io/OpenGL-Tutorials

Offline MLambert

  • Forum Regular
  • Posts: 115
    • View Profile
Re: MySQL stored procedure
« Reply #4 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
Logged
Pages: [1]   Go Up
« previous next »