sqlite - Flex SQLite显示SUM()结果

Question

我尝试显示来自sqlStmt的Total sum（），但我所得到的只是[object，object]，怎么知道？

谢谢

private function displayAmountHeading():void  {
        sqlStmt = new SQLStatement();
        sqlStmt.sqlConnection = sqlConn;
        sqlStmt.text = "SELECT SUM(Amount) FROM MainTable";
        sqlStmt.execute();
        var result:Array = sqlStmt.getResult().data;
        if (result != null) trace(result);
      }

//return [object, object]

Answer 1

您正在尝试跟踪数组。如果要查看该数组中的第一个值，请尝试

SELECT SUM(Amount) as sum FROM MainTable

trace(result[0].sum);