Announcement

Collapse
No announcement yet.

Error with foreign field type numeric

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Error with foreign field type numeric

    Hi, I Think SC has a Bug with Foreign Fields, My form has a foreign field type numeric and it is null, my others fields have data. When i insert a new record, SC Asign to my foreign field the value to ZERO, then the database genetares an error of constraints. (El value ZERO does not exists in table parent).

    I Need my field {UND_CDGOP} be NULL.

    i put this code in onbeforeinsert, but it not works.
    if ( {UND_CDGOP} ==0 ) {
    {UND_CDGOP} = NULL;
    }
    .

    How can i fix it Bug?
Working...
X