Jump to content
Sign in to follow this  
czardas

[SOLVED] Inserted ListView Item not deleting

Recommended Posts

czardas

When I use _GUICtrlListView_InsertItem() I don't seem to be able to delete the inserted item. Does anyone know if I'm doing something wrong, or is this the intended behaviour. I could write another function to insert a row into my ListView control, but I would like to know why this method is not working.

It's the empty 3rd row that should have been deleted.

#include <GUIConstants.au3>
#include <WindowsConstants.au3>
#include <GuiListView.au3>

_Run()

Func _SetData($hListView)
    For $i = 0 To 3
        GUICtrlCreateListViewItem( _
        $i + 1 &"|"& _
        "Item " & $i &"|"& _
        "C_" & $i+Random(100,700, 1) &"|"& _
        "D_" & $i+Random(100,700, 1) &"|"& _
        "M_" & $i+Random(100,700, 1) , $hListView)
    Next
    _GUICtrlListView_InsertItem($hListView, "", 2) ; Item to be deleted
EndFunc

Func _Run()
    Local $bStyle = BitOR($GUI_SS_DEFAULT_GUI, $WS_MAXIMIZEBOX)
    Local $hDataBuzz = GUICreate(" AU3 Databuzz", 300,200, Default, Default, $bStyle)

    Local $sHeadings = "Index"
    For $i = 1 To 4
        $sHeadings &= "| "
    Next

    $hListView = GUICtrlCreateListView($sHeadings, 0, 0, 300, 200, _
    BitOR($LVS_REPORT,$LVS_SHOWSELALWAYS))
    _GUICtrlListView_SetExtendedListViewStyle($hListView, _
    BitOR($LVS_EX_FULLROWSELECT, $LVS_EX_GRIDLINES))
    _GUICtrlListView_HideColumn($hListView, 0)

    _SetData($hListView)
    ; _GUICtrlListView_DeleteItem($hListView, 1) ; This works, but =>
    _GUICtrlListView_DeleteItem($hListView, 2) ; This isn't working!

    GUISetState(@SW_SHOW)

    ;================================================================================
    While 1
        $msg = GUIGetMsg()
        If $msg = $GUI_EVENT_CLOSE Then ExitLoop
    WEnd
    ;===============================================================================
EndFunc
Edited by czardas

Share this post


Link to post
Share on other sites
Melba23

czardas,

Mixing native and UDF creation and item functions in ListViews is always fraught with danger - best to stick with one or the other. :)

Here is the script adapted to use the UDF functions - I also moved the GUISetState and added a Sleep so you can see it working: ;)

#include <GUIConstants.au3>
#include <WindowsConstants.au3>
#include <GuiListView.au3>

_Run()

Func _SetData($hListView)
    For $i = 0 To 3
        $iIndex = _GUICtrlListView_AddItem($hListView, $i + 1)
        _GUICtrlListView_AddSubItem($hListView, $iIndex, "Item " & $i, 1)
        _GUICtrlListView_AddSubItem($hListView, $iIndex, "C_" & $i+Random(100,700, 1), 2)
        _GUICtrlListView_AddSubItem($hListView, $iIndex, "D_" & $i+Random(100,700, 1), 3)
        _GUICtrlListView_AddSubItem($hListView, $iIndex, "M_" & $i+Random(100,700, 1), 4)
    Next
    _GUICtrlListView_InsertItem($hListView, "", 2) ; Item to be deleted
EndFunc

