• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

RowCount in FilteredRowSet

 
Feyna Reendrina
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i want to make the table model using FilteredRowSet, but i have some problem to get row count...

method size of FilteredRowSet, can not be used!! beacuse it will be return count of record in FilteredRowSet that inserted and deleted....

what i want is to get count of active record (no deleted record)...

i using this script to claculate...
but it will be always SQLException when reach the last record, if i delete the last record!!

 
Shailesh Chandra
Ranch Hand
Posts: 1082
Java Oracle Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I haven't use FilteredRowSet, only I can suggest as of now you keep a counter in your program, whenever you delete a row increment the counter.
So at any point of time you can get active rows as crs.size() - deletedRows

Shailesh
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic