#33 No rowcount returned on update

v1.0 (example)
closed-works-for-me
5
2013-06-13
2011-03-29
Swifty
No

The operation:
RC = SQLCommand('U','Update table set A=1 where B=1')
Doesn't return any way to determine the number of rows that were updated.
I would have expected SQLCA.ROWCOUNT to contain this value, but it is not set.

Discussion

  • Mark Hessling

    Mark Hessling - 2013-06-13
    • status: open --> closed-works-for-me
    • Group: --> v1.0 (example)
     
  • Mark Hessling

    Mark Hessling - 2013-06-13

    Tested with v2.6 using SQLite3, Oracle and MySQL. All work as expected. Check if sqlvariable( 'SUPPORTSDMLROWCOUNT' ) = 1, otherwise sqlca.rowcount won't be updated after an UPDATE statement.

     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks