Announcement

Collapse
No announcement yet.

Delete / Remove a Field from the Form application

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

  • Delete / Remove a Field from the Form application

    I have a table which have lots of fields.

    When creating the form application i want to select only some fields from this table.
    Where do i specify the fields to be used?

    At the moment i can only see options for Hiding the fields and not removing them.

    Please advise.

    Thanks

    Anil
    ************************************************** ********
    We are Developing your Future Business Requirement right now with Scriptcase.
    www.sri.com.au & www.madikonda.com

  • #2
    You can always modify the SQL under the SQL script

    Comment


    • #3
      Hello,
      in the GRID application you can simply change the sql statement...
      In the form application you cannot modify the sql statement but you can choose in [fields positioning] which fields you want to use in the form..


      Best regards
      Uwe Pfeiffer

      Comment


      • #4
        scriptcase forms bug with field ending with _type

        Originally posted by Pfeiffer View Post
        Hello,
        in the GRID application you can simply change the sql statement...
        In the form application you cannot modify the sql statement but you can choose in [fields positioning] which fields you want to use in the form..


        Best regards
        Uwe Pfeiffer

        I am aware of this function and it is not suitable for the current task, because script case form's application is still phrasing these fields, even if the fields are hidden. Let me explain my problem.

        There is a BUG in scriptcase which interfers with my project. I have lots of fields in my table that have the word _type at the end of the field name "attachment_type", "id_type" and etc. I cannot rename these fields as another software (third party properitary software) uses the same table as well.

        if these field names are present in the table then script case does not run the forms application. The grid application works well.

        The only way to bypass the bug in script forms application is to change the field name or remove from the table - both actions unsuitable.

        The other idea was to hide the field name from being used in the form application, which is where this post started for.

        I see that we can use the database dictionary - can we untick the field tpo hide a field as well?

        Thanks for your time
        ************************************************** ********
        We are Developing your Future Business Requirement right now with Scriptcase.
        www.sri.com.au & www.madikonda.com

        Comment


        • #5
          Hello,

          Our bugs team is currently aware of this issue, and they are running tests to verifiy if it is a bug or not, and if it is, what might be causing it.

          You could get in touch with our support team, they may have a workaround to the problem.

          regards,
          Bernhard Bernsmann

          Comment


          • #6
            it is a bug

            Originally posted by bartho View Post
            Hello,

            Our bugs team is currently aware of this issue, and they are running tests to verifiy if it is a bug or not, and if it is, what might be causing it.

            You could get in touch with our support team, they may have a workaround to the problem.

            regards,
            Bernhard Bernsmann
            Hi Bernhard,

            It is a BUG in version 6.0x 39. Exact same table works in SC version 5.x

            Support is aware of the issue. I am trying to work around the problem untill support fixes the issue.

            Thanks
            ************************************************** ********
            We are Developing your Future Business Requirement right now with Scriptcase.
            www.sri.com.au & www.madikonda.com

            Comment


            • #7
              Hello,

              As soon as I hear from our bugs team, I will get back at you.

              regards,
              Bernhard Bernsmann

              Comment


              • #8
                Just a thought, sometimes you can change the statement e.g.:
                select attachment_type as attachtp,id_type as idtp from ....

                Comment


                • #9
                  That's correct sql but afaik it cannot be used within SC, or at least on every spot. AFAIK the parser of scriptcase extracting fieldnames does not like this.
                  Albert Drent
                  aducom software netherlands
                  scriptcase partner, reseller, support and (turn-key) development
                  www.scriptcase.eu / www.scriptcase.nl

                  Comment


                  • #10
                    There are some other strange behaviour of SC... for example with a database field and the ending <fieldname>_name... This is a confirmed bug older than 2 month and SC support DOES NOTHING to change this... Meanwhile I have 3 bugs concerning field name and SC support doesn't care...all is posted as a support ticket.....

                    Meanwhile I'm thinking about no longer to use the paid support...
                    All my bugs are still existing.. and I don't like to pay for a support to tell them THEIR errors and then they let me wait for weeks without a helpful response. Sorry, but that's the truth.

                    SC is the best tool I know .. but support is still .... (:
                    The always are testing..testing..testing.... and they are all working on SC V7 ..... but we still use V6.

                    regards
                    Uwe
                    Last edited by Pfeiffer; 01-04-2013, 04:44 PM.

                    Comment


                    • #11
                      This is a very basic request. Removing an existing field from the application.

                      Scriptcase cant handle this task.
                      ************************************************** ********
                      We are Developing your Future Business Requirement right now with Scriptcase.
                      www.sri.com.au & www.madikonda.com

                      Comment


                      • #12
                        Hello,

                        Just to keep you guys on the loop, I'm asking for an update on the issue to our bugs team.

                        regards,
                        Bernhard Bernsmann

                        Comment


                        • #13
                          Hello all,

                          I have yet to receive an update on this issue with version 6.
                          Last edited by madikonda; 02-16-2013, 10:40 AM.
                          ************************************************** ********
                          We are Developing your Future Business Requirement right now with Scriptcase.
                          www.sri.com.au & www.madikonda.com

                          Comment


                          • #14
                            This bug exists in version 7 as well
                            ************************************************** ********
                            We are Developing your Future Business Requirement right now with Scriptcase.
                            www.sri.com.au & www.madikonda.com

                            Comment


                            • #15
                              Hello,

                              I'm contacting our bugs team regarding this issue.

                              regards,
                              Bernhard Bernsmann

                              Comment

                              Working...
                              X