Have you done an edit source and only changed the SQL Select before?

The definition of the db columnnames that will be updated or inserted are not part a of the SQL Select Statement.

The corresponding database colomnnames are stored as properties of the column definitions.

You can try to use edit source, search for the specific columnname and will understand what I mean.

Normally the PowerBuilder Datawindow Painter should not create such differences/anomalies.

hth

Arnd

Here an example:

SELECT:

SELECT description into :ls_descrition from log;    --> ok

SELECT descrition into :ls_descrition from log;   --> Database  C0038: SQLSTATE = S0002[SAP][ODBC DRIVER][SQL ANYWHERE]Column 'descrition' not found

UPDATE:

Update log set description = 'Test';              --> ok

Update log set descrition = 'Test';                 --> Not ok but no error message

Why there's no error message "-->Database  C0038: SQLSTATE = S0002[SAP][ODBC DRIVER][SQL ANYWHERE]Column 'descrition' not found"?

Hi Roy,

as long as the column is not involved in an INSERT or UPDATE statement.
Why should there be an error?

hth

Arnd