Hi Cynthia;

  Since you have not given us much information to go on for this posting (Error #, DBMS type, Connection Type, SQL Syntax, Table specification, etc)... It's hard to say.

  My guess is that the DWO's column names do not match the corresponding Table(s) column names. Were there schema changes recently?

Regards ... Chris

I am migrating a PowerBuilder 9.0.3 application to PowerBuilder 2019. There is a possibility that the columns have changed.

We now use SQL Server 2012, SQL Server Native Client 11.0.

Here is exactly how the PowerBuilder error window is displayed:  DataWindow Error (in the header)  Select Error: Column lists do not match.

Here is the database table info. The column in question is PLAN_SEQ(PK, numeric(3,0), not null)

Table PMTLACST

Column Name     DataType

PLAN_SEQ          numeric(3, 0)

Export snippet from the datawindow

table(

column=(type=decimal(0) updatewhereclause=yes name=plan_seq dbname="PMTLACST.PLAN_SEQ" )

**The datawindow does a select for several other columns from other tables. However, they all match. This is the only column in question.

Just realized that I can add a PDF file.  Attached

You should also consider running a trace of the database when the DW retrieve is executed.  This will show exactly the SQL which is sent to the DB.