| Subject | Re: [IBO] Re: TiboQuery 10.3 Issue |
|---|---|
| Author | Jack Mason |
| Post date | 2019-04-02T14:08:11Z |
Thanks, Jason.
It was quite baffling. But, with all the other 10.3 issues, it makes sense that the way it suddenly began working after restarting 10.3 where the issue lies.
Delphi 7 does not have nearly the problems 10.3 has. While one can appreciate Embarcadero expanding across IOS and Androids and including a non-VCL capability, it is surprising they have not provided at least a solid development environment.
For the other problem, it appears if an 'append' has ever occurred on the TiboQuery, 'delete' will only be successful if the TiboQuery is closed and then reopened. 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. (seems like this should work)
2. Data in database, open TiboQuery, delete data: works.
3. Data in database, open TiboQuery, delete data, write data, delete data: fails. (seems like this should work)
4. Open TiboQuery, write data, close TiboQuery, open TiboQuery, delete data: works.
5. Clean database, open TiboQueryW to write data, do not close TiboQueryW, open TiboQueryD, delete data: works.
I will post this info as well.
Jack
It was quite baffling. But, with all the other 10.3 issues, it makes sense that the way it suddenly began working after restarting 10.3 where the issue lies.
Delphi 7 does not have nearly the problems 10.3 has. While one can appreciate Embarcadero expanding across IOS and Androids and including a non-VCL capability, it is surprising they have not provided at least a solid development environment.
For the other problem, it appears if an 'append' has ever occurred on the TiboQuery, 'delete' will only be successful if the TiboQuery is closed and then reopened. 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. (seems like this should work)
2. Data in database, open TiboQuery, delete data: works.
3. Data in database, open TiboQuery, delete data, write data, delete data: fails. (seems like this should work)
4. Open TiboQuery, write data, close TiboQuery, open TiboQuery, delete data: works.
5. Clean database, open TiboQueryW to write data, do not close TiboQueryW, open TiboQueryD, delete data: works.
I will post this info as well.
Jack
On 3/26/2019 11:23 AM, 'Jason Wharton'
jason@... [IBObjects] wrote:
Great to hear you got it resolved. I wasn't sure what to say to help you.Cheers,Jason Wharton
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]
Sent: Tuesday, March 26, 2019 9:16 AM
To: IBObjects@yahoogroups.com
Subject: [IBO] Re: TiboQuery 10.3 Issue
This issue is resolved, although not understood. After exiting 10.3 and opening 10.3 the following morning, the TiboQuery now prepares and connects. This appears to be a 10.3 problem (not the first by a rather large number).