Rocket jBASE

 View Only
  • 1.  suppression of null record keys

    Posted 06-20-2023 12:36

    Is there an environment variable or some config setting in jBASE that will prevent a programmer from attempting to write a record with a null record key?  I would prefer this work globally and not based on a particular file.  This system has a lot of very old code that has probably gone through several conversion prior to jBASE.   I am aware I could put a trigger on the file, but I'm finding this issue across multiple files and would like to resolve it quickly.   We're currently running jBASE 5.7 but will soon be upgrading to 5.8.  Thanks. 



    ------------------------------
    J Edwards
    IT Manager
    Plimpton & Hills
    ------------------------------


  • 2.  RE: suppression of null record keys

    ROCKETEER
    Posted 06-20-2023 12:49

    Jim,

    There is no such setting.

    A trigger would be your best option here.

    Mike



    ------------------------------
    Mike Street
    Technical Support Engineer
    Rocket Internal - All Brands
    ------------------------------



  • 3.  RE: suppression of null record keys

    Posted 06-20-2023 13:44

    Thanks Mike



    ------------------------------
    J Edwards
    IT Manager
    Plimpton & Hills
    ------------------------------



  • 4.  RE: suppression of null record keys

    ROCKETEER
    Posted 06-20-2023 13:46

    Jim,

    The advantage of the trigger(s)  is that you have a chance to catch the culprit, whereas with a setting change, the problem could continue unmitigated.

    Mike



    ------------------------------
    Mike Street
    Technical Support Engineer
    Rocket Internal - All Brands
    ------------------------------



  • 5.  RE: suppression of null record keys

    Posted 06-20-2023 14:12

    Agreed.

    I'm thinking I could probably send an alert out along with the call stack.



    ------------------------------
    J Edwards
    IT Manager
    Plimpton & Hills
    ------------------------------