-
Daniel Vivier
- PowerBuilder
- Tuesday, 8 February 2022 10:07 PM UTC
This is in PB2019 Build 2082, using the Firebird SQL Database.
We have one user’s database from our application that is behaving extremely strangely for certain SQL retrieved through a datastore created at runtime (actually, our inherited datastore object, with a dberror event script). The datastore is created via SyntaxFromSQL and CREATE.
For this one user’s DB, a Retrieve on that created datastore returns -15448 (not the only documented error return of -1!) and does not trigger the dberror event at all.
We can run the same SQL that is giving this Retrieve error return value with no problem with an external tool for accessing Firebird (FlameRobin), or in the Database Painter.
One other bizarre thing: although we have no known problems with JOIN clauses in Firebird or PB or our application for any other user, the problem SQL includes a JOIN, and if we replace that with old-style SQL (like SELECT ... FROM table1, table2 WHERE table1.joincolumn = table2.joincolumn AND ...) the problem goes away!
Here's a super-simple variation of the SQL the user originally had the problem with, that still gives the same problem:
SELECT (donor.last_name) "Name"
FROM constants co
JOIN donor on co.year_number = donor.year_number
ORDER BY donor.last_name
Any bright ideas? Thanks.
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.