Datawindow column change after database change
Posted on 2004-08-18
I have Powerbuilder 5.0 using a database in PostgreSQL. I have a datawindow column whose field width I set to 15 during creation. Now, I want to change it to 100. I can make this change on the database side, but the datawindow does not get updated with this. I tried to 'regenerate' the datawindow, but the change still does not take place. I also have the setting 'Retain Data to Design' checked on in the DataWindow options.
When I try to set the field value to something containing more than 15 characters, for the first time, it adds it. But when I try to add a second such value, it gives me the error that says 'Error Number 6. Error text = Invalid DataWindow row/column specified.' and it gives me the name of the object, function and line in script where it has a problem.
Is it even possible to make the field length change without creating a new datawindow? Incidentally, this works fine, without problem when a Oracle database is used.
Thanks in advance.