Func _Run()
    Local $bStyle = BitOR($GUI_SS_DEFAULT_GUI, $WS_MAXIMIZEBOX)
    Local $hDataBuzz = GUICreate(" AU3 Databuzz", 300,200, Default, Default, $bStyle)

    Local $sHeadings = "Index"
    For $i = 1 To 4
        $sHeadings &= "| "
    Next

    $hListView = _GUICtrlListView_Create($hDataBuzz, $sHeadings, 0, 0, 300, 200, _
    BitOR($LVS_REPORT,$LVS_SHOWSELALWAYS))
    _GUICtrlListView_SetExtendedListViewStyle($hListView, _
    BitOR($LVS_EX_FULLROWSELECT, $LVS_EX_GRIDLINES))
    _GUICtrlListView_HideColumn($hListView, 0)

    GUISetState(@SW_SHOW)

    _SetData($hListView)

    Sleep(1000)

    ;_GUICtrlListView_DeleteItem($hListView, 1) ; This works, but =>
    _GUICtrlListView_DeleteItem($hListView, 2) ; This isn't working!



    ;================================================================================
    While 1
        $msg = GUIGetMsg()
        If $msg = $GUI_EVENT_CLOSE Then ExitLoop
    WEnd
    ;===============================================================================
EndFunc

M23


Public_Domain.png.2d871819fcb9957cf44f4514551a2935.png Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind

Open spoiler to see my UDFs:

Spoiler

ArrayMultiColSort ---- Sort arrays on multiple columns
ChooseFileFolder ---- Single and multiple selections from specified path treeview listing
Date_Time_Convert -- Easily convert date/time formats, including the language used
ExtMsgBox --------- A highly customisable replacement for MsgBox
GUIExtender -------- Extend and retract multiple sections within a GUI
GUIFrame ---------- Subdivide GUIs into many adjustable frames
GUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView items
GUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeView
Marquee ----------- Scrolling tickertape GUIs
NoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxes
Notify ------------- Small notifications on the edge of the display
Scrollbars ----------Automatically sized scrollbars with a single command
StringSize ---------- Automatically size controls to fit text
Toast -------------- Small GUIs which pop out of the notification area

 

Share this post


Link to post
Share on other sites
czardas

Thanks. I can see that this is going to be tricky. I may be have to change much more of my code than I had hoped, or I may have to compromise for the time being. I also experienced the same problem with deleting items after using _GUICtrlListView_AddArray so I wrote another function to add the array. I currently need to contemplate time constraints. The phone rings as I speak.

Share this post


Link to post
Share on other sites
czardas

Actually, after a quick analysis, it doesn't look all that bad. I think I'll be able to make the changes needed quite quickly. Whether everything will still work afterwards is unknown, but your explanation gives me a clearer picture. Thanks again. :)

Share this post


Link to post
Share on other sites
czardas

I have been thinking about this for most of a sleepless night. I haven't been brave enough to attempt the changes yet since there appear to be significant differences between the two different ways of creating a ListView control; and I have the feeling that no matter which root I take, I will need to make a lot of adjustments. Until I try I won't really know the outcome.

My concern is as follows: all the help file examples for the conflicting UDF functions mentioned above use GUICtrlCreateListView, which is a native function. If this is a risky affair, then many of the ListView help file functions would appear to need rewriting. I will be trying the changes with some trepidation withiin the next 48 hours, but I feel I ought to mention my concerns about these help file examples and the accompanying documentation.

Edited by czardas

Share this post


Link to post
Share on other sites
Melba23

czardas,

The Help file examples work because they do not mix the creation functions. The _GUICtrlListView_DeleteItem Example1 uses the native functions to create the ListView AND add the items - Example_UDF_Created uses the UDF functions to create the ListView AND add the items.

In your script above, you were mixing native and UDF functions to add items:

Func _SetData($hListView)
    For $i = 0 To 3
        GUICtrlCreateListViewItem( _  ; <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
        $i + 1 &"|"& _
        "Item " & $i &"|"& _
        "C_" & $i+Random(100,700, 1) &"|"& _
        "D_" & $i+Random(100,700, 1) &"|"& _
        "M_" & $i+Random(100,700, 1) , $hListView)
    Next
    _GUICtrlListView_InsertItem($hListView, "", 2) ; Item to be deleted ; <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
EndFunc

It is this which caused your problem. ;)

