No announcement yet.

Changing SQL in a Grid

  • Filter
  • Time
  • Show
Clear All
new posts

  • Changing SQL in a Grid

    Hi All.

    I'm a newbie here on the forum, but we have been playing with Scriptcase here for a while. Now we're starting to use it for real in our client projects.

    It's going very well. But one thing which is bugging me a little is that every time I change the SQL on a Grid application, I seem to then have to redo all my other work in that application. For instance, I just added one field to the table behind my grid, adjusted the SQL to include that field and all my Refined Search, Grouping, Search, Columns, select fields etc disappeared.

    Does anyone know any tricks to prevent this happening, or is it a quirk we have to live with?



  • #2
    I would report this as a bug, I sure hope you don't have to change your db often. You can create SC apps pretty fast, but you need to have a good designed datamodel. You can add / delete fields, but in general you will lose a lot of developmenttime tuning things. All forms needs to be synced, grids changes etc. Lot of the advantages gets lost if you need to change the structure.
    Albert Drent
    aducom software netherlands
    scriptcase partner, reseller, support and (turn-key) development /


    • #3
      Thanks for taking the time to respond, Albert.

      Yes, it's true, we wouldn't normally change the structure very often. But sometimes a client might ask for another column on a grid and we would normally then add it into the SQL. Just seems odd to lose so much for a simple change - doesn't seem to happen with Forms, only with Grids.


      • #4
        Same problem. I have to re-assign everything after a small change in sql.


        • #5
          Hi ozgurkalan

          We have since found that it's usually when we adjust the tables or table links in the SQL. So we now always create a MySQL view for each grid. If the structure of the view changes, you just make the changes on your MySQL server, and then just edit the SQL to indicate the fields required in the grid. Just changing the field list seems to disrupt the grid much less.

          ​Hope this helps



          • #6
            I too have had the same experience.... I have noticed that if I go slowly, adding just one field to the SQL, then going into the "Field Positioning" and adding that field to my Displayed Fields and saving it... I can add them one at a time without problem.

            If I change the SQL a lot.... it blows it up.

            Thats been my experience.


            • #7
              Loose all your work just be changing the SQL, wow, I didn't know that.

              Can ScriptCase fix this?