1 Reply Latest reply on Jul 30, 2011 6:59 AM by Francisc

    SQLite problem

    Francisc Level 3

      Hello,

       

      I'm getting a strange error (after 2 or 3 others):

      RangeError: Error #2006: The supplied index is out of bounds.
          at flash.data::SQLStatement/internalExecute()
          at flash.data::SQLStatement/execute()

       

      The function that generates that error is quite simple:

      public function getMeciuri():Array
      {
          var query:SQLStatement=new SQLStatement();
          query.sqlConnection=sqlConnection;
          query.text='select t1.*,t2.columnX as colX from t1 left join t2 on t1.col=t2.id order by t1.year asc,t1.month asc,t1.day asc,t1.time asc';
          query.execute();
          return query.getResult().data;
      }
      

      So, what's up?

       

      Thank you.

        • 1. Re: SQLite problem
          Francisc Level 3

          OK, managed to figure it out in the end.

           

          I had changed some of the IDs from the table manually, they were still unique and all, but the problem was that the internal SQLite table that was holding data about that table was not updated.

           

          What I did to fix this was export the SQL queries for recreating the structure and data, deleted it and then ran the queries.

          Problem solved.