Reload ListView Flicker

[rabothole]

With a function like this i need to reload the whole ListView to get the new values from a database with this i empty the whole ListView and repopulate it like the code below, is there an easier way to do this or some solution to the flickering?

Func _loadUsersListbox()
        _GUICtrlListView_DeleteAllItems($ListView1)
        $var = _Query($sql, "SELECT * FROM sup_users")
        With $var
            While Not .EOF
                $SQL_USR = .Fields("User_Name" ).value
                $SQL_EXT = .Fields("User_Ext" ).value
                $SQL_STA = .Fields("User_Status" ).value
                $SQL_NUM = .Fields("User_Number" ).value
                $listbox_sql_update = $SQL_USR & "|" & $SQL_EXT & "|" & $SQL_STA
                $item1 = GUICtrlCreateListViewItem($listbox_sql_update, $ListView1)
                If $SQL_STA = "LINE BUSY" Then
                    GUICtrlSetBkColor($item1, $iListofflineColor)
                ElseIf $SQL_STA = "AVAILABLE" Then
                    GUICtrlSetBkColor($item1, $iListreadyColor)
                EndIf
                .MoveNext
            WEnd
        EndWith
EndFunc  ;==>_loadUsersListbox

[Zedna]

GuiSetState(@SW_LOCK, $Form1)
; your stuff here ...
GuiSetState(@SW_UNLOCK, $Form1)

[ChrisL]

Read this thread http://www.autoitscript.com/forum/index.ph...c=70227&hl=