Announcement

Collapse
No announcement yet.

ScriptCase v8.0.028 (01-21-2015 22:53)

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

  • ScriptCase v8.0.028 (01-21-2015 22:53)

    New functionalities

    - Implemented option when different users use the same e-mail in the security module. (You will need to recreate the security module)


    Specific correction


    - Fixed problem when using the preg_match function to validate amount of numeric digits.
    - Fixed problem when inserting files with the plus sign (+) in multi upload fields.
    - Fixed problem when using the key of properties in the Firefox browser on text fields.
    - Fixed problem in view of the fields when using the free-form option.
    - Fixed error "Undefined property" in the deployment of container applications.
    - Fixed problem when using Google Maps field modal in Firefox browser.


    Bug

    - Fixed problem when you click to add images on buttons.
    - Fixed problem in the distortion of images to be resized in the PDF Report application.
    - Fixed problem when using predefined texts in the cells of the PDF Report application.
    - Fixed problem validating the unique key when the form is configured to update link table.
    - Fixed problem of accentuation in HTML Editor fields when exported to Excel or Word.
    - Fixed problem when using Google Maps field in a grid application with INNER JOIN.
    - Fixed problem in the TO-DO's scroll bar.
    - Fixed problem in the nomenclature of the friendly URL of the menu application.
    - Fixed problem when exporting to Excel in the grid application using the macro sc_where_current.
    - Fixed duplicate header problem of the summary in grid applications.
    - Fixed SQL problem to add a record in multi upload fields using sequence in auto-increment.
    - Fixed problem when using Ajax events in fields with calculator.
    - Fixed problem in the symbol display (-) in negative fields.
    - Fixed double processing problem using Ajax processing.
    - Fixed problem in the charts display when it is set as black and white.
    - Fixed problem in the validation of the message "That the data have already been sent previously."
    - Fixed problem when using custom tables in the security module.
    - Fixed Javascript problem when using the Run button.
    - Fixed problem when using UNION in SQL's chart application.
    - Fixed problem in "Do not repeat value" upload fields in the grid application.
    - Fixed problem in the field Document(database) in the editable grid form.
    - Fixed problem on upload fields in Editable Grid View, Editable Grid and Multiple Records types of form.
    - Fixed problem when configuring Google Maps fields such as latitude and longitude without informing the fields.
    - Fixed problem with tabulate with Enter on upload fields.
    - Fixed problem saving filter profile that contains checkbox fields.
    - Fixed problem in the navigation of form after using Ajax event with Javascript function.
    - Fixed problem in navigation on forms with editable grid with Log module.
    Last edited by John L. Santos; 01-23-2015, 09:03 AM.
    Best Regards,
    John L. Santos

    Bug Tracker Team
    NetMake - IT Solutions

  • #2
    Hello.

    This update seemed to fix a lot of issues.

    I do seem to have a new issue.

    My Grid/Search application seems not able to search under the Date field?

    Everything comes back as "No records found" even when I know records exist?

    I used to be able to just enter the year and it would show me all records with that year.

    Is this a bug ?

    1.jpg2.jpg3.jpg4.jpg

    Comment


    • #3
      I also noticed that under another search application that I have and is working correctly. The date field is listed as (SQL Type: Date) where as the one I'm having problems with is blank?

      Any Thoughts?

      Comment


      • #4
        In debug mode I see this when trying to search the year 2015.

        No Records Found.

        (mysqlt): select count(*) from tb_byob_orders where create_date like '%aaaa-12-31%'
        (mysqlt): SELECT create_date, ipl_po, customer_po, customer, product, sales_person, factory, fob, design_description, orderID from tb_byob_orders where create_date like '%aaaa-12-31%' order by create_date DESC LIMIT 0,22

        Comment


        • #5
          search.png


          Hello,

          I was unable to simulate the problem locally, could spend more information?
          Best Regards,
          John L. Santos

          Bug Tracker Team
          NetMake - IT Solutions

          Comment


          • #6
            John, instore uses a date field and will search only for the year. Look at the generated SQL code at post #4. In your example you create manually the sql code ...
            Best regards: - Reinhard -

            I use ScriptCase 8 Enterprise Edition, Version 8.(latest)

            Comment


            • #7
              Hello,

              I'm trying to replicate exactly the same way he did.


              Connection: MySQL Transaction (mysqlt)

              SQL Type: DATE

              date.png



              Searching only by the year 1977

              ad_search.png
              Result

              search.png
              Best Regards,
              John L. Santos

              Bug Tracker Team
              NetMake - IT Solutions

              Comment


              • #8
                Originally posted by instore View Post
                I also noticed that under another search application that I have and is working correctly. The date field is listed as (SQL Type: Date) where as the one I'm having problems with is blank?

                Any Thoughts?
                What is the language and regional settings you are using in your project?
                Best Regards,
                John L. Santos

                Bug Tracker Team
                NetMake - IT Solutions

                Comment

                Working...
                X