If you do edit in source mode, you'll also need to create the new column objects to hold the data for the new columns you place in the sql. These objectes are ABOVE the sql source statement and look like this:





column=(type=datetime updatewhereclause=yes name=dttmentered dbname="alerts.dttmentered" )





Where:





type matches a PB datatype: char(n), long, char(32766) for long varchar field, decimal(n) for numerics with decimal places. Take a look at other columns in the datawindow you're editing (or others) if you need clarity on data types.

name is a field name you can recognize later

dbname is the associated table & column that you added to the select statment. If it's a computed column, it is be column name only without an associated table. There is no table name when select is for a single table.

Crosstabs are non-updateable, the updatewhereclause is just a placeholder, but needs to be there





Aways add new columns at the end of the select statement so that ID references in the visible column objects stay the same (otherwise you'll end up with your data showing up in the wrong places).

deleted as duplicate