Just an fyi, if someone is interested. I wrote a descendant of TZGenericStatementAnalyser which can parse all table aliases, even if multiple SQL commands are provided.
For the solution, you can visit this topic on DelphiPraxis, where the reason behind is also explained.
@ Jan,
If you think it has a place in TZGenericStatementAnalyser, this one method can also be added to the base class. If needed I can rework it to be D7 compatible.
How to parse ALL table aliases, even if multiple queries are provided
How to parse ALL table aliases, even if multiple queries are provided
Delphi 12.2, Zeos 8 from latest GIT snapshot
Using:
- MySQL server 8.0.18; libmysql.dll 8.0.40 x64 5.7.19 x68, libmariadb.dll 3.3.11
- Oracle server 11.2.0, 12.1.0, 19.0.0; oci.dll 21.15
- MSSQL 2012, 2019; sybdb.dll FreeTDS_3102
- SQLite 3.47
Using:
- MySQL server 8.0.18; libmysql.dll 8.0.40 x64 5.7.19 x68, libmariadb.dll 3.3.11
- Oracle server 11.2.0, 12.1.0, 19.0.0; oci.dll 21.15
- MSSQL 2012, 2019; sybdb.dll FreeTDS_3102
- SQLite 3.47
-
- Platinum Boarder
- Posts: 1956
- Joined: 17.01.2011, 14:17
Re: How to parse ALL table aliases, even if multiple queries are provided
Hello aehimself,
sure - we can include that. We just would need some documentation on it
Compatibility to Delphi 7 would be grat
Best regards,
Jan
sure - we can include that. We just would need some documentation on it
Compatibility to Delphi 7 would be grat
Best regards,
Jan
Re: How to parse ALL table aliases, even if multiple queries are provided
Fresh, ripe pull request available for picking! :)
Delphi 12.2, Zeos 8 from latest GIT snapshot
Using:
- MySQL server 8.0.18; libmysql.dll 8.0.40 x64 5.7.19 x68, libmariadb.dll 3.3.11
- Oracle server 11.2.0, 12.1.0, 19.0.0; oci.dll 21.15
- MSSQL 2012, 2019; sybdb.dll FreeTDS_3102
- SQLite 3.47
Using:
- MySQL server 8.0.18; libmysql.dll 8.0.40 x64 5.7.19 x68, libmariadb.dll 3.3.11
- Oracle server 11.2.0, 12.1.0, 19.0.0; oci.dll 21.15
- MSSQL 2012, 2019; sybdb.dll FreeTDS_3102
- SQLite 3.47
-
- Platinum Boarder
- Posts: 1956
- Joined: 17.01.2011, 14:17
Re: How to parse ALL table aliases, even if multiple queries are provided
Merged. Sorry for the delay.