I have a datawindow select data from a table from SQL DB.
Whenerer I try to simply select an additional column in datawindow data source (TSQL select) or even just edit the SQL where clause that change nothing on columns.
"The action just taken has forced the preview view to be rebuilt. You may need to re-retrieve your data" occured and all my existing columns are recreated. It is annoying that all columns are rebuilt (except computed fields). Wiping all formats and column orders. This is really counter-productive and not tolerable.
In PB10, the datawindow rebuilt involved only the newly added column, it automatically appends to the end of the existing columns. And if changes are where clause only, nothing happen to the columns at all. Can anyone enlighten me how do I have it back?