Hi,
Form deployed, then was asked to change requirements to allow more than 100 characters of 3 fields
So i changed the Smartobject field from TEXT to MEMO, went into Smartobject Tester and refreshed the Smartobject.
Checked on the K2 Server Smartbox table and it's still showing NVARCHAR(100) on all 3 fields ...
Help, what do i do?
I looked here: http://community.k2.com/t5/K2-blackpearl/Changing-datatype-for-a-smartobject-does-not-change-database/ta-p/87943
it talks about dropping table etc, but this worries me as i have live records in there which are linked back to active processes etc.
Is there any other way of updating the SQL Table?
What would happen if i did DESIGN on the table and altered the Field type from NVARCHAR(100) to NVARCHAR(MAX) manually? Would that screw up everything?
Thanks