BorlandTalk.com

Mehmet F. Erten · Guest

I use a work file: a table defined to open/insert but never save.
I migrated from JDataStore into InterBase now refresh or close/open does not
get rid off the current rows from the table.
If anyone knows why?
Thanks.

For now I will check the rowCount after the refresh or open to delete.

John Moore (TeamB) · Guest

Mehmet F. Erten wrote:

Mehmet F. Erten · Guest

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

Mehmet F. Erten · Guest

previuos results should be false, false, 0
true, false, 2 (which should be 0
after a close/open)

JBuilderX\jdk1.4\jre\lib\plugin.jar;C:\JBuilderX\jdk1.4\jre\lib\rt.jar;.......
-Xms256M -Xmx256M mbl.Application1
false

false

0

onePurchaseOrderEstimateDataSet: 0

TrueType font directory does not exist: c:/winnt/fonts

true

false

2

onePurchaseOrderEstimateDataSet: 2

John Moore (TeamB) · Guest

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:

Mehmet F. Erten · Guest

Hi,
I use QueryDataSet.
This was working OK with JDataStore.
And it works with InterBase in many other codes I have.
In this occation closing and opening again does not get rid of the rows. But
I also do not get any Exception (if any reason these rows or this table are
locked.
So I check row count and delete them all if there is any.
I am reading the table columns without any condition and since there is no
data, it should be empty all the time when I open or refresh it.
In this case, it is not, does not matter if refreshed or closed/opened the
previous rows stays.

John Moore (TeamB) · Guest

Mehmet F. Erten wrote:

Mehmet F. Erten · Guest

John,
Don't forget this table usage.
It is a work table, never saved.
It is always empty in the database.
if I close and open it (no where clause) it will bring nothing since there
is no record in it.
Later if I insert some rows, they will be in it until it is refreshed or
closed.
After whenever I open it, it should be again an empty table.
At this time I will stick to the workaround since it is an isoloated
incident (one program) and I won't spend any time to fix it (still I have to
discover a lot about InterBase as scheduled batch Backup: I will post this
in interbase.general)
Thanks for your help.

"John Moore (TeamB)" <jbm (AT) microps (DOT) com> wrote in message
news:44dccc95$1 (AT) newsgroups (DOT) borland.com...

John Moore (TeamB) · Guest

Mehmet F. Erten wrote:

Max-Ph. Blickenstorfer · Guest

Hi Mehmet,
As I read the thread it seems you dont't want to persist any changes to the
underlying db-table. Therefore, as John mentioned, you should use an plain
in-memory table to do the job. To me it looks not like a db problem, it's a
problem of data persistence, so strictly cache all changes on the client and
discard everything when done. So you possibly only need underlying metadata
from your db to create an in-memory worktable.
In case you work in a kind of briefcase model you automatically encounter
the expected behaving, as soon as you leave this model it seems to behave
unexpected since all changes are comited automatically by default.

Regards
Max

"Mehmet F. Erten" <mehmet_erten (AT) mblsoft (DOT) com> wrote in message
news:44dcfb51$1 (AT) newsgroups (DOT) borland.com...