StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POusing Qt Stored procedure in Firebird
primarykey
Id
6299808
data
AcceptedAnswerId
0
AnswerCount
3
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2011-06-09T21:57:28.933
FavoriteCount
0
LastActivityDate
2017-07-07T20:21:53.150
LastEditDate
2011-07-19T20:01:22.910
LastEditorUserId
87736
OwnerUserId
76370
ParentId
0
PostTypeId
1
Score
3
ViewCount
1033
LastEditorDisplayName
text
Body
Good Afternoon, I'm starting in the world of Qt and a Firebird database.And finish the driver installation process and perform operations onthe database insert, update and consultation. When I started to make stored procedures and run them from Qt did not work. Does not fail and always us that everything was made perfect, but the database does not run. I am programming in Linux using Qt 2.0.1 and Firebird 2.1 I create a simple stored procedure test which makes it an insert into a table. It works by running the console but when trying to run fromQt does not work and gives me no errors.The SQL code is: <pre><code>SET TERM ^ ;CREATE PROCEDURE AGREEGAR_UNO AS BEGIN insert into JUEGO(CODIGO,ESCRUTINIO,ESTADO,FECHA,HORAINICIO) values (next value for GNECODIGOJUEGO,'111,123,154,169,178','Hi', current_date, current_time);END^SET TERM ; ^ GRANT EXECUTE ON PROCEDURE AGREEGAR_UNO TO SYSDBA; </code></pre> The following code will use to connect to firebird from Qt <pre><code>bool VentanaPrueba::conectar() { this->db= QSqlDatabase::addDatabase("QIBASE","Data"); this->db.setDatabaseName("./BD/Data.fdb"); this->db.setPassword("password"); this->db.setUserName("SYSDBA"); if(!db.open()) { return false; } else return true; } </code></pre> And this is the code that is responsible for calling the procedure <pre><code>void VentanaPrueba::procedimiento() { if (!this->db.isOpen()) this->conectar(); if(this->db.isOpen()) { QSqlQuery procedimiento = QSqlQuery::QSqlQuery(this->db); bool bandera = procedimiento.prepare("EXECUTE PROCEDURE AGREEGAR_UNO"); QString err = procedimiento.lastError().text(); bool respuesta= procedimiento.exec(); //this->db.commit(); if(!respuesta) { this->db.close(); }else { procedimiento.finish(); this->db.commit(); this->db.close(); } }else{ //error } } </code></pre> Thank you very much for your help.
Tags
<plsql><qt-creator><firebird><firebird2.1>
Title
using Qt Stored procedure in Firebird
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USHugues Van Landeghem
UserOwnerUserId
1. USOzplc
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POusing Qt Stored procedure in Firebird
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.