Avoid $c(0) in globals
Good Morning,
I have this question for a long time. When I make an insert by SQL from an external application in the fields of type %String, if they are empty, it writes the character $c(0) in the global.
Is there a way so that if an Insert is received in a field of type% String with null value instead of the $ c (0) it leaves it empty?:
I have the class defined like this:
Class User.MiClase Extends (% Persistent,% XML.Adaptor)
and the property like this:
Property myProperty As% String;
I have tried creating a trigger or setting default values but it doesn't work.
{
S:({myProperty }=$c(0)) {myProperty }=""
}
Thank you!