Subject | RE: [IBO] Re: TIBOQuery Problem |
---|---|
Author | Jason Wharton |
Post date | 2019-03-26T18:54:27Z |
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.