Announcement

Collapse
No announcement yet.

Grid SQL not refreshing

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

  • Grid SQL not refreshing

    I hcnaged a column name: DiseaseID -> ID in SQLite
    I also changed the name in SQL clause, but when I run my GRID App it generates an error based on old column name (saying DiseaseID does not exist).
    Look like SC7.1 is not refre3shing the SQL changes. I think I have had a problem with this also in SC6

    See images
    Any ideas ?


    SQL_SelectProblem2.jpg

    SQL_SelectProblem1.jpg


    Arthur
    -----------------------------------------
    Arthur Klisiewicz
    dATA POINT SOFTWARE
    www.datapointsoftware.com

  • #2
    If you alter the table and you have changed the sql you need to save first. Then the fieldlist will update. Something might have been gone wrong here and you might want to retry. In grids things needs to be done manually.
    Albert Drent
    aducom software netherlands
    scriptcase partner, reseller, support and (turn-key) development
    www.scriptcase.eu / www.scriptcase.nl

    Comment


    • #3
      Originally posted by aducom View Post
      If you alter the table and you have changed the sql you need to save first.
      I can confirm that it is important ...
      Best regards: - Reinhard -

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

      Comment


      • #4
        I know I need to change this manually, in grid and that's what I did, but for some reason SC keeps the old SQL script.
        I tired to clean browser cache, and even restart Pc, it did not help. I remember I have had those problems in the past, but then I thought I'm doing something wrong. This isn't really a rocket science and doing something wrong here is very unlikely. I noticed SC has lots of problems with changes in the projects. While initial procedures in most cases work fine, when one wants to go back and do some changes there are cases when SC does not respond well. Another exaple of this is DICTIONARY.
        I hope I would not have to recreate all Apps just because I switched from MySQL to SQLite. BTW. I used SQLite PDO (not sure if straight SQLite might make any difference).

        Any ideas to fix this ?

        Arthur
        -----------------------------------------
        Arthur Klisiewicz
        dATA POINT SOFTWARE
        www.datapointsoftware.com

        Comment


        • #5
          Hello Arthur,

          If you have done the steps Albert said, you could try to delete the generated app under ScriptCase folder.

          regards,
          Bernhard Bernsmann

          Comment

          Working...
          X