🚀 go-pugleaf

It is kind of hard to tell specifically what you are doing and you may 
be leaving out critical information.. But..

dataset.cancel()  only cancels edits to a new or existing record. (see 
documentation)  So if you are putting in multiple rows the cancel will 
only work on the LAST row entered.

If you have multiple rows, you would then need to deleteAllRows();

Are you using a TableDataSet or a QueryDataSet for this..???



Mehmet F. Erten wrote:
>    In the same program I use the same table as a work table more than once 
> (a few times) only this one fails for a reason.
> 
>    Even after the cancel() and close() it keeps the rows in it.
>    No clue.
>    So I rely on the old fashioned way: deleteAllRows() if getRowCount()
> 
>     first cycle false, true, 0
>     but the second cycle should be true, false, 0 but it is as follows:
> 
>     System.out.println(dataSet.isOpen());  ===> true
>     if (dataSet.isOpen())
>     {
>       dataSet.cancel();
>       dataSet.close();
>     }
>     System.out.println(dataSet.isOpen());  ====> false
>     dataSet.open();
>     System.out.println(dataSet.getRowCount()); ====> 2 
> 
> 


-- 
=============================================
TeamB are volunteer helpers.  Please DO NOT REPLY VIA EMAIL!
Post all questions and replies to this newsgroup ONLY
For papers on DataExpress, Applets, JSP, and Web Development go to:
http://www.microps.com/mps/paperFAQ.html
====================================================