Leaderboard

SciTE Customization GUI is intended to be your one-stop solution for your SciTE customization needs. With SciTE Customization GUI you can create new themes from scratch without having to touch a single configuration file. Simply select 'Default Theme' from the file menu. This will start you out with a default theme. Then make your changes to the theme. Finally, select 'Save As' from the file menu and give it a name. Or you can select from an already existing theme. You can see live changes to SciTE as you change things around (some settings are not live). You can change various SciTE4AutoIt3 settings such as Tidy, Tools, debug trace messages, etc. I mostly want to try out new ideas which I hope will get used in the official SciTE4AutoIt3. I also wanted to see how large of a program I could script in AutoIt before it become a mass of unmaintable spaghetti. I feel that I am successful in that regard. It is reasonably easy to debug, extend and understand. I feel that this was achieved by employing the Model-View-Controller pattern. I also used AutoItObject which allows me to achieve a level of information hiding which would not have been possible otherwise. I stand on the shoulders of giants so credit where credit is due. Thanks to Jos for the original SciTEConfig. Thanks to Jon for AutoIt. Melba23 for the SciTE Abbreviation Manager and the SciTE UserCalltip Manager. Credits and changelog have be moved to the script. Note: this is not an official script. Jon, Jos or the rest of the AutoIt team do not provide support. That's all up to me. SciTE Customization GUI.zip -- downloads: ~5253 SciTE Customization GUI -- Source.zip -- Includes all of the required dependencies.

The latest version of the GUI Programmer: Vesion Changes : 0.22) Bug fixed when loading Rule for modifying 0.23) Adds the ability to set a Counter to a fixed value so that the user can "reset" the value of a Counter 0.24) Bug fixed: used to add a space infront of the Counters in inputs causing problems to simulator Fixe the _check_syntax() function to accept 0 as value when output is a counter 0.25) - Prevent user entering a pin name containing the words "Virtual_Coil" or "Counter" because causes problems on the function _update_rule_combos_others() - Adds the autocomplete choise when apllying a new rule, which automatically creates another opposite rule For example: if a rule is * Pin_0 = HIGH ==> Pin_5 = HIGH * then the rule * Pin_0 = LOW ==> Pin_5 = LOW * will be automatically created 0.26) - Changed the generated code regarding Counters (each Counter will increase or dicrease only on input toggle) 0.27) - Show the Project name on the window title - Help is available under "Help-How to" 0.28) - The settings combos are disabled only if they have been used inside a Rule 0.29) - Adds the abbility to use an Output as Input (Further testing required) 0.30) - Bug fixed: Pin_A5 was not updated to the rule combos - New feature that enables user to compare 2 analog pins - Improve the generated code conserning the expression feature. (Use of the constrain() Arduino command to limit the values and not if...then) - Improve the generated code conserning analog inputs. (Map the values of AI to a range of 0-255 when reading the pin and not when writing the corresponting output. By doing the mapping at the begining there is no need to remap when comparison of analog pins) - Change the header(top line) of the saved project (This is done so older versions of Arduino Simulator(V0.06 and below) wont open projects with the comparison feature, because they can't handle the rules.) - Bug fixed: Wrong project name when "save as" 0.31) - Minor change in the order of the comparator when comparing analog pins (Division is the default selection) - Show tip text associated with the controls 0.32) - Prevent user entering a pin name containing the character "", because it is used as delimiter at the "Boole calc" function and may create problems. - Bug fixed: When the number of created rules where over 30 they didn't fit at the rule selection combo. Now a scrollbar appears if needed - Three new alternative ways to create rules are added: 1) Boolean Calculator: A calculator like GUI Window that allows the user to create Logical (Boolean) Expressions which are automatically transfered to Rules. 2) Boolean Truth Table (2 Inputs): A Truth Table ready for 2 inputs and 1 output. The entered data are automatically transfered to Rules. 3) Boolean Truth Table (custom Inputs): A generalized Truth Table able to handle more inputs (1-9) 0.33) - Add a space option along with the "AND" and "OR" options in the rule combos - Bug fixed: When the number of inputs is three and above then the opossite rules regarding Virtual Coils are also created. - Bug fixed: Changed the way that counts the open and closed parentheses in the _create_output_from_bool_expression function - When using Bool calculator, user can create an expression with an "Not" in the output to invert the output - Bug fixed: Button 13 on Bool Calculator was not functioning. (An empty label was overlaping) - Changed the symbols for "AND" , "OR" on boole calculator. Now the symbols are: AND -> "*" OR -> "+" - Remove the counters from the combos on bool functions 0.34 - Add the "Preview Truth Table" feature on the Bool Calculator - Some syntax check of the expression in the Bool Calculator - In the "Boolean Truth Table (Custom Inputs)" tool all the possible states of inputs are automatically created - Change the label showing the maximum number of inputs on the "Boolean Truth Table (Custom Inputs)" tool according to the daclared Digital Inputs - Add the "Fill Inputs" button on the "Boolean Truth Table (Custom Inputs)" tool, which automatically sets all the possible states of the inputs - Bug fixed: Program crash when rule was deleted twise - Add a Clear Rules option under the Clear Settings Button 0.35 - Use of a much better way to generate Rules when the "Boole's Calculator" or "Boole's Truth table" are used. The generated Rules and the Virtual Coils used are much less. Arduino Programmer V0.30.au3 Arduino Programmer V0.35.au3 The latest version of the Arduino pseudo simulator: Vesion Changes : 0.02) Counters increase (or dicrease) only when the triger input changes condition 0.03) Bug fixed: Counters were not increased (or dicreased) correctly when the same counter was declared in more than one rule 0.04) Display the type of each pin next to the pin 0.05) Create a list view which shows the rules of the project, so that the user can check on them when testing Show the name of the current project on the window title Bug fixed: Delete the labels that shows the pin state when a second project is opened When the project doesn't have any Rules, Display an error message The How to... under the help menu is active 0.06) Show the pin name next the pin 0.07) Corrections made to handle the new "Compare" feature 0.08) Show control tips when mouse hovers over them 0.09) User can view in real time the states and values of Virtual Coils and Counters Arduino Simulator V0.07.au3 Arduino Simulator V0.09.au3 And some simple examples: Examples.zip Looking forward for comments and recomentations. Thank you all very much

You can use FileInstall or look at AutoItWrapper and the directive #AutoIt3Wrapper_Res_Icon_Add which embeds the ico file in the exe. You'll find more information by looking on the SciTE4AutoIt3 page.

Try adding #RequireAdmin at the top of your script and see if that works for you.

"select * from dbo.AllpagesToday WHERE PageRecip = 'SERVER_OC1' OR PageRecip = 'SERVER_ONCALL' AND Date > '" This should be i think: "select * from dbo.AllpagesToday WHERE (PageRecip = 'SERVER_OC1' OR PageRecip = 'SERVER_ONCALL') AND Date > '" Test the SQL query somewhere outside outoit to see how/if it works.