Form & primary key generated by a Trigger

Scriptcase 8 Discussion
#1

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.

#3

Hi there,

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

Thank you,
C.L.