ListView are complex beasts and although the UDF functions normally work on native created ListViews, mixing the creation functions is a sure-fire way of getting them to fail. If you need to use _GUICtrlListView_InsertItem to interleave items into your existing ListView then I believe you will have to change the whole script to use the UDF functions.

Sorry not to be more optimistic. I can only imagine that there is something that AutoIt native functions do the ListView which makes it incompatible with the UDF functions - and as it is probably buried deep in the core code we are unlikely to see any changes. :)

M23


Public_Domain.png.2d871819fcb9957cf44f4514551a2935.png Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind

Open spoiler to see my UDFs:

Spoiler

ArrayMultiColSort ---- Sort arrays on multiple columns
ChooseFileFolder ---- Single and multiple selections from specified path treeview listing
Date_Time_Convert -- Easily convert date/time formats, including the language used
ExtMsgBox --------- A highly customisable replacement for MsgBox
GUIExtender -------- Extend and retract multiple sections within a GUI
GUIFrame ---------- Subdivide GUIs into many adjustable frames
GUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView items
GUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeView
Marquee ----------- Scrolling tickertape GUIs
NoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxes
Notify ------------- Small notifications on the edge of the display
Scrollbars ----------Automatically sized scrollbars with a single command
StringSize ---------- Automatically size controls to fit text
Toast -------------- Small GUIs which pop out of the notification area

 

Share this post


Link to post
Share on other sites
czardas

If you need to use _GUICtrlListView_InsertItem to interleave items into your existing ListView then I believe you will have to change the whole script to use the UDF functions.

Although I know a fix for the code which I have at present, I was concerned that all future functions which I intend to write might run into the same problem. It looks like I will have to change everything to use UDF functions. I just did a complete overhaul to functions which enable and disable menu items, and I'm finding Undo / Redo buffers quite a challenge. Sometimes it seems that each new thing you add involves a complete rewrite, as if I'm constantly barking up the wrong tree.

;)

Now I understand this more clearly. The UDF ListView behaves differently. For example grid lines do not appear to extend to fill empty the space. You can see this difference if you maximize the two versions above. I need to know what else might be different, and perhaps mess around with GUI and control backgrouds etc. We're lucky that there are experienced coders around, like you, to explain this stuff. Much appreciated.

:)

Edited by czardas

Share this post


Link to post
Share on other sites
BrewManNH

The Listview UDF functions don't work well with control IDs when referring to the Listview itself. You should always use the function GUICtrlGetHandle to get the handle of the ListView when using the UDF functions. They will accept the control ID of the listview in the functions, but odd things happen when you do it that way. If you make sure that all your function calls to _GUICtrlListview_xxx use the handle, it will be much easier to work with them.


If I posted any code, assume that code was written using the latest release version unless stated otherwise. Also, if it doesn't work on XP I can't help with that because I don't have access to XP, and I'm not going to.
Give a programmer the correct code and he can do his work for a day. Teach a programmer to debug and he can do his work for a lifetime - by Chirag Gude
How to ask questions the smart way!

I hereby grant any person the right to use any code I post, that I am the original author of, on the autoitscript.com forums, unless I've specifically stated otherwise in the code or the thread post. If you do use my code all I ask, as a courtesy, is to make note of where you got it from.

Back up and restore Windows user files _Array.au3 - Modified array functions that include support for 2D arrays.  -  ColorChooser - An add-on for SciTE that pops up a color dialog so you can select and paste a color code into a script.  -  Customizable Splashscreen GUI w/Progress Bar - Create a custom "splash screen" GUI with a progress bar and custom label.  -  _FileGetProperty - Retrieve the properties of a file  -  SciTE Toolbar - A toolbar demo for use with the SciTE editor  -  GUIRegisterMsg demo - Demo script to show how to use the Windows messages to interact with controls and your GUI.  -   Latin Square password generator

Share this post


Link to post
Share on other sites
czardas

