prepareCall
Edson Richter - Via Ápia
richter at viaapia.com.br
Wed Aug 9 19:18:36 EDT 2000
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.ibiblio.org/pipermail/freetds/attachments/20000809/e2825310/attachment.html
More information about the FreeTDS
mailing list