Found bug after adding field in Grid SQL - Please check out... its v6

Fatal error: Call to a member function FieldCount() on a non-object in C:\Program Files\NetMake\v6\wwwroot\scriptcase\devel\lib\php\database.inc.php on line 855

I add the new field in middle of fields list.

now my question is…

how can i add new field in the Grid SQL :frowning:

Hello,
I only ever got this error if there is was really an error in my sql-string of the grid !!!
To add a new field you only have to change the sql-statement. that’s all in grid.
Try to use the sql-statement in another tool to check the syntax (like Navicat, mysql-admin … ) or try it in the
internal SQL-Builder tool

regards
Uwe Pfeiffer

Hi ahmeranis,

Add a space at the beginning and the end of the added field in the SQL select sentence
sample :
<space>old_field,<space>
<space>new_field,<space> (don’t forget the comma)
<space>old_field,<space>

check if these new field really is a valid field in the table structure

Aquiles

You most likely forgot a comma in the fieldlist. The spaces should not be necessary. Copy the sql statement and insert it in the sql builder. It’s an easy way to test the statement.

Hello,

Were you able to solve this issue?

regards,
Bernhard Bernsmann