The default behavior of PowerBuilder is that is you only have ONE table selected when creating your datawindow, the columns will NOT have pre-pended table_names and the column names will be <column_name>.

If you specify two or more tables when creating your datawindow, then the columns WILL have table_name prepended to the column name, such that the column name = <table name>_<column_name>. This sllows the code to know from which table each column was derived.

Here is a workaround syntax that I use for SQL Anywhere and may work with other DBMSs:

 SELECT <alias> = <column name>, ...

The column control in the DW will be named <alias>.

From your question, the example would be:

  SELECT owner_name = owner_name

  FROM all_owners

...

NOTE that the standard syntax "SELECT <column> AS <alias>" does NOT work.

Hello Brady,

a workaround would be manually editing the column names either via "edit source" or directly in the painter. If you do the former, note that the name will appear multiple times in the source code.

Hi Brady;

  If the DB user ID you use to log into your DBMS has the Database Owner "select" privileged, then the DW Painter will not use the Table Name in its generated SQL. The only exception to this rule is when you are performing a Table Join.

Regards ... Chris