Thanks BrewManNH, Ill bear that in mind.

I tried to implement _GUICtrlListView_InsertItem() but it was no surpise to me that it failed. Sometimes you just have to keep climbing whichever rock you are climbing. This is one of those occasions where turning back is not an option.. I have found a solution which allows me to insert multiple items using GUICtrlCreateListViewItem() , although it's a little bit complicated since GUICtrlCreateListViewItem() only appends items at the end of the control. The code is messy and it would take too long to write a reproducer, so instead of that, I have written a simulation of this method using _ArrayDisplay() to represent the ListView control. While the method may not be ideal, it could have practical application elsewhere.

Simulation

Imagine that after deleting multiple selected items from a ListView control, the user decides to undo their previous action. This requires inserting multiple rows back into their original positions. A number of possibilities exist, but this method adds them to the end of the ListView first, and repositions them later. To do this, the original Index numbers need to be put back the way they were before deleting the rows. Positioning is then just a question of sorting on an index column. As it happens my original script has a hidden index column.

Reconstruction

#include <Array.au3>

Dim $aListView[4][2] = [[1,"Item 2"],[2,"Item 3"],[3,"Item 6"],[4,"Item 7"]] ; Snapshot after deleting Item 1, Item 4 and Item 5
Dim $aAction2Undo[4][2] = [[3,""],[4,"Item 5"],[3,"Item 4"],[0,"Item 1"]] ; Undo Buffer

_ArrayDisplay($aListView, "After Deleting Rows",-1,0,"","","Row|Index|Data") ; Simulate ListView Control

_UndoDelete($aListView, $aAction2Undo)

_ArrayDisplay($aListView, "After Undo Delete",-1,0,"","","Row|Index|Data") ; Simulate ListView Control

Func _UndoDelete(ByRef $aListView, $aAction2Undo)
    Local $iCount = $aAction2Undo[0][0], $iRows = UBound($aListView), $iOccurence = 3 ; $iOccurence is stored elsewhere

    ; Reconstruct original indeces (Code needs to be streamlined)
    $j = 0
    For $i = 1 To $iOccurence
        For $j = $j To $iRows -1
            If $aListView[$j][0] = $aAction2Undo[$iCount][0] +1 Then
                For $k = $j To $iRows -1
                    $aListView[$k][0] += 1
                Next
                $iCount -= 1
                ExitLoop
            EndIf
        Next
    Next

    For $i = $aAction2Undo[0][0] To $aAction2Undo[0][0] - $iOccurence +1 Step -1 ; From the original script
        ; Redo Buffer code omitted for this simulation

        ; Simulate GUICtrlCreateListViewItem
        ReDim $aListView[UBound($aListView) +1][2] ; Append Rows
        $aListView[UBound($aListView) -1][0] = $aAction2Undo[$i][0] +1
        $aListView[UBound($aListView) -1][1] = $aAction2Undo[$i][1]
    Next

    _ArraySort($aListView) ; Simulate _GUICtrlListView_SimpleSort

    ; Clear Undo Buffer code omitted for this simulation
EndFunc

The code I have written for the real ListView control is heavily embedded code and it struck me that using array functions would make it easier to demonstrate how I solved this problem. Since I no longer need to use _GUICtrlListView_InsertItem() everything is working again.

Finally, it appears that however ListView Control Items are created must be consistant throughout the script. Which is what Melba told me earlier. :) Now to write the Redo function. ;)

Edited by czardas

Share this post


Link to post
Share on other sites
czardas

The Listview UDF functions don't work well with control IDs when referring to the Listview itself. You should always use the function GUICtrlGetHandle to get the handle of the ListView when using the UDF functions. They will accept the control ID of the listview in the functions, but odd things happen when you do it that way. If you make sure that all your function calls to _GUICtrlListview_xxx use the handle, it will be much easier to work with them.

I was just wondering if this only affects ListView controls created using _GUICtrlListView_Create() , since I have never had a problem with my ListView which is created using GUICtrlCreateListView() .

