prepareCall

Edson Richter - Via Ápia richter at viaapia.com.br
Wed Aug 9 18:39:22 EDT 2000


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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.ibiblio.org/pipermail/freetds/attachments/20000809/17637b26/attachment.html 


More information about the FreeTDS mailing list