2 Replies Latest reply on Apr 8, 2009 4:04 PM by groovebox

    Too many global fields...? Report globals? (FM10) - a bit OT.

    groovebox

      Title

      Too many global fields...? Report globals? (FM10) - a bit OT.

      Post

      Greetings - this is a bit odd:

       

      #1

      I am developing a solution so I created a template Table which I just copy/paste and then add specific fields for the Table I am working on. Nothing odd there.

       

      But over time I have created about 20 Global fields which I generally use - eg: report_start_date, report_end_date and so on. Now of those fields I don't use them in EVERY Table.

       

      So - is there any overhead in keeping those fields in EVERY Table if they are not used? I am guessing it is "no" but I have had issues in other database system (not FM) where unused variable/globals caused weird issues. (I am not going to be importing/exporting those Globals -I just create them to use in scripts.)

       

      #2

      A series of globals I tend to use relate to scripting reports - "report_start_date, report_end_date and report_type" - again these are defined per table. I had heard that some people have a Developer Table and place the "report_start_date, report_end_date and so on" fields in there. I guess this is a personal issue and what feels good - but - are there any pro's and con's.

       

      I hope the above makes some sense!


      Respect.