🚀 go-pugleaf

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
> ====================================================