🚀 go-pugleaf

Mehmet F. Erten wrote:
> John,
> Don't forget this table usage.

I understand..

> It is a work table, never saved.

That is why I asked if it was a QueryDataSet or a TableDataSet..

In your case you should be using a TableDataSet, you are miss using the 
tools.. (Using a hammer to put on masking tape...<G>)


> It is always empty in the database.

Why is that table even there..<G>

> if I close and open it (no where clause) it will bring nothing since there 
> is no record in it.

Hence the TableDataSet should be used..

For the QueryDataSet you should set to false the "execute on open" 
(executeOnOpen) flag of the QueryDescriptor(...)

On the other hand this is what probably makes you think that opening the 
QDS is emptying it..  It is in the sense that you are doing a re-query, 
but that is a very bad waste of bandwidth to the data server..

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

Only if the executeOnOpen flag is set to true..

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


As I said before I still think you should be using the TableDataSet for 
this task..


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


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