Jump to content

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Find out more here. X
X


Photo

Refresh GUI


  • Please log in to reply
6 replies to this topic

#1 misterDee

misterDee

    Seeker

  • Active Members
  • 49 posts

Posted 22 December 2009 - 04:26 PM

Hi,

I have a GUI with a working Access database, the GUI gets his information from the database but when im add some text into the database i must restart the GUI to see it, its not LIVE up2date.. is there a command of trick to give a 'refresh' to the GUI?. just like in Internet Explorer (F5)?

Thnx a lot ;)







#2 Melba23

Melba23

    I'm old - what's your excuse?

  • Moderators
  • 21,442 posts

Posted 22 December 2009 - 04:54 PM

misterDee,

I have never worked with AutoIt and Access, so please take this as a helpful suggestion and not a guaranteed solution. ;)

To change the data in AutoIt ususally requires the use of GUICtrlSetData to change the content of a control. So I suggest that you put the whatever code you need to read the data from Access into a loop and then use GUICtrlSetData to update the Autoit control if it alters. I can well imagine that the implementation may be somewhat more complex than that simple statement, but I think it is worth a try unless you get a better idea from someone with Access experience.

Good luck - and do come back if you run into problems.

M23
StringSize - Automatically size controls to fit text                                                               ExtMsgBox - A user customisable replacement for MsgBox
Toast - Small GUIs which pop out of the Systray                                                                Marquee - Scrolling tickertape GUIs
Scrollbars - Automatically sized scrollbars with a single command                                   GUIFrame - Subdivide GUIs into many adjustable frames
GUIExtender - Extend and retract multiple sections within a GUI                                      NoFocusLines - Remove the dotted focus lines from buttons, sliders, radios and checkboxes
ChooseFileFolder - Single and multiple selections from specified path tree structure      Notify - Small notifications on the edge of the display
Date_Time_Convert - Easily convert date/time formats, including the language               GUIListViewEx - Insert, delete, move, drag, sort and edit ListView items

#3 martin

martin

    ~~\o/~~~/0\=¬''~~~

  • MVPs
  • 7,321 posts

Posted 22 December 2009 - 05:58 PM

Hi,

I have a GUI with a working Access database, the GUI gets his information from the database but when im add some text into the database i must restart the GUI to see it, its not LIVE up2date.. is there a command of trick to give a 'refresh' to the GUI?. just like in Internet Explorer (F5)?

Thnx a lot ;)


It might be that what you need is _WinAPI_InvalidateRect.
Serial port communications UDF Includes functions for binary transmission and reception.printing UDF Useful for graphs, forms, labels, reports etc.Add User Call Tips to SciTE for functions in UDFs not included with AutoIt and for your own scripts.Functions with parameters in OnEvent mode and for Hot Keys One function replaces GuiSetOnEvent, GuiCtrlSetOnEvent and HotKeySet.UDF IsConnected2 for notification of status of connected state of many urls or IPs, without slowing the script.

#4 misterDee

misterDee

    Seeker

  • Active Members
  • 49 posts

Posted 22 December 2009 - 11:51 PM

misterDee,

I have never worked with AutoIt and Access, so please take this as a helpful suggestion and not a guaranteed solution. ;)

To change the data in AutoIt ususally requires the use of GUICtrlSetData to change the content of a control. So I suggest that you put the whatever code you need to read the data from Access into a loop and then use GUICtrlSetData to update the Autoit control if it alters. I can well imagine that the implementation may be somewhat more complex than that simple statement, but I think it is worth a try unless you get a better idea from someone with Access experience.

Good luck - and do come back if you run into problems.

M23

Hi Melba,

thnx for your replay.. its simple.. its just a label in the GUI thats takes text from a database that need a live-changing when its changed in the database.. i dont think your command is working for this..? :evil:

#5 misterDee

misterDee

    Seeker

  • Active Members
  • 49 posts

Posted 22 December 2009 - 11:53 PM

It might be that what you need is _WinAPI_InvalidateRect.

Hmm.. i think your closer.. i see the GUI refreshin', but the label doesnt change ;)

$gui=guicreate
_WinAPI_InvalidateRect($gui) that is what you mean?

#6 martin

martin

    ~~\o/~~~/0\=¬''~~~

  • MVPs
  • 7,321 posts

Posted 23 December 2009 - 12:43 AM

Hmm.. i think your closer.. i see the GUI refreshin', but the label doesnt change ;)

$gui=guicreate
_WinAPI_InvalidateRect($gui) that is what you mean?


Yes, but if the gui is one you created with AutoIt and you have a label which shows the data then what Melba23 said is corrcet. You need GuiCtrlSetData($label, $newtext)
Serial port communications UDF Includes functions for binary transmission and reception.printing UDF Useful for graphs, forms, labels, reports etc.Add User Call Tips to SciTE for functions in UDFs not included with AutoIt and for your own scripts.Functions with parameters in OnEvent mode and for Hot Keys One function replaces GuiSetOnEvent, GuiCtrlSetOnEvent and HotKeySet.UDF IsConnected2 for notification of status of connected state of many urls or IPs, without slowing the script.

#7 misterDee

misterDee

    Seeker

  • Active Members
  • 49 posts

Posted 23 December 2009 - 01:39 AM

Yes, but if the gui is one you created with AutoIt and you have a label which shows the data then what Melba23 said is corrcet. You need GuiCtrlSetData($label, $newtext)

Thanks it works, i get the code, easy does it ;)
and thnx to Melba23!!!




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users