Qt4: How to use Stored Procedures?

[jacek]

how can i use Stored Procedures in Qt4?

Everything depends on the database you use.

http://doc.trolltech.com/4.1/sql-dri...cedure-support

Or is there a way to do this without Stored Procedures?

I don't use MySQL, but in PostgreSQL you can do it like this:

INSERT ...;
SELECT currval( 'sequence_name' );

INSERT ...;
SELECT currval( 'sequence_name' );

To copy to clipboard, switch view to plain text mode 

Maybe MySQL has a similar method, for example using @variables?

Anyway creating stored procedures for common queries might reduce the number of mistakes and increase performance.