Share this post


Link to post
Share on other sites
BrewManNH

Actually, it (meaning the ListView UDF functions) has more of a problem with Listviews created with GUICtrlCreateListview because the value returned is a control ID and not a handle. If you're using the UDF functions, then you need to reference the handle of the LV, if you're using the native functions, you need the controlID.


If I posted any code, assume that code was written using the latest release version unless stated otherwise. Also, if it doesn't work on XP I can't help with that because I don't have access to XP, and I'm not going to.
Give a programmer the correct code and he can do his work for a day. Teach a programmer to debug and he can do his work for a lifetime - by Chirag Gude
How to ask questions the smart way!

I hereby grant any person the right to use any code I post, that I am the original author of, on the autoitscript.com forums, unless I've specifically stated otherwise in the code or the thread post. If you do use my code all I ask, as a courtesy, is to make note of where you got it from.

Back up and restore Windows user files _Array.au3 - Modified array functions that include support for 2D arrays.  -  ColorChooser - An add-on for SciTE that pops up a color dialog so you can select and paste a color code into a script.  -  Customizable Splashscreen GUI w/Progress Bar - Create a custom "splash screen" GUI with a progress bar and custom label.  -  _FileGetProperty - Retrieve the properties of a file  -  SciTE Toolbar - A toolbar demo for use with the SciTE editor  -  GUIRegisterMsg demo - Demo script to show how to use the Windows messages to interact with controls and your GUI.  -   Latin Square password generator

Share this post


Link to post
Share on other sites
czardas

If you say this is the case then I won't dispute it. Perhaps if I had multiple List View controls active at the same time I would have come across this problem. The only problem I encountered was the incompatibility of mixing List View creation functions mentioned earlier (now resolved). What I am writing is unlikely to get to public release stage any time soon (if I ever release it at all), however I will thoroughly test it if I do release it.

Although the program is only half written, I started using it today. I have until the end of the Month to prepare my accounts (Government Deadline) and I find using Excel tedious as regards data input, besides being non portable and bloated as regards advanced macros. All I need is a simple table with an accumilative balance and column totals. I don't want to write cell formulas or keep upgrading (paying for) an office program which for my purposes is complete overkill. Although Office is a brilliant program, it's also generally very annoying.

It has only taken me two months to get to this stage, and seeing the program append an accumilative balance column on a years transactions in the blink of an eye makes me very happy. My app also doubles up as a DB and I'm already using it to store professional contact information. Eventually i will implement some easy to use features that normally would require advanced computer skills when done with MS Office. These will include a few basic accounting formulas and date formatting functions; plus a search engine which will include a diacritic case sensitivity option, since much of my work involves Spanish words and phrases. The program works with csv tsv and dat formats.

Thanks everyone for all your advice. I have reached a major stage in this project's development. :)

Edited by czardas

Share this post


Link to post
Share on other sites
czardas

