_GUICtrlListView_CreateArray in Reverse

[CurtisWhitby]

Hi,

Is there any way to run this function in reverse?

i.e. Create a listview from an array?

Thanks

[Melba23]

CurtisWhitby,

Why do you need a UDF - you can easily run through the array and create the ListView items as you go?

But my GUIListViewEx UDF can do it for you automatically - you can find it via the link in my sig. Take a look and post in that UDF thread if you need help.

I forgot there is already a function to do it.

M23

Edited August 9, 2012 by Melba23
Oops!

[BrewManNH]

Or use _GUICtrlListView_AddArray which does that too.

[Yashied]

Nice UDF.

I advise you to use DllCall() instead of _GUICtrlListView_GetItemText(). This will greatly increase the speed of your function because will not need to create a structure each time.

[CurtisWhitby]

Why do you need a UDF - you can easily run through the array and create the ListView items as you go?

I didn't know if I needed a UDF or not.

Or use _GUICtrlListView_AddArray which does that too.

I've had a look at that but can't seem to get it working.

This is my code:

#include "MySQL.au3"
#include "GUIConstants.au3"
#include "GUIListView.au3"

$SQLInstance = _MySQLConnect ("root", "*****", "dev", "localhost")

$TableContents = _Query($SQLInstance, "SELECT * FROM partylist")

GUICreate("SQL", 500, 500)
GUISetState(@SW_SHOW)

$list = GUICtrlCreateListView("ID|First|Last|Invite|Attending", 5, 5, 490, 490)

_GUICtrlListView_AddArray($list, $TableContents)

While 1
Switch GUIGetMsg()

Case $GUI_EVENT_CLOSE
Exit

EndSwitch
WEnd

_MySQLEnd ($SQLInstance)

[BrewManNH]

I've had a look at that but can't seem to get it working.

This is my code:

Is $TableContents a 2D array? Is it an array at all? Is there an error when you run this? "can't seem to get it working" and posting code I can't run is not a good way to get help.

Also, derailed this thread far enough. It's a better idea to open a new thread in General Help & Support if further help is required.

[CurtisWhitby]

Sorry, I should have given more information.

"dev" is an SQL database.

It consists of one table: "partylist".

Table structure:

RecordID | FirstName | LastName | InviteSent | Attending

----------------------------------------------------------------------

1 | Jim | Nasium | 1 | 1

2 | Bill | Fold | 0 | 0

3 | Jen | Tull | 1 | 0

4 | Justin | Time | 0 | 0

5 | Paige | Turner | 1 | 1

#include "MySQL.au3" is the UDF found

I was following the tutorial here.

Partway down the page it says "The entire partylist table is now in an array contained by the $TableContents variable."

So yes, $TableContents is an array. But I have no idea if it is 2D.

I also get no errors when running the script.

I'm really sorry if I have just missed something obvious.

Thanks in advance.