[GNUe] cascade insert into master detail

[Oleg Noga]

Hello Reinhard,

Is it possible to insert new row to master and some rows to detailt in
same time?

Database is test.sql

spr_user_group.gfd:

When i am only inserting new spr_user row it is ok.
When i am only inserting new spr_usergroup row it is ok.
When i am trying to insert a user with newly entered group list i have
exception:

--------------------------
An unexpected error has occured:
null value in column "usergroup_user_id" violates not-null constraint
.
Please contact your system administrator.

INSERT INTO spr_usergroup (usergroup_group_id) VALUES
(%(new_usergroup_group_id)s)

  new_usergroup_group_id: 1
--------------------------

I have added 'primarykey' attribute to ds_spr_user datasource
  
spr_user.gdf:

When trying to insert new row have error:

INSERT INTO spr_user (user_login, user_id, user_sign, user_name) VALUES
(%(new_user_login)s, %(new_user_id)s, %(new_user_sign)s, %(new_user_name)s)

  new_user_login: u'1'
  new_user_sign: u'1'
  new_user_id: None
  new_user_name: u'1'

What is 'rowid' datasource attribute?
How datasource behaviour depends on primarykey, primarykeyseq and
rowid attributes defined or not?

-- 
Best regards,
 Oleg                          mailto:address@hidden

test.sql
Description: Text document

spr_user_group.gfd
Description: Text Data

spr_user.gfd
Description: Text Data