2. PHPRunner General questions
  3. Problem: Logged user is the "default" value when I add records
This topic is locked

Problem: Logged user is the "default" value when I add records

 		5/30/2010 6:39:17 PM
PHPRunner General questions
M
 matteofaini author

Hello to everyone and thank you once more for this great PHPRUNNER 5.2.

I have a problem, that happens in two different database, with no relationship between them.
I have a table "USERS", which is used both to store the users and to catch values to fill a field in another table ("TASKS").

For example it can happen that I log-in and I want to add a task for another user: obviously I want that the user-field has his username, because it's a tasks of his.

Everything seems ok, but the result is that the record has MY username, instead of the user I have selected. If then I want to edit the new record, everything works OK.

I checked out and the field "Default value" is empty.
I haven't got a clue... Is there everyone that can help me?
Thank you,

Matteo F.
J
 		Jane 5/31/2010

Matteo,
this error happens because you've turned onUser can see and edit their own records onlysecurity method on the Advanced security settings dialog on the Securitytab.
To make your pages working create custom view of this table on theDatasource tables tab, assign permissions for this view for admin only on the Securitytab and choose User can see and edit all records option on the Advanced security settingsdialog. So admin will add records for all users on this view.