11-13-2018 05:03 AM
I've ran into some strange issues with Picklists. This is the second time I encounter this, with a complete another Act! version and database.
See attachment picklistweird.png.
Basically there's a PickListItem with a very long value with newlines (\r\n) in it, which isn't visible in Act! but the SDK returns it. So if I serialize it to JSON for consumption in an external (web)app, clients get to see it.
If I look in the database itself (with SQL management studio) I can see it's there (picklistweird2.png), and I guess that in the past someone 'fixed' it by not showing them in the Act! Windows client when there are newlines.