Hi,
I have found a bug which occurs when trying to add Form Section Security when the Departments option is selected.
I can see and manipulate the Form Section Security dialog box with no issues, but on pressing OK I get the following error:
Error in BuildSectionControlSubform()
184 Variant does not contain a container at line 65
Looking through the code I found this:
Case "3"
DeptSpecific = Evaluate ({@DBLookup(""; @DBName; "LURef";"} & Editors(i1) & {"; "a_DeptSpecific")}) <br/>
DeptKey = Evaluate ({@DBLookup(""; @DBName; "LURef";"} & Editors(i1) & {"; "a_DeptKey")})<br/>
QenosRoleName = Evaluate ({@DBLookup(""; @DBName; "LURef";"} & Editors(i1) & {"; "a_Formula")})<br/>
If DeptSpecific(0) = "1" Then<br/>
Let formula = |@Text(@DBLookup(""; @Subset(@DBName; 1) : "applications/QEN00052.nsf"; "(Lookup ApplicationDepartmentRole)"; @DBTitle + | + DeptKey(0) + | + "| + QenosRoleName(0) + |"; 2))| 'returns all department specific usernames for the specified Qenos Directory Role<br/>
Else<br/>
Let formula = |@if(@IsMember(@DBLookup(""; @DBName; "LURef"; "| & Editors(i1) & |"; "a_Role"); UserAppRoles);@UserName; "")|<br/>
End If<br/>
stream.writeText formula(0) ,0<br/>
It is failing on the last line (stream.writeText …) because formula is just set to a String and not an array - I'm not sure if formula should be Eval'ed first.
Also, because it is Department Specific it is looking up a database at "applications/QEN00052.nsf" which I'm not sure if it's meant to do?
Cheers
Darren