Configuration record

Applications Forms
#1

I have a need to create a Config table with one record, to keep certain Project settings. Obviously there will be no DELETE or INSERT only UPDATE available.
What would be suggested best approach to do this ?

Arthur

#2

A quick and dirty way is to create a hidden field with a default of 1. Then set that field as unique. User will get an error on insert. I’m sure there is a cleaner way but it works and is quick. Sometimes in certain environments the constraints do not always work, so you could also set up a trigger to do this.

Later…
Pappy

#3

thanks, but this is not what I need…

I believe there is some macro which allows to put the rodm either in Insert or Update mode (not sure if this would work)…

  1. On first App run the Single record will be created
    I think I will use the same as below with the condition IF ERROR() then CRERATE A RECORD, if not the goto step 2

  2. One every update the record will be edited

  3. Question where do I insert some code to read the Config record and assign the fields to variables ?
    I use Login App and then MenuApp. Is it better to use one or another ?

Arthur

I'm assuming using something like: sc_select() with the record_ID=1 should work