How initialise record with "General" type field in "M"

Question

I have this type PersonInformation with "General" Value. I add two records: one string and one date.

type PersonInformation
    {
        Value: General;
    } 

I tried this code:

PersonInformations:PersonInformation*
{
    { Value=>"Schuhmacher"},
    { Value=>2001-12-21}
}

 But date was added as 'string'. Now I define one temporaty date and add it to table. It's work but I hope that exist better solution?

 

tmp:Date=>2001-12-21;

PersonInformations:PersonInformation*
{
    { Value=>"Schuhmacher"},
    { Value=>tmp}
}

 

Answer 1

I've confirmed that this behavior is a bug (when compiling to SQL) related to using Date in a General column. Unfortunately, I am not aware of any better workaround than the one you are already using.

I've filed this issue as a bug internally. My apologies for the inconvenience. I will post back here if I learn of a better workaround for you.

Thanks for the feedback and for your interest in Oslo.

David

Answer 2

The next CTP should have a fix for this situation.

David