• Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
  • Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

Bob update

Collapse
X
  •  
  • Filter
  • Time
  • Show
Clear All
new posts

    #51
    Originally posted by suityou01 View Post
    In the meta data we define for each type of dinner, what the default set of dinner items are.

    So for cooked breakfast we have :

    Fried tomato
    Bacon
    Beans
    Sausage
    Mushrooms
    Is there a vegetarian option?

    And technically is Breakfast a type of dinner?

    I would look at your requirements as they are not up to scratch.
    Originally posted by Stevie Wonder Boy
    I can't see any way to do it can you please advise?

    I want my account deleted and all of my information removed, I want to invoke my right to be forgotten.

    Comment


      #52
      Originally posted by SimonMac View Post
      Is there a vegetarian option?

      And technically is Breakfast a type of dinner?

      I would look at your requirements as they are not up to scratch.
      Yeah, sorry, forgot to order a couple of bottles of wine there.
      And what exactly is wrong with an "ad hominem" argument? Dodgy Agent, 16-5-2014

      Comment


        #53
        Originally posted by Hill Station Murthy View Post
        I have considered your problem domain and I can say that I feel the best way to implement your solution would be to use LinqToSql
        thus preserving n-tier architecture and negating use of thes cursors.

        I have to be honest with you and say that this problem domain is frankly pretty trivial
        when compared to some of the solutions I have to pull out of my hat when I am required to do so by my clients. And these soultions I provide these soutions all come without these cursors. Never.
        LinqToSQL Not an option as it's not part of the BPM framework and would require a custom BO layer. Customisation is not an option as it has been deliberately scoped out by the client.

        Next.
        Knock first as I might be balancing my chakras.

        Comment


          #54
          Originally posted by SimonMac View Post
          Is there a vegetarian option?

          And technically is Breakfast a type of dinner?

          I would look at your requirements as they are not up to scratch.
          Good point. Perhaps the meta data needs reclassifying. Would Meal be a better super type?
          Knock first as I might be balancing my chakras.

          Comment


            #55
            Originally posted by suityou01 View Post
            LinqToSQL Not an option as it's not part of the BPM framework and would require a custom BO layer. Customisation is not an option as it has been deliberately scoped out by the client.

            Next.
            we're on to breakfast now. Do keep up.
            And what exactly is wrong with an "ad hominem" argument? Dodgy Agent, 16-5-2014

            Comment


              #56
              Originally posted by suityou01 View Post
              Good point. Perhaps the meta data needs reclassifying. Would Meal be a better super type?
              And what exactly is wrong with an "ad hominem" argument? Dodgy Agent, 16-5-2014

              Comment


                #57
                Originally posted by Mich the Tester View Post
                we're on to breakfast now. Do keep up.
                Sorry. I'll have the fruit salad and a coffee as I need to lose a few lbs.
                Knock first as I might be balancing my chakras.

                Comment


                  #58
                  Originally posted by suityou01 View Post
                  OK so this is the example where the cursor is being used :

                  The screen in question creates a row in a table called dinner. There is a child table called dinner_item which will hold all of the dinner items.

                  In the meta data we define for each type of dinner, what the default set of dinner items are.

                  So for cooked breakfast we have :

                  Fried tomato
                  Bacon
                  Beans
                  Sausage
                  Mushrooms

                  So when we create a dinner row, we want to automajically populate the dinner items from the meta data. So the cursor would open the list of dinner_items from the meta data, and then pop one row in the dinner_item table.

                  It could be done from the application layer, but this would not only perform better but would be easier to change the stored procedure than rush out a new version of the app.

                  The stored procedure debate trundles on, but we were forced into using stored procs as Oracle doesn't have an identity field, so we need to use sequences so this is all wrapped up in the insert stored proc, and the new id value returned as an output variable.
                  This app you're writing, it's not for Granada Service Stations by any chance is it?

                  Comment


                    #59
                    Originally posted by pacharan View Post
                    This app you're writing, it's not for Granada Service Stations by any chance is it?
                    Little Chef.
                    Knock first as I might be balancing my chakras.

                    Comment


                      #60
                      Originally posted by suityou01 View Post
                      Little Chef.
                      All the same, a business domain with which I am very familiar.

                      Let me know if can be of any ossistunce.

                      Comment

                      Working...
                      X