Sign in to follow this  
Followers 0
CurtisWhitby

_GUICtrlListView_CreateArray in Reverse

7 posts in this topic

Hi,

Is there any way to run this function in reverse?

i.e. Create a listview from an array?

Thanks

Share this post


Link to post
Share on other sites



#2 ·  Posted (edited)

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 by Melba23
Oops!

Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind._______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

Or use _GUICtrlListView_AddArray which does that too.


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

Share this post


Link to post
Share on other sites

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)

Share this post


Link to post
Share on other sites

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.


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

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.

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  
Followers 0