Hi guys,
I have some dynamic windows that rely on the dataWindow's columns' "db Name" property, to create dynamic filters. This has been working for quite some time, but now, for some reason that I can't grasp, the table name's are being removed from the columns db name (when I edit the DWs SQL), and so my filters are faltering.
This is an example:
I have a dw, with a multi table SQL. Prior, the db name property would be "products.product_id", but now, if I do any editting to the dw's sql, PB removes the "products." from the column's db name, and my program stops working.
How can I prevent this? I looked at my connection properties, but couldn't find one to resolve this.
I'm using PB 19 and PB 22, and the same thing is happening on both, maybe it was after I installed PB 22, but I'm not sure.
The PB IDE connects to a local MySQL 8 DB using ODBC 32 bits, using MySQL 8.0 ANSI driver.
Please advice and let me know if you need additional information.
Thanks a lot.
Pic1: how it used to be
Pic2: How it is now
Pic3: PB's ODBC
Pic4: Windows ODBC