Using a sequence for an editable grid "default value" - primary key

Joshua Kessler

I'm having trouble using a sequence as the default value for the primary key column of an editable grid.  The sequence only appears be be incrementing once, for the first row.  Each following row has the same value as the first.

 

Is it possible to do what I'm doing?  Do I need to use a jScript instead?

 

Here is the code for the default value:
SelectSql(new MetastormDefault(),"SELECT schemaname.tablename.NEXTVAL FROM DUAL").Text

Jennifer Methlie

If you're using Oracle, the workaround is described in a post from a few years back "Editable grid with primary key column hidden on the form fails to insert multiple rows at a time".  That worked perfectly for us.