以下SQL 语句如果在AU3 中正确执行

kuselvca

$RS.Open("SELECT * FROM tLogs WHERE sCardID = '510107198508214218' GROUP BY sCardID, sCom, cReceived, cRemainBefore, cRemainAfter, dtTime2, iLength ORDER BY dtTime2 DESC" )

kuselvca

SELECT sCardID AS 会员卡, sCom AS 机器名, dtTime2 AS 下机时间,
      iLength AS [总上机时(分钟)], cReceived AS 实际消费, cRemainBefore AS 原余额,
      cRemainAfter AS 现余额
FROM tLogs
WHERE (sCardID = '510107198508214218')
GROUP BY sCardID, sCom, cReceived, cRemainBefore, cRemainAfter, dtTime2,
      iLength
ORDER BY dtTime2 DESC

这是原SQL 语句

auto

select * 有问题,select 要跟group by 一致才行

shenrenba

$path = "数据库路径"
$a = "tLogs"
$b = "510107198508214218"
_SQLite_Open($path)
_SQLite_Query(-1, "SELECT * FROM " & $a & " where sCardID ='" & $b & "';", $hQuery)
While _SQLite_FetchData($hQuery, $aRow) = $SQLITE_OK
        _GUICtrlListView_AddItem($ListView2, $aRow[0])
        _GUICtrlListView_AddSubItem($ListView2, _GUICtrlListView_FindInText($ListView2, $aRow[0]), $aRow[1], 1)
        _GUICtrlListView_AddSubItem($ListView2, _GUICtrlListView_FindInText($ListView2, $aRow[0]), $aRow[2], 2)
        _GUICtrlListView_AddSubItem($ListView2, _GUICtrlListView_FindInText($ListView2, $aRow[0]), $aRow[3], 3)
        _GUICtrlListView_AddSubItem($ListView2, _GUICtrlListView_FindInText($ListView2, $aRow[0]), $aRow[4], 4)
        _GUICtrlListView_AddSubItem($ListView2, _GUICtrlListView_FindInText($ListView2, $aRow[0]), $aRow[5], 5)
        _GUICtrlListView_AddSubItem($ListView2, _GUICtrlListView_FindInText($ListView2, $aRow[0]), $aRow[6], 6)
WEnd
_SQLite_Close();读取并显示在控件$ListView2上