Announcement

Collapse
No announcement yet.

[SOLVED]new sql wwith grid

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

  • [SOLVED]new sql wwith grid

    Hello,

    when I change my SQL statement with grid app (for example change the name of a field), fields are not updated as soon as i generate the app. When I hit SAVE first, instead of generating it right away, i get an error message. Then I do have the correct SQL statement saved, but fields are not updated.

  • #2
    Hello,

    After chaning the grid's SQL Statement, are you hitting "Generate App" or "Run App". What error message are you getting?

    Additionally, our bugs team is now aware of this issue.

    regards,
    Bernhard Bernsmann

    Comment


    • #3
      When I change Grid SQL and hit save I get: Fatal error: Call to a member function FieldCount() on a non-object in /.../devel/lib/php/database.inc.php on line 855
      When I hit generate first instead, sometimes I get the same error and sometimes I don't and app is generated...however, fields are not updated!
      When I hit run, same error!

      So I can't just copy a grid and change table in SQL e.g.

      When I create a new grid app and on first page where I can edit table select and SQL statement...when I change the SQL statement and then change the language below, the SQL statement resets itself.

      using current SC version!
      Last edited by poltergeist; 11-25-2012, 05:33 PM.

      Comment


      • #4
        What RDBMS are you working with?

        regards,
        Bernhard Bernsmann

        Comment


        • #5
          Check your sql statement, probably you have syntax problems.

          Comment


          • #6
            What is RDBMS? I am using MySQL and SC latest...no, SQL is correct...when I delete 1 field, this field is deleted in field list as well. When I add a field in MySQL statement, it is not updating the fields list.

            Fatal error: Call to a member function FieldCount() on a non-object in /.../devel/lib/php/database.inc.php on line 855

            Upsa...yes...I had the wrong table in my FROM sql statement...does work now! I guess...I will keep an eye on this...sorry
            Last edited by poltergeist; 11-26-2012, 09:29 PM.

            Comment


            • #7
              Please let us know if you experience this issue again.

              regards,
              Bernhard Bernsmann

              Comment

              Working...
              X