| Subject | RE: [IBO] Query with params returning incorrect results when app runs in background |
|---|---|
| Author | Jason Wharton |
| Post date | 2018-10-30T23:27:38Z |
This could cause an entirely new query of SELECT COUNT( *
)... to be submitted to the server. Better to avoid
that.
And, evidently, because I use the Execute Immediate API calls, it is possible to run into some problems with InterBase because it seems to pehaps have some bugs in those less commonly used API calls.
Kind regards,
Jason Wharton
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]
Sent: Tuesday, October 30, 2018 7:59 AM
To: IBObjects@yahoogroups.com
Subject: RE: [IBO] Query with params returning incorrect results when app runs in background
I assume you are hinting at the fact that it can be an expensive operation. In this particular scenario, the query should only return 0 or 1 records so that should not matter, but point noted.