🚀 go-pugleaf

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@mblsoft.com> wrote in message
news:44dcfb51$1@newsgroups.borland.com...
> 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@microps.com> wrote in message
> news:44dccc95$1@newsgroups.borland.com...
> > Mehmet F. Erten wrote:
> >> 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.
> >
> > It never should drop rows due to closing or opening..
> >
> > But
> >> I also do not get any Exception (if any reason these rows or this table
> >> are locked.
> >
> > That is not applicable to the QueryDataSet..  The QDS is an in memory
> > table and is not connected to the database.. (Provide/Resolve model) so
> > locking does not apply.
> >
> >> 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.
> >
> > It should stay.. (based on what you have said..)
> >
> >>
> >>
> >>
> >>
> >
> >
> > -- 
> > =============================================
> > 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
> > ====================================================
>
>