How to update a dynamic datawindow in PB 5
Posted on 2004-03-24
I have a table that stores the column names and titles of the respective columns that are used for a survey. I then proceeded to build a tabular datawindow that retrieves these column names and their titles. So far, o.k.
Now I have a function that gets the names of the columns and their titles from the datawindow that I build and proceeds to construct a SQL to create the Dynamic Datawindow. I create the Dynamic Datawindow without problems. However, I can't update data in the Dynamic Datawindow. I noticed that the dbnames assigned by PB were different from the real ones (compute_0005, etc.) so I did a modify to assign the real ones. I did modifies for column.update=yes. Also, I even try to make the dynamic dw (dw_1) updatable using dw_1.of_SetUpdatable (TRUE). I can trace it going through the pfc_update but even if everything appears o.k. it doesn't save.
Any help is appreciated. Thanks.