Update Record Level Security

[pdbe]

Hello

Hopefully someone can help with this record level security problem which is basic stuff but I haven’t found much to help on the internet.

I use ‘Require Exact Match when Searching records’ all the time and it has caused no problems however I seem to have got stuck trying to use the ‘when Updating records’ option with a FileMaker 9 database.

I have simple input and response pages to test the feature, the relevant code from each is shown below. To simplify things I’m only requiring that the Username field has an exact match when updating.

input.lasso

((4 field inputs...))

update.lasso

[inline: (Action_Params), -Update, -Database=’mydatabasename’, -Table='User_Info'][/inline]

[Action_Params] in the above inline returns this:

array: (pair: (-update)=()), (pair: (-database)=(mydatabasename)), (pair: (-table)=(User_Info)), (pair: (-keyfield)=(ID)), (pair: (-keyvalue)=(282)), (pair: (-operatorlogical)=(and)), (pair: (-maxrecords)=(50)), (pair: (-skiprecords)=(0)), (pair: (-op)=(bw)), (pair: (Username)=(SCH073)), (pair: (-op)=(bw)), (pair: (Entrymessage_viewed)=(No)), (pair: (-op)=(bw)), (pair: (Copy_links)=(Yes)), (pair: (-op)=(bw)), (pair: (Gov_allow)=(Yes)), (pair: (-op)=(bw)), (pair: (Gov_pdf)=(No))

It is passing ‘SCH073’ which is the exact username to the Update inline. The update works if I uncheck the ‘Require exact match when updating records box’ and when I check it I get “-9960:The field "Username" has been marked as "exact update" and the restriction was not met.”

Thanks in advance for your help.