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