Prepared Statements And Stored Procedures

Asked Jul 12 '12 at 10:12

Active Jul 12 '12 at 10:14

Viewed 517 times

I currentrly have to face this problem. Since the post is nearly 4 years old, is there a solution for this now?

Short summary:

In Qt, you can prepare and execute a statement for MySQL which calls a stored procedure with some placeholders, but you cannot fetch the result in any way. Additionally you can only execute such a statement once, the second time you will get a "Commands out of sync" error witch indicates that there is a result, but has not been fetched yet, in my understanding.

edited Jul 12 '12 at 10:14

Filburt

17,626
12
64
115

asked Jul 12 '12 at 10:12

SteakOverflow

1,953
13
26

Please add a small self-contained *single file* (main.cpp only) example that opens an empty database, creates a stored procedure, and then calls it. Otherwise we'll be just doing your homework for you. – Kuba hasn't forgotten Monica Sep 24 '13 at 19:26
base on your link why dont use a variable inside qt? – reggie Aug 11 '14 at 01:40
What are the connector? do you have sample code? – Ivan Cachicatari Sep 30 '14 at 14:22

Prepared Statements And Stored Procedures

0 Answers0