Normal Topic Working with Database Global Values (Read 1561 times)
BWETTLAUFER
Full Member
***
Offline



Posts: 216
Location: Cambridge, Ontario
Joined: Apr 9th, 2010
Working with Database Global Values
Mar 20th, 2019 at 9:54pm
Print Post Print Post  
Hey all!

I'm starting to put more things into GlobalValues in my application  -- things like a checklist of things to set up for new staff, something that should be able to change and evolve without requiring a database upgrade.

However, I want to be able to manage these global values better.  Is there a way in my live database I can set up a button to list all of the exisitng global values, and then populate them into a popuplist that I can then use to alter them (with the correct admin functions, of course)?

Thanks!
  
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: Working with Database Global Values
Reply #1 - Mar 21st, 2019 at 1:07pm
Print Post Print Post  
Hi Blair,

The function you are looking for is @IterateGlobalValues(). It returns a semicolon-delimited string listing the names of the current Global Values. You can then ask the user which one they want to modify, etc, etc, etc.

-Ray
  

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