FiveTech Software tech support forums • View topic - How to know the number of affected rows using the command Ex

Page 1 of 1

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

Posted: Tue Jan 14, 2020 5:59 pm

by 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

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

Posted: Tue Jan 14, 2020 8:13 pm

by nageswaragunupudi

If you are asking about ADO

Code: Select all Expand view: nRecs := 0 oCn:Execute( cSql, @nRecs ) ? nRecs

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

Posted: Wed May 27, 2020 7:21 pm

by byron.hopp

Thank you Mr. Rau,

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

Byron ...