How to parse ALL table aliases, even if multiple queries are provided

The offical for ZeosLib 7.3 Report problems, ask for help, post proposals for the new version of Zeoslib 7.3/v8
Quick Info:
-We made two new drivers: odbc(raw and unicode version) and oledb
-GUID domain/field-defined support for FB
-extended error infos of Firebird
-performance ups are still in queue
In future some more feature will arrive, so stay tuned and don't hassitate to help
Post Reply
User avatar
aehimself
Zeos Dev Team
Zeos Dev Team
Posts: 797
Joined: 18.11.2018, 17:37
Location: Hungary

How to parse ALL table aliases, even if multiple queries are provided

Post by aehimself »

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.
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
marsupilami
Platinum Boarder
Platinum Boarder
Posts: 1956
Joined: 17.01.2011, 14:17

Re: How to parse ALL table aliases, even if multiple queries are provided

Post by marsupilami »

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
User avatar
aehimself
Zeos Dev Team
Zeos Dev Team
Posts: 797
Joined: 18.11.2018, 17:37
Location: Hungary

Re: How to parse ALL table aliases, even if multiple queries are provided

Post by aehimself »

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
marsupilami
Platinum Boarder
Platinum Boarder
Posts: 1956
Joined: 17.01.2011, 14:17

Re: How to parse ALL table aliases, even if multiple queries are provided

Post by marsupilami »

Merged. Sorry for the delay.
Post Reply