Ugh.

Option 1:
The best way I've found to do this is to, such as it is, it to hit each DW that contains the column to be changed one at a time.
Use EDIT SOURCE on the datawindow, FIND the column, then manually change the "(50)" to "(100)".

Yeah, that really sucks. But it's safe and it's accurate.

Option 2:
Purchase a copy of PBSearch from TopWiz:  http://www.topwizprogramming.com/pbsearch.html
It's a great tool and very much worth the cost.

At the very least, you can search the entire application in one go with this tool, then use the steps in option 1 with the REPLACE TEXT option:


There may be a way do mass changes, but I don't know it. Email Roland and ask him. Roland@topwizprogramming.com


Good Luck,

Olan

When you make table schema changes it requires the corresponding datawindows to be updated. Typically we open the dw, make a a "no change" change on the datasource sql side like typing in a space and deleting it (we always convert all data sources to SQL Statements) then it updates the length in the dw. You may still need to widen the field in itself as well as modify the max number of characters allowed (if not using the default 0). The moral of the story, minimize schema changes.

If you work with PB 2017 R2 and native source control (e.g. git) you can use any tool to search/replace the source files in the file system and do a refresh from the system tree.

Regards
Arthur