🚀 go-pugleaf

Ivan,

    Actually I rarely use the ProcedureDataSet.. Mostly because it is 
overkill for much of my use..


I would check out the help docs section..

"Stored procedures: hints & tips"

There was some examples there as well as a pointer to a sample program..


When I have needed data from a stored proc with parameters AND I want it 
to end up in a DX component.. I generally do the following.. (I don't do 
any GUI so that has never been an issue for me..)


      String _sql = "{call sp_do_financecharge(?,?,?,?)}";
      java.sql.CallableStatement _statement = null;
      _statement = this.g_con.prepareCall(_sql);
      _statement.setDouble(1,Double.parseDouble(arg_sRate));
      _statement.setDouble(2,Double.parseDouble(arg_sMinChg));
      _statement.setString(3,arg_sChgDate);
      _statement.setString(4,arg_sPeriod);
      ResultSet _rs = _statement.executeQuery();
      if (_rs != null) {
          QueryDataSet _qds = null;
          try {
            _qds = (QueryDataSet)this.g_database.resultSetToDataSet(new 
QueryDataSet(), _rs);
            return _qds;
          } finally {
            if ( (_qds != null) && (_qds.isOpen()) ) {
              _qds.close();
            }
            _qds = null;
          }
      } else {
          return null;
      }





ivan.lusavec@inet.hr wrote:
> Hi.I have a problem with passing input parameters to Firebird procedure, 
> more exactly I don't know how to do it at all with dataexpress components.I 
> used procedures succesfully when there are no input parameters, although the 
> query string is very strange, I just put name of select procedure and it is 
> working.No "select * from procedurename", just "procedurename", so does 
> someone now how to add a parameter to call.I am just interested in right 
> syntax, I will find my way with setting parameter with parameterRow...That's 
> my problem....how to paramaterize call...bye... 
> 
> 

-- 
=============================================
TeamB are volunteer helpers.  Please DO NOT REPLY VIA EMAIL!
Post all questions and replies to this newsgroup ONLY
For papers on DataExpress, Applets, JSP, and Web Development go to:
http://www.microps.com/mps/paperFAQ.html
====================================================