8 Replies Latest reply on Nov 26, 2016 12:41 PM by analistamarcio

    Database Design Report: Missing field

    sfpx

      I'm cleaning my scripts and use the design report to assist me.

      I have a script that has "<Missing Field>" in the Fields used in this script section of the report.

      The problem is that there is no missing field in the script as far as I know. I searched for "missing" in the script itself and got nothing.

       

      Any idea on what I'm "missing" ?

        • 1. Re: Database Design Report: Missing field
          Mike_Mitchell

          Any external files not included in the DDR?

          • 2. Re: Database Design Report: Missing field
            sfpx

            There is an external file not included in the DDR but this external file is not called at all in the script in question.

            There are some other scripts called inside the script though.

             

            Since the Fields used in the script section lists the fields in order of use in the script I guess that the missing field would be in the following section

             

             

             

            Set Variable [ $NewCoords; Value:1 ]

             

            Go to Layout [ original layout ]

             

            Perform Script [ “GoToSwipe”; Parameter: "swipedialog" ]

             

            Set Field [ SelectedFlightEvent::Base; Get ( ScriptResult ) ]

             

            Set Field [ SelectedFlightEvent::HasCreatedBase; 1 ]

             

            Commit Records/Requests [ Skip data entry validation; No dialog ]

             

            Set Variable [ $NewBase; Value:"YES" ]

             

            Go to Object [ Object Name: "Tab9" ]

             

            Go to Field [ SelectedEventBase::NameBases ]

             

            Select All

             

            Set Variable [ $$DISABLEONLOAD; Value:"NO" ]

             

            Exit Script [ ]

             

            Else If [ $SelectedBase=2 ]

             

            Set Variable [ $$DISPLAYALLBASES; Value:1 ]

             

            Perform Script [ “RefreshBaseMagicList” ]

             

            Exit Script [ ]

             

            Else

             

            Set Field [ SelectedFlightEvent::HasCreatedBase; 0 ]

             

            Set Field [ SelectedFlightEvent::Base; $selectedbase ]

             

            Commit Records/Requests [ No dialog ]

             

            Set Field [ SelectedFlightEvent::CacheLat; SelectedEventBase::Latitude ]

             

            Set Field [ SelectedFlightEvent::CacheLon; SelectedEventBase::Longitude ]

             

            If [ $IsLastEvent=1 and $selectedbase ≠ "99" and Get(MultiUserState) ≠ 2 and Flights::InEventDialog=1 and Distance ($$Latitude ; $$Longitude ; SelectedEventBase::Latitude ; SelectedEventBase::Longitude; "km") > .3 ]

             

            Perform Script [ “GPSLocate” ]

             

            Set Field [ SelectedEventBase::Latitude; $$Latitude ]

             

            Set Field [ SelectedEventBase::Longitude; $$Longitude ]

             

            If [ Flights::DataEntryMode ≠ 1 ]

             

            Perform Script [ “launchtimedgps” ]

             

            End If

             

            End If

             

            Commit Records/Requests [ No dialog ]

             

            Set Variable [ $$DialogBase; Value:SelectedEventBase::NameBases ]

             

            If [ $IsLastEvent=1 and IsEmpty(SelectedEventBase::Latitude) and Get(MultiUserState) ≠ 2 ]

             

            Set Field [ SelectedEventBase::Latitude; $$Latitude ]

             

            Set Field [ SelectedEventBase::Longitude; $$Longitude ]

             

            End If

             

            I don't see any missing field in there nor in the full script.

            • 3. Re: Database Design Report: Missing field
              Mike_Mitchell

              Try running the DDR again and include the external file this time.

              • 4. Re: Database Design Report: Missing field
                sfpx

                Tried it with the external file included this morning. Still reporting a missing field.

                I guess I'll have to find it the hard way by removing lines progressively until there is no missing field reported.

                • 5. Re: Database Design Report: Missing field
                  Mike_Mitchell

                  There may be some damage in the file. Have you run a Recover?

                  • 6. Re: Database Design Report: Missing field
                    sfpx

                    Recover found nothing wrong and DDR still reports a missing field.

                    That's quite a strange problem.

                    Like I said I will try removing lines to determine on which line this so called missing field is.

                    I will report the findings here.

                    • 7. Re: Database Design Report: Missing field
                      sfpx

                      I think I got it.

                      Looks like it's a bug.

                      Here is how to replicate it.

                      1.Create a table with a global field.

                      2.Create a script with this command : Show Custom Dialog with the global field as an input field.

                       

                      Run DDR and it will report a missing field.

                      • 8. Re: Database Design Report: Missing field
                        analistamarcio

                        Hi!

                         

                        I had the same problem doing a cleanup on my scripts.

                        It seems that the problem occurs when we use any field as an input field.

                         

                        In this cleaning, I also found another difficulty:

                        - If you use the "Enter Find Mode []" script step, specify some find requests and, for any reason you resolve to unmark this option ("Specify find requests"); all information used before in the "Specify..." option, will be stored in the script, but will not appear in the Database Design Report. In this case, if you, for example, delete a field used before you unmark the specification options, you will be reported with a Missing Field or any other issue not showed in the report.

                         

                        I mentioned the "Enter Find Mode []" script step, but I also found this bug (?) in another script step too, as the "Perform find []". I think there are other scripts steps that store this kind of informations but aren't reported in the Database Design Report if the check box "Specify..." is not marked.