Altering SQL-Statement in grid fails

Applications Grid / Reports
#1

When altering a sql-statement in the grid definition i got following error:

Trying to get property of non-object | Script: /var/www/scriptcase/devel/lib/php/database.inc.php linha: 882

What does that mean?

Regards Hans

#2

Re: Altering SQL-Statement in grid fails

What database are you working with? Have you tried to create a new grid using the same sql statement to see if it works?

regards,
Bernhard Bernsmann

#3

Re: Altering SQL-Statement in grid fails

I use MySQL 5.5 as database. After creating the SQL-Statement with the SQL-Editor during creating the grid-app the statement works finally. I can also alter the created statement. The error seems to happen even you alter the SQL-statement if a grid depends on a table.

Regards Hans

#4

Re: Altering SQL-Statement in grid fails

Hello Hans,

Let’s make sure that I understood correcly.

You have two tables, Product and Customer. First you created a Grid App on Product,

SELECT ProductID, ProductName
FROM Product

Then you altered the SQL Statement to the Customer table.

SELECT CustomerID, CustomerName
FROM Customer

And that is what caused the error?

regards,
Bernhard Bernsmann

#5

Re: Altering SQL-Statement in grid fails

No,

the problem affects to the same table. In your example for the product-grid I add in the sql-statement another field from the table, ex.: select ProductID, ProductName, ProductPrice.

Regards,
Hans

#6

Re: Altering SQL-Statement in grid fails

Hello,

I have reported this issue to our bugs team for further testing.

After the error message is shown, are you able to add ProductPrice for instance on the Grid?

regards,
Bernhard Bernsmann

#7

Re: Altering SQL-Statement in grid fails

No because the grid depends on the sql-statement.

Regards
Hans