1. Daniel Ferrreira
  2. PowerBuilder
  3. Wednesday, 18 January 2023 15:52 PM UTC

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

Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 18 January 2023 18:53 PM UTC
  2. PowerBuilder
  3. # 1

Hi Daniel;

  FYI: From the PB documentation ... " PowerBuilder apps can connect with the MySQL (32-bit and 64-bit) database through the MySQL ODBC Unicode Driver (but not the ANSI Driver). "

Regards ... Chris

Comment
There are no comments made yet.
Daniel Ferrreira Accepted Answer Pending Moderation
  1. Wednesday, 18 January 2023 20:07 PM UTC
  2. PowerBuilder
  3. # 2

Hi Miguel,

sorry, what I meant was that I have windows that create dynamic filters, based on the datawindow column's db name. I do have dynamic dataWindows, that use syntaxFromSQL, but that's not the issue. I'm trying to get the "table.column" db name back, as it used to be, otherwise this change of behavior will have a deep impact on a very complex generic filter window.

Thanks and regards.

Comment
  1. Miguel Leeuwe
  2. Wednesday, 18 January 2023 20:54 PM UTC
Hi, what Chris is saying might be worth investigating. See if happens or net when using MySQL ODBC Unicode or not.

Try to make a small app in 2017 or earlier, migrate and do an edit of the SQL. If it's reproducable make make a bug/ticket.
  1. Helpful 1
There are no comments made yet.
Daniel Ferrreira Accepted Answer Pending Moderation
  1. Wednesday, 18 January 2023 20:22 PM UTC
  2. PowerBuilder
  3. # 3

Hi Chris,

Sorry, changing to the UNICODE driver had no impact. I tried changing an existing dw, as well as creating a new one, and on both scenarios, the db name was without the table name, just like a regular dw column name. I have no idea what the impact on my app would be though, if the unicode version had indeed worked. This is an ERP that has been around since PB8 I think, before the ANSI/Unicode version existed.

I'll try different ODBC options, and a MySQL 5 driver alson, see if any of them have any impact.

Thanks.

 EDIT: Changing to MySQL 5.3 ANSI driver DID get the table names back!!!! Thanks, I'll stick with that for now, gotta release it, this is a major version for us.

Comment
  1. Chris Pollach @Appeon
  2. Wednesday, 18 January 2023 21:15 PM UTC
Hi Daniel;

That's great news as a workaround for the moment! :-)

There could be an ODBC driver option though for the table name behaviour. It might be a configuration setting of a runtime setting controlled by a DBParm value (just a guess). I would suggest that you read the MySQL ODBC client driver set-up documentation or contact MySQL technical support for more details. HTH

Regards ... Chris
  1. Helpful 1
There are no comments made yet.
Daniel Ferrreira Accepted Answer Pending Moderation
  1. Wednesday, 18 January 2023 20:11 PM UTC
  2. PowerBuilder
  3. # 4

Hi Chris,

So you think PB gets/sets the dataWindow DB Name from the DB Driver? I haven't updated the driver, but I'll try an unicode version. I have always used the ANSI version, but sure, I'll give it a try.

Thanks.

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.