johnynardi Posted May 31, 2012 Posted May 31, 2012 Hallo guys iam trying to build a script the give you msgbox every time that row add to my access DB. any idea how can i do it?
hannes08 Posted June 1, 2012 Posted June 1, 2012 There's an _sql UDF in the Example section of the forum. I think it is capable of accessing Access DBs. You can use simple SQL statements to count the lines. Regards,Hannes[spoiler]If you can't convince them, confuse them![/spoiler]
johnynardi Posted June 2, 2012 Author Posted June 2, 2012 well this is what i did i did a count statement and i got to line... but how can i get an msgbox if anther line was added.. heres the code... of what i did While 1 $msg = GUIGetMsg() If $msg = $GUI_EVENT_CLOSE Then ExitLoop if $msg = $send Then sendMsg() EndIf DataRow() WEnd Func DataRow() $query1= "SELECT Count(Dt_user.Msg) AS [Count] FROM Dt_user;" $Size = $adoCon.Execute($query1) $Rows_Temp = $Size.Fields( "Count" ).Value EndFunc
johnynardi Posted June 2, 2012 Author Posted June 2, 2012 Hallo guys iam trying to build a script the give you msgbox every time that row add to my access DB.well this is what i didi did a count statement and i got to line...but how can i get an msgbox if anther line was added..any idea how can i do it? heres the code... of what i didWhile 1 $msg = GUIGetMsg() If $msg = $GUI_EVENT_CLOSE Then ExitLoop if $msg = $send Then sendMsg() EndIf DataRow() WEnd Func DataRow() $query1= "SELECT Count(Dt_user.Msg) AS [Count] FROM Dt_user;" $Size = $adoCon.Execute($query1) $Rows_Temp = $Size.Fields( "Count" ).Value EndFunc
Moderators Melba23 Posted June 2, 2012 Moderators Posted June 2, 2012 johnynardi,How about you stick to just the one topic at a time. And post it in the correct place - "Examples" is for exactly that, not help requests. I have merged the 2 topics this time - please do not make me do it again. M23 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 columnsChooseFileFolder ---- Single and multiple selections from specified path treeview listingDate_Time_Convert -- Easily convert date/time formats, including the language usedExtMsgBox --------- A highly customisable replacement for MsgBoxGUIExtender -------- Extend and retract multiple sections within a GUIGUIFrame ---------- Subdivide GUIs into many adjustable framesGUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView itemsGUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeViewMarquee ----------- Scrolling tickertape GUIsNoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxesNotify ------------- Small notifications on the edge of the displayScrollbars ----------Automatically sized scrollbars with a single commandStringSize ---------- Automatically size controls to fit textToast -------------- Small GUIs which pop out of the notification area
hannes08 Posted June 5, 2012 Posted June 5, 2012 try something like this: Global $rows, $new_rows $rows = DataRows() While 1 $msg = GUIGetMsg() If $msg = $GUI_EVENT_CLOSE Then ExitLoop If $msg = $send Then sendMsg() EndIf $new_rows = DataRows() If $new_rows > $rows Then $rows = $new_rows ;Your Message Box goes here! EndIf WEnd Func DataRows() $query1= "SELECT Count(Dt_user.Msg) AS [Count] FROM Dt_user;" $Size = $adoCon.Execute($query1) Return $Size.Fields( "Count" ).Value EndFunc Regards,Hannes[spoiler]If you can't convince them, confuse them![/spoiler]
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now