FreeTDS Development Group

[Edson Richter - Via Ápia <richter AT viaapia.com.br>]

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