How EXECUTE STORED , with TIBconnection ?
lazarus / 16-Databases

----------------------------------------------------------------------
Fortuna1 · 2012-05-18 17:11

I try these.  What is wrong?;

     SQLQuery1.Close;
       SQLQuery1.SQL.Text:='EXECUTE PROCEDURE procSAMPLE ';
       SQLQuery1.ExecSQL;

      SQLTransaction1.CommitRetaining; 


This not EXECUTE, not OK.

----------------------------------------------------------------------
ludob · 2012-05-18 17:15

What is the error message?
What is the definition of procSAMPLE? Does it require parameters?
Do you have sufficient rights to execute the procedure?

----------------------------------------------------------------------
Fortuna1 · 2012-05-18 17:33

he enjoys all rights.

And I don't get any message. 


and these work ok.
IBConnection.ExecuteDirect('EXECUTE PROCEDURE procSAMPLE');
These Execute OK.

But i have problem in next sql update  then 1 get message
                                      (update conflict with concurret
update)


Tested in lazarus 0.9.31
and  lazarus  1.1

----------------------------------------------------------------------
ludob · 2012-05-18 18:11

QuoteBut i have problem in next sql update  then 1 get message
                                      (update conflict with concurret
update)
Are you using more than one IBConnection to work on the same data? The
stored procedure perhaps modifies a table that is updated in another
transaction. Without more information this is only guessing.

A priori, IBConnection.ExecuteDirect('EXECUTE PROCEDURE procSAMPLE'); 
 and SQLQuery1.SQL.Text:='EXECUTE PROCEDURE procSAMPLE ';
SQLQuery1.ExecSQL; do the same, if SQLQuery1 uses IBConnection.

----------------------------------------------------------------------
Fortuna1 · 2012-05-21 04:39

Thans.
Now  work all samples.