Last active [hidden]
Could you check if there is a problem with inserting null into Postgres with Creo. I have an error for a date field when inserting a null value ( where date allows null's) . The formula works in Postico.
ERROR: invalid input syntax for type date: "null"
LINE 1: ...'base64')), "preferred" = $$false$$ , "expdate" = $$null$$ ...
It seems to be associated with a date value and not being able to be converted to a string by CreoPlayer thus creating an error for value [0...9]. Ok for the simulator if that helps you
BTW - Hope all is well with the Creo team , all ok here but headed to lockdown shortly.
Console.write(value.class); -----> anonymous closure , this gives the error
Out of bounds error: second_index 9 beyond bounds 0...3
What is anonymous closure ?
Ok I see that all objects cannot use String() but still cannot see why in CreoPlayer the CustomView45 doesn't follow through and use the computed property , whose value is a string .
Anyways shut in for a few weeks, though not as strict as you have , so plenty of time to figure it out.
OK, under what conditions would a value cannot be converted to a string ?
Forced a string for value (2019-12-03 00:00:00)
var d = String(value)
date.text = d[0...9];
and ok for simulator, but a differant runtime error for CreoPlayer Also works for CreoPlayer in loading a list for initial record but not the second, which generates an error.
test <Console.write(value.class)> shows String, repeatable
Of course I can only use this test with the simulator not CreoPlayer where the runtime error occurs.
Ok will do that but in my testing I forced a string with String(value) and had the same results
Formatting the string - 2019-12-03 00:00:00