Just a note to say: BrewManNH, you were bang on the money. Passing the control handle to the UDF functions has solved my problems.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Similar Content

    • Broihon
      By Broihon
      Hey guys,

      I ran into a problem when I wanted to delete items of a listview using the delete key. My approach is to register my own WndProc for the listview and then filter the $WM_GETDLGCODE msg and then call the original WndProc.
      That works like a charm. The problem is that when the listview gets redrawn it somehow ends up in an infinite loop. The listview is suddenly emtpy and I can't interact with any controls of the GUI at all. Here's the code:
       
      #include <GUIConstantsEx.au3> #include <GUIListView.au3> #include <WinAPI.au3> $h_GUI = GUICreate("Test", 200, 200, 350, 350) $h_LV = GUICtrlCreateListView("Col 1|Col 2|Col 3", 0, 0, 200, 200) _GUICtrlListView_AddItem($h_LV, "") _GUICtrlListView_AddSubItem($h_LV, 0, "bla0", 0) _GUICtrlListView_AddSubItem($h_LV, 0, "bla0", 1) _GUICtrlListView_AddSubItem($h_LV, 0, "bla0", 2) _GUICtrlListView_AddItem($h_LV, "") _GUICtrlListView_AddSubItem($h_LV, 1, "bla1", 0) _GUICtrlListView_AddSubItem($h_LV, 1, "bla1", 1) _GUICtrlListView_AddSubItem($h_LV, 1, "bla1", 2) _GUICtrlListView_AddItem($h_LV, "") _GUICtrlListView_AddSubItem($h_LV, 2, "bla2", 0) _GUICtrlListView_AddSubItem($h_LV, 2, "bla2", 1) _GUICtrlListView_AddSubItem($h_LV, 2, "bla2", 2) _GUICtrlListView_AddItem($h_LV, "") _GUICtrlListView_AddSubItem($h_LV, 3, "bla3", 0) _GUICtrlListView_AddSubItem($h_LV, 3, "bla3", 1) _GUICtrlListView_AddSubItem($h_LV, 3, "bla3", 2) $h_LV_NewWndProc = DllCallbackRegister("WndProc_LV", "int", "hwnd;uint;wparam;lparam") $g_LV_OldWndProc = _WinAPI_SetWindowLong(GUICtrlGetHandle($h_LV), $GWL_WNDPROC, DllCallbackGetPtr($h_LV_NewWndProc)) GUISetState(@SW_SHOW) Func WndProc_LV($hWnd, $uMsg, $wParam, $lParam) Return _WinAPI_CallWindowProc($g_LV_OldWndProc, $hWnd, $uMsg, $wParam, $lParam) EndFunc ;==>WndProc_GUI Do Until GUIGetMsg() = $GUI_EVENT_CLOSE DllCallbackFree($h_LV_NewWndProc) As you can see I'm doing nothing in the WndProc of the listview. I'm simply calling the original WndProc. This still "freezes" when I mess with the width of the columns or in the original project when I add more items that they don't fit in the listview and I have to scroll. If I don't do that it's working fine.
    • c.haslam
      By c.haslam
      I have
      Local $idListview = GUICtrlCreateListView("",8,8,@DesktopWidth/2-16,@DesktopHeight-150,$LVS_SHOWSELALWAYS, _ $LVS_EX_INFOTIP) Local $hListView = GUICtrlGetHandle($idListview) _GUICtrlListView_InsertColumn($hListview, 0, "Filename", 400) _GUICtrlListView_InsertColumn($hListview, 1, "Ext", 50) _GUICtrlListView_InsertColumn($hListview, 2, "Size",70) _GUICtrlListView_InsertColumn($hListview, 3, 'Date time',100) _GUICtrlListView_InsertColumn($hListview, 4, "Path", 385) _GUICtrlListView_InsertColumn($hListview, 5, "sizeInt", 0) _GUICtrlListView_JustifyColumn($hListview, $kSize,1) ; right align then further on
      While True $sFnamExt = FileFindNextFile($iSrch) If @error Then ExitLoop EndIf $sAtts = FileGetAttrib($sPath&'\'&$sFnamExt) If StringInStr($sAtts,'D') Then If $sFnamExt<>'$RECYCLE.BIN' Then $sDirs &= '?'&$sPath&'\'&$sFnamExt EndIf Else $p = StringInStr($sFnamExt,'.',0,-1) ; last If $p=0 Then $sFnam = $sFnamExt $sExt = '' Else $sFnam = StringLeft($sFnamExt,$p-1) $sExt = StringTrimLeft($sFnamExt,$p) EndIf _GUICtrlListView_AddItem($hListview,$sFnam,-1,_GUICtrlListView_GetItemCount($hListview)+1000) _GUICtrlListView_AddSubItem($hListview,$nItem,$sExt,$kExt) $nSize = FileGetSize($sPath&'\'&$sFnamExt) $sSize = AddThousandsSeparator($nsize) _GUICtrlListView_AddSubItem($hListview,$nItem,$sSize,$kSize) _GUICtrlListView_AddSubItem($hListview,$nItem,$nsize,$kSizeInt) $nTotBytes += $nSize $a1 = FileGetTime($sPath&'\'&$sFnamExt,$FT_MODIFIED,$FT_ARRAY) $t = $a1[0]&'-'&$a1[1]&'-'&$a1[2]&' '&$a1[3]&':'&$a1[4] _GUICtrlListView_AddSubItem($hListview,$nItem,$t,$kDateTime) _GUICtrlListView_AddSubItem($hListview,$nItem,$sPath,$kPath) If $gSQL Then $s = "Insert into tbl values ("&_SQLite_Escape($sFnam)&","&_SQLite_Escape($sExt)&",'"& _ $sSize&"','"& _ $t&"',"&_SQLite_Escape($sPath)&","&$nSize&")" _SQLite_Exec(-1,$s) If @error Then MsgBox(0,@ScriptLineNumber,_SQLite_ErrMsg()) EndIf EndIf EndIf WEnd FileClose($iSrch) You will see that I heeded the advice in Help > _GUICtrlListView_AddItem: "As AutoIt uses the $iParam parameter to store the controlID of native-created ListView items, this value should be set sufficiently high for UDF-created items to avoid possible conflict with any existing controls - a starting value of 1000 is recommended."
      (It's unfortunate that the Example does not heed this advice. OK, it doesn't need to because there are no other controls, but still --- it would help neophytes if it did. Also to me _GUICtrlListView_AddItem is not native because it is a UDF. Confused?)
      My script then does a sort using SQLite, and updates the ListView:
      Local $hQuery Local $colNames = ['fnam','ext','nsize','dateTime','path','SizeInt'] Local $s = "Select * FROM tbl ORDER BY "&$colNames[$ncol]&';' _SQLite_Query(-1,$s, $hQuery) If @error Then MsgBox(0,@ScriptLineNumber,_SQLite_ErrMsg()) EndIf Local $aRow[$kSizeInt+1] Local $iItem=-1 While _SQLite_FetchData($hQuery, $aRow, False, False) = $SQLITE_OK ; Read Out the next Row If @error Then MsgBox(0,@ScriptLineNumber,_SQLite_ErrMsg()) EndIf $iItem += 1 For $i = $kFnam To $kSizeInt _GUICtrlListView_SetItem($hListview,$aRow[$i],$iItem,$i,Default) Next WEnd This works, but I had earlier coded
      _GUICtrlListView_SetItem($hListview,$aRow[$i],$iItem,$i,Default,$iItem+1000) because the same advice is in the Help for this function.
      So my care in specifying $param back-fired! What am I not understanding?
      The only difference in what works is that the $param parameter is defaulted.
    • FrancescoDiMuro
      By FrancescoDiMuro
      Good evening everyone
      I am building a management for the company I work with, and I just imported a real amount of rows ( about 29000 ), in my SQLite DB.
      The thing I am not understanding, is the time that the script takes to build this amount of rows in the ListView.
      I didn't measure it, but I think it took 2 minutes or so to create each ListView item...
      It is normal that it takes so much time?
      What can I do to improve the creation of the items?

      Here's the code I am using to query and to create ListView items...
      ; Articles ListView: Global $lvwArticles = GUICtrlCreateListView("ID|Fornitore|Codice|Descrizione|EU|Prezzo|Sconto Applicato|Note", 14, 87, 1507, 660, BitOR($GUI_SS_DEFAULT_LISTVIEW,$LVS_SORTASCENDING,$LVS_SORTDESCENDING), BitOR($WS_EX_CLIENTEDGE,$LVS_EX_GRIDLINES,$LVS_EX_FULLROWSELECT)) ; Query $strQuery = "SELECT * FROM ARTICOLI;" ; Query Execution _SQLite_GetTable2d($objDatabase, $strQuery, $arrResult, $intRows, $intColumns) If @error Then ; Error Handling Else ; Cleaning the ListView _GUICtrlListView_DeleteAllItems($lvwArticles) If @error Then ; Error Handling Else ; No records in the Table If UBound($arrResult) < 2 Then ; Error Handling Else _GUICtrlListView_BeginUpdate($lvwArticles) For $intCounter = 1 To UBound($arrResult) - 1 $strListViewItem = $arrResult[$intCounter][0] & "|" & _ $arrResult[$intCounter][1] & "|" & _ $arrResult[$intCounter][2] & "|" & _ $arrResult[$intCounter][3] & "|" & _ $arrResult[$intCounter][4] & "|" & _ $arrResult[$intCounter][5] & "|" & _ $arrResult[$intCounter][6] & "|" & _ $arrResult[$intCounter][7] $objListViewItem = GUICtrlCreateListViewItem($strListViewItem, $lvwArticles) Next _GUICtrlListView_EndUpdate($lvwArticles) EndIf EndIf EndIf Thanks in advance


      Best Regards.
    • Skysnake
      By Skysnake
      I am tracking this topic by @LarsJ.  It is very advanced and overkill for what I am currently trying to do.
       
      Problem is this.
      Listview contains columns, one of which is right aligned and gets populated by float values, such as 123.99.  Some do not have decimals ie 124.00 and on sort gets truncated to 124.  Its obviously still the same value, but the display has reset.
      ; line below is for list VIEW ;..................................0.........1......2............ $cListView = GUICtrlCreateListView("CUSTOMER|AMOUNT|DESCRIPTION", 8, 152, 764, 279) GUICtrlSetBkColor($cListView, $GUI_BKCOLOR_LV_ALTERNATE) ; alternate between the listview background color and the listview item background color GUICtrlSetBkColor($cListView, $LVStdClr) ; Set the background color for the listview _GUICtrlListView_SetColumnWidth($cListView, 0, 120) ; -- the client name _GUICtrlListView_SetColumnWidth($cListView, 1, 90) ;-- the amount _GUICtrlListView_JustifyColumn($cListView, 1, 1) ; 1 - Text is right aligned _GUICtrlListView_SetColumnWidth($cListView, 2, 200) ; the description What I am looking for is something native and simple like a 
          _GUICtrlListView_SetColumnFormat($cListView, 1, "%.2f") ;  1 - column is stringformatted to "%.2f"
      So that after each sort it will appear as it was in the original rendering.
      Is there something like this? I have not been able to find a simple solution.

      Thanks.
      Skysnake
    • Ambient
      By Ambient
      I have tried several way sto get this to work to no avail. Any help would be appreciated. #include <ListViewConstants.au3> #include <GuiListView.au3> #include "GuiListViewEx.au3" $idItem = GUICtrlCreateListViewItem($r & " | " & $c & $adoRs.Fields("TransactionAmount").value & " | " & $Timestamp & " | " & _StringProper($adoRs.Fields("Tillid").value) & @CRLF & @CRLF & "Card Number : " & $cardnum & " " , $idListView) ConsoleWrite( "IDITEM" & $idItem) If STRINGLEFT($adoRs.Fields("TransactionAmount").value,1)= "-" Then Consolewrite(" String is Negative" & @CRLF) ;Drops in Here as expected ;GUICtrlSetColor(-1, $COLOR_RED) ; Colour line if item is negative this didn' work $TxC= _GUICtrlListView_SetTextColor($hListView, $CLR_RED) ; I also tried $TxC= _GUICtrlListView_SetTextColor(-1, 0xFF0000) CONSOLEWRITE("TEXTCOLOUR RETURNED " & $TxC & @crlf) ; This is returning True ELSE Consolewrite(" String is NOT Negative" & @CRLF) EndIf  
×