4 Replies Latest reply on Apr 8, 2017 9:30 AM by philmodjunk

    nested loop

    FaMe

      Hi everyone

      I’ve got a big problem.

      I’ve made a database for dietitian, composed by

      - table: Patients

      - Table: Diets

      - Table: Days

      - Table: Meals

      - Table: join_meal_food

      - Table: foods

       

      Each patients has got multiple diets

      each diet has got multiple days

      each day has got multiple meals

      each meal has got multiple foods.

       

      So, what I’m trying to do is duplicate a diet by script, so I’d obtain a new diet with the same characteristics of the original one.

       

      I’ll try to report here the script simplifying:

       

      Set variable $OldDietID (the ID of the diet I want to duplicate)

      duplicate the diet record

      set variable $NewDietID

       

      go to table: Days (it has more than one day)

      find the OldDietIDFK

      go to the first record

      set variable $OldDayID

       

      loop

      duplicate record

      set variable $NewDayID

      set field “dietIDFK”: $NewDietID

      omit record

      go to the first record

      omit record

       

        go to table: Meals (it has more than one food)

        find the OldDietIDFK

        find the OldDayIDFK

        go to the first record

        set variable $OldMealID

       

        loop

        duplicate record

        set variable $NewMealID

        set field “dietIDFK”: $NewDietID

        set field “dayIDFK”: $NewdayID

        omit record

        go to the first record

        omit record

       

        go to table: Join_meal_food

        find the OldDietIDFK

        find the OldDayIDFK

        find the OldMaelIDFK

        go to the first record

       

        loop

        duplicate record

        set field “dietIDFK”: $NewDietID

        set field “dayIDFK”: $NewdayID

        set field “mealIDFK”: $NewMealID

        omit record

        go to the first record

        omit record

       

        exit loop if [Get (FoundCount)=0]

        end loop

       

        exit loop if [Get (FoundCount)=0]

        end loop

       

      exit loop if [Get (FoundCount)=0]

      end loop

       

       

      The problem is that when it duplicates the first meal, and only the first, and exit the loop.

       

      Does anybody help me?