How to know the number of affected rows using the command Ex

[artu01]

Hi guys:

I want to capture the affected rows after using the command execute

Code: Select all  Expand view

  cSQL := " insert into detguiad (codusu, numero, articu, cantid, precio, total, subart, igv, totfac, mts) "  
  cSQL += " select codusu, numero, articu, cantid, precio, total, subart, igv, totfac, mts from #ppru "  
  Try
      oConnect:Execute( cSQL )
  Catch
      MsgInfo( "fallo en la insercion de detalle" )
  End try

 

Thanks

[nageswaragunupudi]

If you are asking about ADO

Code: Select all  Expand view

nRecs := 0
oCn:Execute( cSql, @nRecs )
? nRecs
 

[byron.hopp]

Thank you Mr. Rau,

I found the wrong answer on "Stack Overflow".
I think the smart guys are over here.

Byron ...