Skip to Content.
Sympa Menu

freetds - RE: prepareCall

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Edson Richter - Via Ápia <richter AT viaapia.com.br>
  • To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
  • Subject: RE: prepareCall
  • Date: Wed, 9 Aug 2000 20:18:36 -0300

Ooops!!! I see: executeUpdate cannot return result sets...
 
And this is why I can't get nRecords with any value...
 
Excuse me by my stupid mail...
 
Thanks to all,
 
Edson Richter
 
-----Original Message-----
From: bounce-freetds-110692 AT franklin.oit.unc.edu [mailto:bounce-freetds-110692 AT franklin.oit.unc.edu]On Behalf Of Edson Richter - Via Ápia
Sent: Quarta-feira, 9 de Agosto de 2000 19:39
To: TDS Development Group
Subject: [freetds] prepareCall

Server: MSSQL 7 SP2
FreeTDS version: Who knows??? Some snapshot from CVS tree at some time in the past (earlier than 0.50).
Java version: JDK 1.3
Operating System: NT 4.0 SP5
 
I'm using prepare call to execute a StoredProcedure.
At the end of StoredProcedure execution I have 3 results, as I can see into SQL Query Analizer:
 
Query:
 
execute PR_DELUsuario 1, 2
 
 
Result obtained:
 
result
------
S
 
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
 
If I use
 
            call = conn.prepareCall( "PR_DELUsuario ?, ?" );
            call.setString( 1, user );
            call.setString( 2, codigo );
            nRecords = call.executeUpdate( );
 
nRecords should not reports "1"???
 
Thanks!!!
 
Edson Richter
 


  • prepareCall, Edson Richter - Via Ápia, 08/09/2000
    • <Possible follow-up(s)>
    • RE: prepareCall, Edson Richter - Via Ápia, 08/09/2000

Archive powered by MHonArc 2.6.24.

Top of Page