Announcement

Collapse
No announcement yet.

Bug in SC7 - running a form with all navigation buttons removed from toolbar

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

  • Bug in SC7 - running a form with all navigation buttons removed from toolbar

    Hi. This has happened to 2 different forms I have built in SC7.1

    I am using an eval copy of SC7.1, version 7.01.0009

    In these forms, they are editing a table with only one record, so I set the WHERE to be: ID='1'

    I remove all unused buttons from the form toolbar, such as Insert, Delete and so on. So far all is good.

    From the bottom of the toolbar I do not need any of the navigation buttons. When I remove them and run the app to test it, I get not a error, but an unexpected screen appears. I have attached a screen grab. It is the name of the app, it is asking for "id" (which is not one of my variables). And it has a button for index. If I click teh index button, the app runs. The "id" showingf os lowercase. The ID field in my form is upper case. I use no variable, local or global in the test forms.

    It looks like the type of input you would expect in an app you are running from inside SC, when it is expecting a global variable. In this case, I am not using any global variables...

    I put back the buttons and removed one by one and found that it is (of course) the "Last" button. If I remove that one I get the message when I run the app. If I put "Last" back, it just runs normally.

    So the "Last" button removal is somehow affecting the code , making the system believe that a value for a variable "id" is needed before running the app.

    I also can get rid of the error if I leave atleast one of the navigation buttons on the bottom toolbar. But if I put another type of button, like "Update" on the bottom toolbar without a navigation button(s) the bug happens.

    I do the same thing in forms in SC6, and I have never seen this behavior before.

    Workaround - Leave the "Last" button on the bottom toolbar and

    Can SC staff please verify that they have logged this error for correction on a future release?
    Thanks,
    Jamie
    Attached Files
    Last edited by onmountain; 10-12-2013, 05:37 PM.

  • #2
    Hello Jamie,

    Issue reported to our bugs team.

    regards,
    Bernhard Bernsmann

    Comment


    • #3
      Thank you!
      Have a great weekend,
      Jamie

      Comment


      • #4
        You too!!

        Thanks!

        Comment


        • #5
          Hello Jamie,

          I was informed by our bugs team that this is actually the default behavior of form applications.

          Have you tried a workaround to this? Perhaps leave the "last" button as you did, and hide it using sc_btn_display.

          regards,
          Bernhard Bernsmann

          Comment


          • #6
            Hi. That seems strange to me. This does not happen in Sc V6, where I have removed the bottom toolbar buttons with no problems many times. I almost never use the bottom navigation buttons. Now in V7 I get what looks like an INTERNAL variable causing a prompt. There must be a loop on forms that uses a var called id, and now with no buttons it has no initial value.

            If it is the default to not allow us to remove all buttons, then why does the SC toolbars GUI have the option to do so? I have not tried to remove the button with the macro, but never had to in the past.

            I just tested in SCv7.1 with the command sc_btn_display ('last', 'off');

            It worked and removed the Last button. Thanks.

            However, seems like you should look at your code to stop the 'id' prompt when all buttons are removed in the form settings - toolbars.

            Thanks for getting right back
            Jamie

            Comment


            • #7
              Jamie,

              I'm glad you were able to solve the issue.

              I will contact our bugs team again regarding your last feedback.

              regards,
              Bernhard Bernsmann

              Comment


              • #8
                Yes - I have had same issue in version 7 - SC support is extremely disappointing, shame because this is a strong application...I have had to outsource to PHP community to get support/fixes!

                Comment


                • #9
                  Hello,

                  Forgive me if I'm not completely understood the problem, but from what I understand, this is a standard behavior of Scriptcase.
                  What happens is that when we run a form, Scriptcase does a count of all records in the table (you can check debug mode enabled, the first line is SELECT count (*) from table) so we can create a pagination the from the first to the last record based on that score.
                  If you remove all the navigation buttons, the Scriptcase can not identify which record should be displayed, so it generates a test application for you to inform the ID.

                  Anyway, if my explanation is unclear or not related to the problem, explain step by step to your problem.
                  Best Regards,
                  John L. Santos

                  Bug Tracker Team
                  NetMake - IT Solutions

                  Comment


                  • #10
                    Originally posted by onmountain View Post

                    The "id" showingf os lowercase. The ID field in my form is upper case.
                    The database that you are using is case sensitive?
                    Try to disable the case sensitive option in your application settings SQL.
                    Best Regards,
                    John L. Santos

                    Bug Tracker Team
                    NetMake - IT Solutions

                    Comment


                    • #11
                      this situation occurs in V6 too, and runs ok when you use these form in a link as dialog information form

                      by example, in a grid have only the customer name as link and when the user click on this link display a modal window with the dialog form contains more information about the customer (address, telephone, mail, city, country, etc)

                      this form do not have any buttons (top or bottom) only close button and is very useful

                      if you want a form for editing the customer, then have another form app with all the necesary buttons enabled

                      Aquiles

                      Comment

                      Working...
                      X