Subject RE: [IBO] Re: TIBOQuery Problem
Author Jason Wharton
Post date 2019-03-26T18:54:27Z
Jack,
 
I will take a closer look at this.  If possible, send me a little sample app just in case it has something to do with your environment.  If you send me something that doesn't work for you, and then it works for me, I'll have some surety that there is more going on we will need to look into.
 
Thanks,
Jason Wharton
 

From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]
Sent: Tuesday, March 26, 2019 10:41 AM
To: IBObjects@yahoogroups.com
Subject: [IBO] Re: TIBOQuery Problem

 

It appears if an 'append' has ever occurred on the TiboQuery, 'delete' will only be successful if the TiboQuery has been closed and reopened before the 'delete'.  This may be how it is designed to work, or it may be a bug.

Starting the program, TiboDatabase set to 'AutoCommit',   using the following steps:

1.  Clean database, open TiboQuery, write data, delete data:    fails.       

2.  Data in database, open TiboQuery, delete data:   works.

3.  Data in database, open TiboQuery, delete data, write data, delete data: fails. 

4.  Open TiboQuery, write data, close TiboQuery, open TiboQuery, delete data:  works.

5.  Clean database, open TiboQueryW, write data, do not close TiboQueryW, open TiboQueryD, delete data: works because it is through a different TiboQuery.