Timeline
Oct 10, 2011:
- 4:58 PM Ticket #1989 (#include fails badly if the included file has BOM) updated by
- What format was it saved in exactly and which BOM (UTF8, UTF16 LE BE...)? All the AutoIt text file functions use the same code (File...() #include, etc.) and they all support BOMs.
- 4:43 PM Ticket #1950 (Add APIConstants.au3 and WinAPIEx.au3 and APIErrors.au3) updated by
- I agree with mvg. WinAPI and WinAPI should not be merged, WinAPIEx itself is already ballooning towards 2 MBs, and takes a few seconds to load Separation is needed how ever that occurs.
- 1:39 PM Ticket #1498 (#RequireAdmin causes script to not complete/run when UAC is turned off ...) updated by
- Why the fuck, if I may, was this bug rejected? It is a serious issue!
Oct 9, 2011:
- 11:12 PM Ticket #2031 (_GUICtrlStatusBar_SetBkColor() not working) created by
- _GUICtrlStatusBar_SetBkColor() example does not work and the function …
- 9:00 PM Ticket #2030 (_WinAPI_GetLastErrorMessage - accept specified error code parameter) updated by
-
Version changed
Automatic ticket cleanup. - 8:50 PM Ticket #2030 (_WinAPI_GetLastErrorMessage - accept specified error code parameter) created by
- […]
- 4:05 PM Ticket #2028 (Bit* function examples are too cryptic to be meaningful) updated by
- That answer is unacceptable.
- 2:22 PM Ticket #2029 (Array and variable handling / suggestion) created by
- 1. Accessing temporary arrays This could be a cool feature, and in …
- 2:15 AM Ticket #2028 (Bit* function examples are too cryptic to be meaningful) closed by
- Rejected: Honestly, if you need examples to show you how to use the Bit functions then you probably don't need the Bit functions. The examples are fine. Looking at raw bits is an advanced feature anyway.
- 2:13 AM Ticket #1451 (RegRead) updated by
- Replying to anonymous: > What about also making the second parameter optional? > > {{{ > RegRead ( "keyname", valuename ) > }}} This adds nothing useful.
- 12:41 AM Ticket #2027 (;-)) closed by
- Wont Fix: Which planet are you from where it's acceptable to use emoticons as issue titles? Whatever planet it is I hope it's destroyed soon if everybody does such idiotic things. This is a bug but it will not be fixed. It has the same root cause as #376 which means it requires AutoIt's GUI to be re-written in order to fix.
- 12:00 AM Ticket #2028 (Bit* function examples are too cryptic to be meaningful) updated by
-
Version changed
Automatic ticket cleanup.
Oct 8, 2011:
- 9:33 PM Ticket #1451 (RegRead) updated by
- What about also making the second parameter optional? […]
- 9:24 PM Ticket #2028 (Bit* function examples are too cryptic to be meaningful) updated by
- Useable examples: […]
- 9:18 PM Ticket #2028 (Bit* function examples are too cryptic to be meaningful) created by
- The examples for BitOR, BitAnd, Bit* are very hard to comprehend for …
Oct 6, 2011:
- 9:00 PM Ticket #1658 (COM / OLE object access causes error code 80020003 - member not found) updated by
-
Milestone changed
Automatic ticket cleanup. - 8:30 PM Ticket #1658 (COM / OLE object access causes error code 80020003 - member not found) updated by
- The other, duplicate ticket is here: http://www.autoitscript.com/trac/autoit/ticket/1963
- 8:30 PM Ticket #1963 (Ticket 1658 Still Not Working in 3.3.7.10) updated by
- Moved info over to original Ticket.
- 8:29 PM Ticket #1658 (COM / OLE object access causes error code 80020003 - member not found) updated by
- Yep, I didn't read the ticket guidelines and posted another ticket on it when I shouldn't have. Sorry about that. Here's the text from the other ticket, which includes a re-create for a scenario I know isn't working in 3.3.7.18. The code below properly opens the report in 3.3.6.0, but causes a COM "member not found error" on the line $CR_ObjViewer.ReportSource = $CR_ObjReport (commented in the code). #Region ; Directives created by AutoIt3Wrapper_GUI #AutoIt3Wrapper_UseX64=n #EndRegion ; Directives created by AutoIt3Wrapper_GUI $oMyError = ObjEvent("AutoIt.Error","MyErrFunc") ; Initialize a COM error handler Func MyErrFunc() Msgbox(0,"AutoItCOM Test","We intercepted a COM Error !" & @CRLF & @CRLF & _ "err.description is: " & @TAB & $oMyError.description & @CRLF & _ "err.windescription:" & @TAB & $oMyError.windescription & @CRLF & _ "err.number is: " & @TAB & hex($oMyError.number,8) & @CRLF & _ "err.lastdllerror is: " & @TAB & $oMyError.lastdllerror & @CRLF & _ "err.scriptline is: " & @TAB & $oMyError.scriptline & @CRLF & _ "err.source is: " & @TAB & $oMyError.source & @CRLF & _ "err.helpfile is: " & @TAB & $oMyError.helpfile & @CRLF & _ "err.helpcontext is: " & @TAB & $oMyError.helpcontext _ ) Local $err = $oMyError.number If $err = 0 Then $err = -1 $g_eventerror = $err ; to check for after this function returns Endfunc $gui = guicreate("TEST", 500, 500) $sReportName = FileOpenDialog("Select RPT Source File", ".", "RPT (*.rpt)", 3) if $sReportName <> "" and fileexists($sReportName) then $CR_ObjApp = ObjCreate("CrystalRuntime.Application.11") If $CR_ObjApp = 0 Then msgbox(0, "Error", "Crystal Reports is not installed.", default, $gui) else $CR_ObjReport = $CR_ObjApp.OpenReport($sReportName) If $CR_ObjReport = 0 Then msgbox(0, "Error", "Unable to open report.", default, $gui) else $CR_ObjViewer = ObjCreate("CrystalReports11.ActiveXReportViewer.1") $CR_ObjViewer.DisplayGroupTree = true ;Creates an ActiveX control in the GUI. $ActiveX = GUICtrlCreateObj ( $CR_ObjViewer, 10, 10, 480, 480) $CR_ObjViewer.ReportSource = $CR_ObjReport ;this line causes a COM error "member not found" in beta 3.3.7.10, but not in earlier non-beta versions $CR_ObjViewer.ViewReport endif endif endif Of course CR must be installed, here is a thread discussion on it: http://www.autoitscript.com/forum/topic/12813-crystal-reports-viewer-in-autoit/
- 6:59 PM Ticket #1658 (COM / OLE object access causes error code 80020003 - member not found) reopened by
- Apparently this may not be fixed so I'm reopening it until I can test one way or the other.
- 4:08 PM Ticket #2027 (;-)) created by
- ;This programm working correctly... #include <ButtonConstants.au3> …
- 2:07 PM Ticket #1963 (Ticket 1658 Still Not Working in 3.3.7.10) updated by
- This was closed out as a duplicate (since I referred to the other thread which I thought was the same), but it must be different because the example I posted above still does not work in 3.3.7.18.
- 12:51 AM Ticket #1952 (Autoit & https & _IEFormSubmit doesnt work.) closed by
- Fixed: Oh, so there was a ticket for the form submit issue. It's fixed in 3.3.7.18 and later.
Oct 5, 2011:
- 9:04 PM Ticket #1952 (Autoit & https & _IEFormSubmit doesnt work.) updated by
- It affects the KeePass autofiller extension called Keeform - http://www.keeform.org/. So I wish it would get fixed also. -rrams
Oct 4, 2011:
- 12:00 AM Ticket #2026 (Improved, clearer, help for TrayCreateItem) updated by
-
Version changed
Automatic ticket cleanup.
Oct 3, 2011:
- 9:29 PM Ticket #2023 (Windows 98/ME (ANSI) compile support needed again) updated by
- Replying to jmichae3@…: > I admit I was upset by what you had said, and I shouldn't have said what I said, and I am sorry. Don't know whether you noticed but I don't think you were upset with me. Let's stop this dialog here and have that in our forum where this belongs. Regards, Jos
- 9:23 PM Ticket #2026 (Improved, clearer, help for TrayCreateItem) created by
- I propose the following: ; #FUNCTION# …
- 1:22 AM Ticket #2023 (Windows 98/ME (ANSI) compile support needed again) updated by
- does the older version work on vista/windows 7/windows 8 in the program files directory, which is a protected directory? this is also a need. cross-platform in an ANSI version. I may need to go back to an ANSI version if this will work (I have no 7 boxed to test with). you can have an XML manifest windows resource in an executable to make it vista/7/8 compatible with certain conditions: it must not have an assembly version, type, processorArchitecture, name. no description. trustinfo looks different. it looks basically like this (someprogram.exe.manifest): <assembly xmlns="urn:schemas-microsoft-com:asm.v1" manifestVersion="1.0"> <ms_asmv2:trustInfo xmlns:ms_asmv2="urn:schemas-microsoft-com:asm.v2"> <ms_asmv2:security> <ms_asmv2:requestedPrivileges> <ms_asmv2:requestedExecutionLevel level="asInvoker"> </ms_asmv2:requestedExecutionLevel> </ms_asmv2:requestedPrivileges> </ms_asmv2:security> </ms_asmv2:trustInfo> </assembly> this you link into the executable as a windows resource (or you use the microsoft mt.exe manifest tool). the .rc file looks like this: #include "winuser.h" 1 RT_MANIFEST "someprogram.exe.manifest" this works with windows 98, xp, vista, 7, and probably 8 and allows the program to run in c:\program files\ without getting shoved into the Virtual Store.
- 12:37 AM Ticket #2023 (Windows 98/ME (ANSI) compile support needed again) updated by
- can't seem to get that unicows to do what I want it to. has no instructions, it just asks you where to dump 2 files (.dll and .pdb). not user friendly to average joe user or to developer. kb article has no instructions either. I guess you are supposed to program against it by dynamically loading the DLL. the license is miles long but it is a redistributable, as long as you distribute it properly with your app.
Oct 2, 2011:
- 7:56 PM Ticket #2025 (TimerInit() return data type change.) closed by
- Rejected: If you use the return value from TimerInit() for anything other than an opaque handle to be passed to TimerDiff() then you are asking for trouble. Therefore the type is irrelevant. Ticket closed.
- 7:35 PM Ticket #2023 (Windows 98/ME (ANSI) compile support needed again) updated by
- I admit I was upset by what you had said, and I shouldn't have said what I said, and I am sorry. I heard that the digital mars C++ compiler has some sort of microsoft MSLU unicode layer for unicode on top of windows 9x systems. http://msdn.microsoft.com/en-us/goglobal/bb688166 the the unicows.exe MSLU itself which is about 300KB http://www.microsoft.com/download/en/confirmation.aspx?id=4237 this provides a UNICODE layer on top of windows 9x/me. so this may mean you can keep the unicode stuff while still running. all you would need to do is tell the users they need to execute this program in their installers if it's a windows 9x/me machine. this requires OS detection. I have code for doing this in NSIS, but not innosetup. I am going to do some testing to see if this works. I hope it does, if my ISP will work today. as I said before, the older version of autoit is a different language (at least different libs), and I have already converted my code to the new version. I don't really want to go backwards because I like/need the new features in some cases.
- 9:37 AM Ticket #2023 (Windows 98/ME (ANSI) compile support needed again) updated by
- Replying to jmichae3@…: > If they are still using windows 9x, fine with me, I will try my best to make my apps work on windows 9x. What is the issue with using the latest version of Autoit3 that still supports ANSI? It is like Win9X not developed anymore but can still be used fine. Jos
- 8:39 AM Ticket #2025 (TimerInit() return data type change.) created by
- Request for TimerInit() to return the returned value as Int instead of …
- 4:23 AM Ticket #2023 (Windows 98/ME (ANSI) compile support needed again) updated by
- I don't know about you, but I like serving my users with applications they can use. they are my customers. If they are still using windows 9x, fine with me, I will try my best to make my apps work on windows 9x. no need to cop an attitude here. I guess I need to start investigating GUI toolkits to replace autoit. thank you for your time.
Oct 1, 2011:
- 3:28 AM Ticket #2023 (Windows 98/ME (ANSI) compile support needed again) closed by
- Rejected: No. AutoIt is now a UNICODE application. Most of the ANSI conditional stuff is gone. There are also features that would have to be conditionally removed so the binary would even run on Windows 9x. This makes the code a huge mess just to cater to a small subset of potential users. It's not worth the time or effort to maintain. Tell your users to use an operating system that isn't older than their children or stop using a computer entirely.
- 3:23 AM Ticket #2020 (request: StringLTrim($str) and StringRTrim($str)) closed by
- Rejected: StringStripWS() already has options for stripping leading (left) and trailing (right) whitespace.
Sep 29, 2011:
- 7:36 PM Ticket #14 (Callback functions with parameter support.) updated by
- This would be awesome.
Sep 28, 2011:
- 5:08 PM Ticket #2022 (Cross set contants) updated by
- Looking at the values for the 2 constants, they are set correctly, they're just working backwards.
- 9:00 AM Ticket #2023 (Windows 98/ME (ANSI) compile support needed again) updated by
-
Version changed
Automatic ticket cleanup. - 7:23 AM Ticket #2023 (Windows 98/ME (ANSI) compile support needed again) updated by
-
Type changed
- 7:14 AM Ticket #2021 (FF.au3) closed by
- No Bug
Sep 27, 2011:
- 11:54 PM Ticket #2020 (request: StringLTrim($str) and StringRTrim($str)) updated by
- Replying to anonymous: > Can be accomplished with StringRegExpReplace and probably with other functions. or with StringStripWS
- 11:39 PM Ticket #2020 (request: StringLTrim($str) and StringRTrim($str)) updated by
- Can be accomplished with StringRegExpReplace and probably with other functions.
- 11:33 PM Ticket #2024 (Add AutoIt.Error object property for script or file name.) created by
- Reproducer (if necessary): include.au3: […] Main.au3: […]
- 10:01 PM Ticket #2023 (Windows 98/ME (ANSI) compile support needed again) created by
- I took a poll of my users: about slightly less than 1/2 of the users …
- 9:35 PM Ticket #2020 (request: StringLTrim($str) and StringRTrim($str)) updated by
- by the way, forum is closed to posts and registration.
- 9:34 PM Ticket #2020 (request: StringLTrim($str) and StringRTrim($str)) updated by
- working code example of the necessary functions. If you want this coded in C++ I am sure I could do it in less than an hour. func ltrim($s) if ""==$s then return $s endif local $s2,$index,$pos=-1,$ch for $index = 1 to stringlen($s) if (asc(stringmid($s,$index,1)) > 32) then $pos=$index exitloop endif next if (-1<>$pos) then return StringMid($s,$pos) endif return $s endfunc func rtrim($s) if ""==$s then return $s endif local $s2,$index,$pos=-1,$ch for $index = stringlen($s) to 1 step -1 if (asc(stringmid($s,$index,1)) > 32) then $pos=$index exitloop endif next if (-1<>$pos) then return StringMid($s,1,$pos) endif return $s endfunc func trim($s) return ltrim(rtrim($s)) endfunc ;msgbox(0,"test","ltrim"""<rim(" blah ")&"""") ;msgbox(0,"test","rtrim"""&rtrim(" blah ")&"""") ;msgbox(0,"test","trim"""&trim(" blah ")&"""")
- 10:18 AM Ticket #2022 (Cross set contants) created by
- The $DT_PATH_ELLIPSIS and $DT_END_ELLIPSIS constants are …
- 12:00 AM Ticket #2021 (FF.au3) updated by
-
Version changed
Automatic ticket cleanup.
Sep 26, 2011:
- 11:35 PM Ticket #2021 (FF.au3) updated by
- 1. FF.au3 is not part of the AutoIt install. 2. Support goes to the support forum, not the bug tracker. You asked for help from the wrong people in the wrong place.
- 9:41 PM Ticket #2021 (FF.au3) created by
- FF.au3 …
- 6:05 PM Milestone 3.3.7.18 completed
- 5:41 PM Ticket #1985 (_IEAction($element, "focus") does not work in IE9) closed by
- Fixed: Fixed by revision [6250] in version: 3.3.7.18
- 5:28 PM Ticket #1985 (_IEAction($element, "focus") does not work in IE9) updated by
- This is not an AutoIt bug, this is a change in behavior for IE9. If an about URI (for example: about:blank) is displayed then IE9 tries to be "helpful" and gives focus to the URL bar. The fix for this is simple: […] This will give focus to the document and take it away from the browser frame. You can then follow that up with a call to _IEAction(..., "focus") to set focus to your desired element. I will update the documentation example(s) to do this automatically. When this ticket is marked as "fixed" it will be the documentation that is fixed since this is not an AutoIt bug.
- 12:00 PM Ticket #2020 (request: StringLTrim($str) and StringRTrim($str)) updated by
-
Version changed
Automatic ticket cleanup. - 11:26 AM Ticket #2020 (request: StringLTrim($str) and StringRTrim($str)) created by
- these functions would either strip the left or right whitespace off of …
Sep 23, 2011:
- 6:51 PM Ticket #2019 (File functions: Three help file issues and one bug) updated by
- Your wall of text is difficult to get through. You seem to be making some assumptions about behavior on various points so I think in some cases you are confusing "bug" with "doesn't know what is happening". You also show a lack of critical thinking. Particularly, where else would FileRead() read from other than the current position? The end? There's nothing there. The beginning? Presumably you already did that if the current position isn't at the beginning. Maybe you used FileSetPos() to change the current position in which case if you want to read from somewhere else you already know how to get there. It makes me dubious of the entirety of your entire report. The biggest issue, however, is this: You did not provide a script to reproduce any of the problems in your so called "bug".
- 4:08 AM Ticket #2019 (File functions: Three help file issues and one bug) created by
- Not really a bug, but I couldn't think of where else to put these. …
Sep 22, 2011:
- 4:36 PM Ticket #1704 (Need UDFs in AutoItx.) closed by
- Rejected: Stupid ticket. The host language will certainly support this. Closing as rejected.
- 4:33 PM Ticket #1948 (_GUICtrlButton_SetImage function description on SciTE tooltip) closed by
- Fixed: Fixed by revision [6245] in version: 3.3.7.18
- 4:30 PM Tickets #1813,1890 batch updated by
- Completed: Added by revision [6244] in version: 3.3.7.18
- 4:25 PM Ticket #1947 (Add "Forward" button in the AutoIt HTML help (.chm file)) closed by
- Completed: Added by revision [6243] in version: 3.3.7.18
- 4:15 PM Ticket #1695 (Add some better discription to help file how to usw the modes from FileOpen) closed by
- Rejected: I don't see the current documentation as confusing. It takes 2 seconds of critical thinking to realize if you want to write you have to specify the write flags. Closing as rejected.
Sep 21, 2011:
- 9:16 PM Ticket #1994 (Confusing helpfile info...) closed by
- Fixed: Fixed by revision [6242] in version: 3.3.7.18
- 8:57 PM Ticket #2001 (_GUICtrlToolbar_SetButtonText: Example only works partially) closed by
- Fixed: Fixed by revision [6239] in version: 3.3.7.18
- 8:47 PM Ticket #1933 (_GetIP is outdated and could possibly fail.) closed by
- Fixed: Fixed by revision [6238] in version: 3.3.7.18
- 8:21 PM Ticket #1924 (Hiding one Edit affects the text in another.) closed by
- No Bug: This is not a bug. I do not like this behavior in AutoIt, but it is not a bug. When you disable $Edit1 Windows (Not AutoIt) shifts focus to $Edit2. When it does this it is secretly selecting the entire contents of $Edit2. You can verify this by using _GUICtrlEdit_GetSel() before and after the GUICtrlSetState() line. Now comes the part about AutoIt that I don't like. AutoIt is designed so that it inserts at the current caret location. If there is no text selected this is just a normal insertion. If there is text selected then it becomes a replace. So, since Windows selected the entire text of $Edit2 all of it is replaced. My suggestion is use _GUICtrlEdit_AppendText() to append to the end of an edit control. It takes the extra step necessary to ensure it always appends and never replaces. You could also use _GUICtrlEdit_SetSel() to adjust the selection yourself before calling GUICtrlSetData(). Closing as no bug.
- 7:20 PM Ticket #1975 (IE object does not recognized as valid object type) closed by
- Fixed: Fixed by revision [6237] in version: 3.3.7.18
- 6:37 PM Ticket #2015 (DllCallbackRegister() mangles floating point numbers under x64) updated by
- I'm not really interested in your independent verifications when mine prove otherwise. I'm also rather annoyed that you think I did something super-complex for DllCallAddress() and that it JUST HAS to be that function. If you spent 3 seconds of thinking about it you would realize all I did was swap out the LoadLibrary() -> GetProcAddress() sequence for explicitly calling the passed address. Since you seem to not accept that maybe I know how to test a bug, here's the AutoIt code: […] And the DLL code: […] Module definition file for the DLL: […] x86 output with beta 3.3.7.17: […] x64 output with beta 3.3.7.17: […] Happy now Ascend4nt? Was that thorough enough for you?
- 1:17 PM Ticket #2015 (DllCallbackRegister() mangles floating point numbers under x64) updated by
- Valik, either you didn't test this thoroughly or DLLCall() and DLLCallAddress() use different code for 'float' types? I've verified independently that AutoIt's 'callback' code works perfectly fine when called via alternate means (in my case, 'DispCallFunc'). The float retains its original value in x64 mode. The focus should really be on DLLCallAddress and how floats are passed along.
Sep 20, 2011:
- 10:31 PM Milestone 3.3.7.17 completed
- 9:53 PM Ticket #2002 (Try to find the cause of slow file operations.) updated by
- Note to self: Start checking revisions beginning with 5490.
- 9:42 PM Milestone 3.3.7.16 completed
- 9:01 PM Ticket #1972 (Strange behavior with ControlClick and deactivated button on AutoIt GUI) closed by
- No Bug: This is not a bug specific to AutoIt. I was able to reproduce the same issue by using ControlClick() on a disabled Configure button in the Sound control panel applet. A configuration window popped up even though the Configure button was disabled. Closing as no bug.
- 8:55 PM Ticket #1983 (_IECreateEmbedded doesn't work anymore) closed by
- No Bug
- 8:48 PM Ticket #2018 (It is not able to identify all Button from other Software) updated by
- To add more observations: * The problem actually varies depending on the Spy++ mode. * Spy++ mode on: Nothing seems to update, it always shows "Button14" for me and the same control ID no matter what. * Spy++ mode off: I still see "Button14" for everything but the control ID updates as I mouse over controls (I didn't verify if the ID is correct, only that it changed). * The Putty configuration window makes use of group-boxes which I believe may be what is throwing everything off. * Turning on control highlighting helps show what is actually being inspected. It seems impossible or at least incredibly difficult to highlight any control that is contained in a group box. It always wants to highlight the box instead. There is definitely a bug here.
- 8:25 PM Ticket #1009 (Remove hard-coded calls to ConsoleWrite() in SQLite.au3) closed by
- Fixed: Fixed by revision [6226] in version: 3.3.7.16
- 8:05 PM Ticket #2018 (It is not able to identify all Button from other Software) created by
- For example, Au3Info is not able to identify the "Load"-button from …
Sep 18, 2011:
- 7:47 PM Ticket #2017 (Proposed clarifications of Tray help) updated by
- I can also see that the help for TrayCreateMenu would benefit from some revisions which would improve clarity. I offer to suggest changes.
- 7:44 PM Ticket #2017 (Proposed clarifications of Tray help) created by
- Having been confused by the Help for TrayMenuMode, I have been working …
Sep 17, 2011:
- 8:45 PM Ticket #2015 (DllCallbackRegister() mangles floating point numbers under x64) updated by
-
Keywords, Description, Summary changed
This is NOT a problem with DllCall() or DllCallAddress(). This is a bug with DllCallbackRegister(). I'm changing the description accordingly. The example script I am going to add is representative of a way to reproduce the problem. I have confirmed with my own DLL that DllCall() does not corrupt the data. - 7:39 PM Ticket #2016 (AU3Check will fail with DllCallAddress) closed by
- Fixed: This has already been discussed here where I stated it would be fixed in the next beta.
- 12:31 PM Ticket #2016 (AU3Check will fail with DllCallAddress) created by
- the parm number of DllCallAddress too small. dllcall is 255,but …
- 6:39 AM Ticket #2012 (sqlite3 UPDATE changing value deletes it with UNIQUE index!) updated by
- sorry, the forum links to here.
- 6:34 AM Ticket #2012 (sqlite3 UPDATE changing value deletes it with UNIQUE index!) updated by
- cancel the bug report. further testing revealed that it does NOT exhibit a bug, except for the fact that I can't do multirow INSERTs (that, unfortunately is not in the manual, and should be a standard feature). there is usually a limit as to how many rows you can do at once. BTW, I have fixed my original program and test code and released my to-do-list program as of today. the new test code looks like this: obviously, the author of autoit (autoitscript.com) has made the language automatically insert single quotes for us, because his example code shows no single quotes, and this code works, even with a single quote. I also had a bug in my debug output routine where I wasn't concatenating strings. ;=============================================================================== ; ; Program Name: to-do-list ; Description: to-do list ; Requirement(s): None ; Return Value(s): None ; Author(s): Jim Michaels <jmichae3@…> ; Create Date: 9/16/2011 ; Current Date: 9/16/2011 ; ;the test will be to see if SQLITE3 will delete the record that contains "that's it" by an UPDATE (no, it does not) ; ;=============================================================================== $PROGRAM_NAME="sqlite-bug-test" $PROGRAM_TITLE="SQLIte3 Bug Test" $PROGRAM_VERSION="1.1" #AutoIt3Wrapper_au3check_parameters=-d -w 1 -w 2 -w 3 -w 4 -w 5 -w 6 #include <WindowsConstants.au3> #include <GUIConstantsEx.au3> #include <Constants.au3> #include <SQLite.au3> #include <SQLite.dll.au3> #include <Array.au3> Global $dbfilename, $hDB, $hQuery, $hquery, $aRow $dbdir=@AppDataCommonDir&"\JimMichaels\"&$PROGRAM_NAME DirCreate($dbdir) $dbpath=$dbdir&"\"&$PROGRAM_NAME&".sqlitedb" _SQLite_Startup () If @error > 0 Then MsgBox(16, "SQLite Error", "SQLite.dll Can't be Loaded!. report to author jmichae3@…") Exit - 1 EndIf $hDB=_SQLite_Open($dbpath); Open a :memory: database If @error > 0 Then MsgBox(16, "SQLite Error", "Can't Load Database!. report to author jmichae3@…") _SQLite_Shutdown() Exit - 1 EndIf If $SQLITE_OK <> _SQLite_Exec($hDB,"CREATE TABLE IF NOT EXISTS test (" _ & "entry_id INTEGER CONSTRAINT entry_id_c PRIMARY KEY AUTOINCREMENT, " _ & "shortdesc TEXT NOT NULL DEFAULT " _ & ");") Then MsgBox(0,"SQLite Error","Error Code1: " & _SQLite_ErrCode() & @CRLF & "Error Message: " & _SQLite_ErrMsg()&". report to author jmichae3@…") _SQLite_Close($hDB) _SQLite_Shutdown() exit -1 endif ;_SQLite_Exec($hDB,"CREATE UNIQUE INDEX IF NOT EXISTS shortdesc_idx ON todolist(shortdesc);") _SQLite_Exec($hDB,"INSERT INTO test(entry_id,shortdesc) VALUES (1,"&_SQLite_Escape("that's it")&");") _SQLite_Exec($hDB,"INSERT INTO test(entry_id,shortdesc) VALUES (2,'b');") _SQLite_Exec($hDB,"INSERT INTO test(entry_id,shortdesc) VALUES (3,'c');") _SQLite_Exec($hDB,"INSERT INTO test(entry_id,shortdesc) VALUES (4,'d');") If $SQLITE_OK <> _SQLite_Exec($hDB,"UPDATE test SET shortdesc="&_SQLite_Escape("")&" WHERE shortdesc="&_SQLite_Escape("that's it")&";") Then MsgBox(0,"SQLite Error","Error Code1: " & _SQLite_ErrCode() & @CRLF & "Error Message: " & _SQLite_ErrMsg()&". report to author jmichae3@…") _SQLite_Close($hDB) _SQLite_Shutdown() exit -1 endif ;output shortdesc column to messagebox dumpfieldname("test","shortdesc") ;output db column plainly to messagebox func dumpfieldname($tablename,$fieldname) local $s="" $err=_SQLite_Query ( $hDB, "SELECT "&$fieldname&" FROM "&$tablename&";", $hQuery ) select case $err==$SQLITE_OK case $err==-1 msgbox(0,"OOPS", "SELECT prob0: Error Code: " & _SQLite_ErrCode() & @CRLF & "Error Message: " & _SQLite_ErrMsg()&". report to author jmichae3@…") case $err=1 msgbox(0,"OOPS", "SELECT problem0:Error calling SQLite API 'sqlite3_prepare'. report to author jmichae3@…") case $err=2 msgbox(0,"OOPS", "SELECT problem0: call prevented by safe mode. report to author jmichae3@…") endselect While $SQLITE_OK==_SQLite_FetchData ($hQuery, $aRow) $s&=""""&$aRow[0]&""""&@crlf WEnd _SQLite_QueryFinalize ($hQuery) msgbox(0,"dumpfield:"&$fieldname,$s) endfunc
- 3:14 AM Ticket #2014 (Updated Array.au3 UDF to be used with 2D arrays) updated by
- I see what you mean. (ergo: never mind my comment.) modified-version-of-the-standard-arrayau3-include-file
- 12:16 AM Ticket #2014 (Updated Array.au3 UDF to be used with 2D arrays) updated by
- The UDF has been posted in the Examples forum for a few weeks already. Haven't seen much activity on the posting. I'm not sure how I would go about it differently, but I'm willing to do what I can.
Sep 16, 2011:
- 6:32 PM Ticket #2015 (DllCallbackRegister() mangles floating point numbers under x64) updated by
- I suppose, there are some erros in the fastcall-implementation for the XMM-Registers either in DllCallAddress or DllCallback.
- 6:00 PM Ticket #2015 (DllCallbackRegister() mangles floating point numbers under x64) created by
- Parameters of type "float" are mangled when passed to …
- 9:27 AM Ticket #1997 (GUICtrlCreateDummy(), @error=1 on failure., trivial.) updated by
- > I'm not sure what this ticket is about. The fact that 'undocumented behaviors' and bugs are very easily mixed up by those that only have the officially documentation to go by. Guess "It's an undocumented behavior" in here will have to do as alternative documentation.
- 8:58 AM Ticket #2014 (Updated Array.au3 UDF to be used with 2D arrays) updated by
- Why not first let others play around it on the forum? - For flushing out potential bugs and such.(faster and easier update rate.) - And, maybe, ... mmm .. aha, picking valik's brain on the probability of having it included as official UDF.
- 3:00 AM Ticket #2014 (Updated Array.au3 UDF to be used with 2D arrays) updated by
-
Version changed
Automatic ticket cleanup. - 1:58 AM Ticket #2014 (Updated Array.au3 UDF to be used with 2D arrays) created by
- I have modified several of the _Array functions, that previously only …
Sep 15, 2011:
- 11:12 PM Ticket #1492 (Problem with listview AND $WS_EX_COMPOSITED in a gui) closed by
- No Bug: This is not a bug. The documentation for WS_EX_COMPOSITED says it is not compatible with the CS_OWNDC or CS_CLASSDC class styles. Closing as no bug.
- 10:58 PM Ticket #1997 (GUICtrlCreateDummy(), @error=1 on failure., trivial.) closed by
- No Bug: It's an undocumented behavior. I'm not sure what this ticket is about. Closing as no bug.
- 10:56 PM Ticket #1993 (Forum [autoit] code abbreviates URLs - it shouldn't) updated by
- This is still an issue with IPB 3.2.2. A sample post can be found here. I don't see a problem if the URL is collapsed in the code display but clicking "Popup" should show the full URL.
- 8:13 PM Ticket #2011 (Sorting the list by clicking the column name) updated by
- Look at: GUICtrlRegisterListViewSort _GUICtrlListView_SimpleSort _GUICtrlListView_SortItems _GUICtrlListView_RegisterSortCallBack
- 5:01 PM Ticket #1934 (Au3check false error) closed by
- Fixed: Fixed by revision [6213] in version: 3.3.7.16
- 3:53 PM Ticket #1790 (au3.api, AutoItSetOption, Optional indicator.) closed by
- Fixed: Fixed by revision [6212] in version: 3.3.7.16
- 3:49 PM Ticket #1999 (DirCopy and DirMove have some bugs) closed by
- No Bug: So you reported a bug about documented behavior. Good job!
- 3:47 PM Ticket #1998 (fileflush bluescreen windows 7 x86) closed by
- No Bug: There's no way in hell this can be tested. Closing.
- 3:44 PM Ticket #2009 (_GUICtrlToolbar_Create: $BTNS constants don't apply to this function) closed by
- Fixed: Fixed by revision [6211] in version: 3.3.7.16
- 3:39 PM Ticket #2010 (Menu Tooltip Bug) closed by
- Duplicate: Learn to test with the beta first. It's fixed there.
- 3:14 PM Ticket #2012 (sqlite3 UPDATE changing value deletes it with UNIQUE index!) closed by
- No Bug: Closing this ticket. Seems to be a long way from actually have a bug to report. I'm not interested in bugs filed against 3.3.6.1 anyway since we are deep into beta territory.
- 3:12 PM Ticket #2008 (timerinit does not return int, returns imprecise float, differences bad) closed by
- No Bug: I'm not sure where you got your assumptions but they are flat out wrong. You cannot do what you are doing and expect to get meaningful values back. There is more to TimerDiff() than an internal call to TimerInit() to get a new timestamp and a simple subtraction. I suggest you use functions as documented or learn what the fuck you're talking about before wasting my time again.
- 3:01 PM Ticket #1660 (Mod function causes AutoIt to crash) closed by
- Fixed: Fixed by revision [6210] in version: 3.3.7.16
- 2:52 PM Ticket #2013 (Mod(anything, 0) hard crash) closed by
- Duplicate: Closing as duplicate of #1660.
- 2:06 PM Ticket #2012 (sqlite3 UPDATE changing value deletes it with UNIQUE index!) updated by
- You shouldn't be posting supposed "bugs" there without checking with others users in the help forum first. Then your post doesn't follow ticket posting guidelines and your code has numerous errors.
- 1:13 PM Ticket #2013 (Mod(anything, 0) hard crash) created by
- Confirmed release 3.3.6.1 & beta 3.3.7.15. Reproducer: Mod(1, 0) …
- 8:16 AM Ticket #2012 (sqlite3 UPDATE changing value deletes it with UNIQUE index!) updated by
- btw, there is still a bug in sqlite3.
- 8:14 AM Ticket #2012 (sqlite3 UPDATE changing value deletes it with UNIQUE index!) updated by
- I found a bug in my program where it is taking the new value from a blank textbox. but this should not make any difference. the codeexample I have here is incorrect for the problem. the new value should be set to an empty string for it to delete the record. this is improper behavior.
- 12:51 AM Ticket #2012 (sqlite3 UPDATE changing value deletes it with UNIQUE index!) updated by
- new information: the code I posted did not create indexes for the database. I just fixed that in my program, but not here. regardless, even though a block of code did not create indexes, the update still deleted my records consistently.
Sep 14, 2011:
- 11:13 PM Ticket #2012 (sqlite3 UPDATE changing value deletes it with UNIQUE index!) created by
- I don't ever remember seeing this happen before with a database. what …
- 12:00 AM Ticket #2011 (Sorting the list by clicking the column name) updated by
-
Version changed
Automatic ticket cleanup.
Sep 13, 2011:
- 10:03 PM Ticket #2011 (Sorting the list by clicking the column name) created by
- GUICtrlCreateListView help section says: Sorting the list by clicking …
- 2:49 AM Ticket #2008 (timerinit does not return int, returns imprecise float, differences bad) updated by
- Are you listening to what your saying? How could a int returned be more accurate than a float? Your example uses timerinit() wrong so its kinda irrelevant. $a=TimerInit(); sleep(100) $b=TimerDiff($a) $b = 99.3337961739871 on mine.
Sep 12, 2011:
- 7:34 PM Ticket #15 (Rewrite INI functionality to remove limitations.) updated by
- setupapi and the official solution of the problem http://www.autoitscript.com/forum/topic/132507-request-udf-for-inf-file-processing-functions/page__fromsearch__1
- 3:27 PM Ticket #1975 (IE object does not recognized as valid object type) updated by
- More wraithdu suggest a more clean way http://www.autoitscript.com/forum/topic/132875-track-1975-solved-with-33715/page__view__findpost__p__925914
- 3:00 PM Ticket #1975 (IE object does not recognized as valid object type) updated by
-
Milestone changed
Automatic ticket cleanup. - 2:33 PM Ticket #1975 (IE object does not recognized as valid object type) reopened by
- Replying to Jon: > Fixed by revision [6192] in version: 3.3.7.15 This fix is not complete for _IELoad Line 535 must be modified too as suggested by Smoke_N
- 11:19 AM Ticket #2004 (_GUICtrlEdit_Find() Documentation) updated by
- This has already been mentioned by me, and is found all over the UDFs: http://www.autoitscript.com/forum/topic/121148-report-help-file-issues-here/page__view__findpost__p__857343
Sep 11, 2011:
- 9:21 PM Ticket #2008 (timerinit does not return int, returns imprecise float, differences bad) updated by
- Bummer ... […] Or (also) see _Timer_Init() ? (_Timer_Init() no match(speed) compared to TimerInit().)
- 8:58 PM Ticket #2008 (timerinit does not return int, returns imprecise float, differences bad) updated by
- Your barking up the wrong tree. See creators of your OS. And study the timer related pages at MSDN while your at it.
- 6:38 PM Milestone 3.3.7.15 completed
- 3:12 PM Ticket #2010 (Menu Tooltip Bug) created by
- Tooltips of menu items do not appear. i am using windos xp service …
- 3:00 AM Ticket #2009 (_GUICtrlToolbar_Create: $BTNS constants don't apply to this function) updated by
-
Version changed
Automatic ticket cleanup. - 12:04 AM Ticket #2009 (_GUICtrlToolbar_Create: $BTNS constants don't apply to this function) created by
- The $BTNS constants belong to _GUICtrlToolbar_AddButton, not …
Sep 10, 2011:
- 7:57 AM Ticket #2008 (timerinit does not return int, returns imprecise float, differences bad) created by
- $a=int(TimerInit()) ;for some reason, timerinit returns a float rather …
Note:
See TracTimeline
for information about the timeline view.
