Hi Community,
this is my first time working on datawindow crosstab. I encountered that the datawindow will lost all the formatting after editing on the data source.
Is there anyway, i can prevent the format getting reset after inserting additional columns to "row"
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).