Announcement

Collapse
No announcement yet.

Form & primary key generated by a Trigger

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

  • Form & primary key generated by a Trigger

    Hi,

    Maybe I do not do the good things, but I would like to know how I could manage a primary key In a SC Form which is generated by a Trigger.

    I have a MySQL Table and two columns as a Primary Key.

    The first one is an autoincrement value and the second one is generated by a "BEFORE INSERT Trigger".

    I try several options in SC for this second field (ex. Null, Automatically generated by the DB, ...) but none allows me to insert a new row.

    It says "Error : missing value for COLUMN".

    Would you know how I could do please ?

    Thank you,
    Regards,
    C.L.

  • #2
    Has someone an idea about my question ?

    Happy new Year all !
    C.L.

    Comment


    • #3
      Hi there,

      Would it be possible to say me if my question is in the good topic ?

      Thank you,
      C.L.

      Comment

      Working...
      X