Normal Topic Security affecting combo boxes? (Read 588 times)
chaven
Member
*
Offline


There's no way out of
here...

Posts: 18
Joined: Apr 2nd, 2013
Security affecting combo boxes?
Jun 21st, 2013 at 4:30pm
Print Post Print Post  
On my employee training database I have a combo box (drop-down box)  on a sub-form that allows the facilitator of the training to select a previously entered training type, OR enter a new training type into the box that will show up later on future entries. 

It works perfectly, until I add security on the application.  Here is the code that is located in the "On Form Entry" of the "Training" sub-form:

Code
Select All
var vList as String

//Gather values from IDs, remove duplicates, load into training combo box
vList = @XListValues(@FN, "Training!drp_Training")
vList = @UniqueStringArray(vList)
vList = @SortStringArray(vList, 0)
PopulateListElement(drp_Training, vList)
  



Like I mentioned previously, the combo box works exactly as it should until I add security to the application, then the box will not populate with previously entered values.  For now, I have stripped off all security (which is OK for the time) but was interested in what might be causing this.  Any ideas?

-=K=-
  

...when you come in, you're in, for good.
Back to top
 
IP Logged
 
BOBSCOTT
Senior Member
Members
*****
Offline


That Darn Computer #$X#
{curse words}

Posts: 1195
Joined: Nov 22nd, 2002
Re: Security affecting combo boxes?
Reply #1 - Jun 21st, 2013 at 8:05pm
Print Post Print Post  
I may be way off base here, however in the old days with xlookups and stuff if you used security you needed to have a xlookup password set in the security manager of the app.

Not sure if it is relevant here but I thought I would at least throw it out just incase.

I am sure a guru will pipe in shortly.
  

Team – Together Everyone Achieves More
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 affecting combo boxes?
Reply #2 - Jun 21st, 2013 at 8:53pm
Print Post Print Post  
Robert is correct. In the Security Manager on the Application Settings tab, you'll need to set X User and X Password to a valid login and password to this application. When you reconcile be sure to choose Yes to the "Should Reconcile replace the Security in the target application?" question.

-Ray
  

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


There's no way out of
here...

Posts: 18
Joined: Apr 2nd, 2013
Re: Security affecting combo boxes?
Reply #3 - Jun 21st, 2013 at 9:16pm
Print Post Print Post  
Ahh, that explains a lot, that's what I get for not reading the instructions cover-to-cover.  Grin

Thank you, gentlemen.

-=K=-
  

...when you come in, you're in, for good.
Back to top
 
IP Logged