Application was migrated to PB2017 R2 from PBuilder 9
DataBase Table defintion columnname "notes" datatype Text
PBuilder9 Datastore/Datawindow columnname "notes" datatype Char(4099).
PBuilder 9 display the "notes" value.
PBuilder 2017 R2 does not display the "notes" value.
Found two ways to fix this:
- change datasource the datasource is changed
e.g. convert( char(4099), orders.notes ) as notes
- to prevent loosing the Update Specifications of the Datastore
Edit source of the datastore/datawindow
and replace char(4099) with char(32766)
Is there a faster way to do this - we have around 50 - 70 different datastores/datawindows
to fix.
Thank you,
Anton