FiveTech Software tech support forums

Posted: **Tue Jan 14, 2020 5:59 pm**

Hi guys:

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

  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

Posted: **Tue Jan 14, 2020 8:13 pm**

If you are asking about ADO

Code: Select all

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

Posted: **Wed May 27, 2020 7:21 pm**

Thank you Mr. Rau,

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

Byron ...

FiveTech Software tech support forums

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

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

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

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