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.
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
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!
What RDBMS are you working with?
regards,
Bernhard Bernsmann
Check your sql statement, probably you have syntax problems.
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
Please let us know if you experience this issue again.
regards,
Bernhard Bernsmann