Normal Topic security and look up commands (Read 526 times)
debmckee
Full Member
***
Offline



Posts: 123
Joined: Oct 5th, 2011
security and look up commands
Feb 13th, 2012 at 4:37pm
Print Post Print Post  
I put in a password for my xlookup commands  - it works for simple lookups.  But it won't with the following program statement  (which I had sesame support program for me)
I am now adding security and having problems.
"Programming statement # 1"

var vList as String
var vList2 as String
var vList3 as String

// Get all Contacts from Contacts form
vList = @XListValues(@fn, "Contacts!le5")

// Initialize the Combo Box with unique sorted values
vList2 = @SortStringArray(vList, 0)
vList3 = @UniqueStringArray(vList2)
PopulateListElement(cust lookup0, vList3)

"programming statement # 2"
Var vVendor as String

If @IsBlank(cust Lookup0) = False Then
{
     vVendor = @XLookup(@fn, Cust Lookup0, "Contacts!le5", "Name_Address0")
     Vendor0 = vVendor
}



  
Back to top
 
IP Logged
 
debmckee
Full Member
***
Offline



Posts: 123
Joined: Oct 5th, 2011
Re: security and look up commands
Reply #1 - Feb 13th, 2012 at 5:18pm
Print Post Print Post  
I tried removing the security from the target layout but it didn't make a difference
  
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: security and look up commands
Reply #2 - Feb 13th, 2012 at 5:32pm
Print Post Print Post  
Hello deb,

If other XLookups using @FN are working, then I don't think the issue lies in security. Double-check that there is still an element named le5 on the Contacts form and that it did not get renamed.

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
debmckee
Full Member
***
Offline



Posts: 123
Joined: Oct 5th, 2011
Re: security and look up commands
Reply #3 - Feb 13th, 2012 at 6:56pm
Print Post Print Post  
If I remove ALL the security it works fine. 
  
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: security and look up commands
Reply #4 - Feb 13th, 2012 at 9:50pm
Print Post Print Post  
Hello Deb,

Okay, then let's start with a simple test.

Open Sesame Designer
Open your DSR file
Open the Security Manager
Group Name: group
Click Add New Group
Click the Users tab
User Name: user
Password: user
Confirm Password: user
Click Add New User
Click the Application Settings Tab
X User Name: user
X Password: user
Confirm Password: user
Click Apply Changes
Click Close
Click Preview application

Go and test those X commands. Do they work correctly?

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged