Web forum is in read-only mode. Login as active registered customer for write access
  Forum Search   New Posts New Posts

SS does not save security data

 Post Reply Post Reply
Author
Pekka Paunio View Drop Down
New Member
New Member
Avatar

Joined: 05 Dec 2013
Posts: 2
Post Options Post Options   Quote Pekka Paunio Quote  Post ReplyReply Direct Link To This Post Topic: SS does not save security data
    Posted: 05 Dec 2013 at 8:24am
I might be missing something but security system dialogs don't save data to firebird database I'm using.

I've placed normal data components in a datamodule, the dialogs appear fine both design time and runtime.

No error messages are created except on inserting a row with id, it requires a value for that field. I've placed default 0 for inserts and FB trigger handles that, so it shouldn't be a problem.

-Pekka
Back to Top
Bruno Fierens View Drop Down
TMS Support
TMS Support
Avatar

Joined: 11 May 2010
Posts: 7665
Post Options Post Options   Quote Bruno Fierens Quote  Post ReplyReply Direct Link To This Post Posted: 05 Dec 2013 at 2:40pm
Are you using auto inc. field types for Users.UserID and UserAccess.ID ?
Back to Top
Pekka Paunio View Drop Down
New Member
New Member
Avatar

Joined: 05 Dec 2013
Posts: 2
Post Options Post Options   Quote Pekka Paunio Quote  Post ReplyReply Direct Link To This Post Posted: 06 Dec 2013 at 2:35am
Yes, trigger increments the id.

' IF ((NEW.GROUP_ID IS NULL) or (NEW.GROUP_ID = 0)) THEN
      NEW.GROUP_ID = GEN_ID(GROUPS_GROUP_ID_GEN, 1);'

and client datasets beforepost: cdsuserGroup_id.value := 0 if dataset state is dsInsert.

but edit changes do not occur either.
Back to Top
Bruno Fierens View Drop Down
TMS Support
TMS Support
Avatar

Joined: 11 May 2010
Posts: 7665
Post Options Post Options   Quote Bruno Fierens Quote  Post ReplyReply Direct Link To This Post Posted: 10 Dec 2013 at 10:09am
As I don't see the complete setup & settings, it is hard to judge what is wrong.
Did you compare the setup with our sample app?
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down