Thanks a lot "just me" & "jNizM"
I was unable to understand in which variables the output was stored from "SQLiteDB_sample.ahk" , spent nearly 4 days to figure out, and totally lost hope, so was trying luck with "sqlite3.exe."
Yday night figured out this:
Code: Select all
ShowTable(Table) {
Global
Local ColCount, RowCount, Row
MsgBox, 262144,%AppName% %A_LineNumber%, % ColCount "|" RowCount "|" Row
; GuiControl, -ReDraw, ResultsLV
LV_Delete()
Sleep 100
ColCount := LV_GetCount("Column")
MsgBox, 262144,ColCount %A_LineNumber%, % ColCount
Loop, %ColCount%
LV_DeleteCol(1)
MsgBox, 262144,%AppName% %A_LineNumber%, % Table.HasNames
If (Table.HasNames)
{
Loop, % Table.ColumnCount
{
LV_InsertCol(A_Index,"", Table.ColumnNames[A_Index])
MsgBox, 262144,%AppName% %A_LineNumber%, % Table.ColumnNames[A_Index]
}
If (Table.HasRows)
{
MsgBox, 262144,%AppName% %A_LineNumber%, % Table.RowCount
Loop, % Table.RowCount
{
RowCount := LV_Add("", "")
Table.Next(Row)
Loop, % Table.ColumnCount
{
LV_Modify(RowCount, "Col" . A_Index, Row[A_Index])
List1 .= RowCount "|" " Col" . A_Index "|" Row[A_Index] "`r`n"
}
MsgBox, 262144,%AppName% %A_LineNumber%, % List1
}
}
MsgBox, 262144,%AppName% %A_LineNumber%, % Table.ColumnCount
Loop, % Table.ColumnCount
LV_ModifyCol(A_Index, "AutoHdr")
}
GuiControl, +ReDraw, ResultsLV
}