If you change your database column datatypes and have existing datawindows, they do not recognise the change automatically.

To get the datawindow to update without rebuilding it simply edit the sql and add a sort column then remove it.

This forces the datawindow to refresh itself as it thinks the select has changed. To check the results use the Rows->Column Specification menu item to double check your new datatypes.