Announcement

Collapse
No announcement yet.

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

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

  • 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.
    Website Design

  • #2
    now my question is...

    how can i add new field in the Grid SQL
    Website Design

    Comment


    • #3
      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

      Comment


      • #4
        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
        Last edited by aquiles; 01-14-2013, 05:50 AM.

        Comment


        • #5
          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.
          Albert Drent
          aducom software netherlands
          scriptcase partner, reseller, support and (turn-key) development
          www.scriptcase.eu / www.scriptcase.nl

          Comment


          • #6
            Hello,

            Were you able to solve this issue?

            regards,
            Bernhard Bernsmann

            Comment

            Working...
            X