Sub PTampilHistoryItem()
Dim inthari As Int
clvhistory.Clear
Pclvhistory.Initialize(Me, "Pclvhistory", clvhistory)
Try
Dim strsql As String
strsql="select trno from jual " 'count(produk)
Dim Curs As Cursor
Dim i,intbrsjual As Int
Curs = SQL1.ExecQuery(strsql)
Curs.Position = 0
intbrsjual=0
For i = 0 To Curs.RowCount - 1
Curs.Position = i
intbrsjual = intbrsjual+1
Dim ItemHistory1 As ItemHistory
ItemHistory1.nobaris=intbrsjual
ItemHistory1.trno=Curs.GetString("trno")
'Get actual height of layout for PreoptimizedCLV
Dim pnl As B4XView = xui.CreatePanel("")
pnl.LoadLayout("pgmenuhistoryitem")
Dim height As Int = pnl.GetView(0).Height + pnl.GetView(0).Top * 2
Pclvhistory.AddItem(height, xui.Color_White, ItemHistory1)
'Pclvhistory.AddItem(110dip, xui.Color_White, ItemHistory1)
Next
Pclvhistory.Commit
Curs.close
Catch
Log(LastException)
End Try
End Sub