Thank you @just me for migrating this helpful script to v2.
I found a small error in line 150 in the method CloseDb():
This._Queries := [] should be This._Queries := Map()
and a small typo in line 347: dadabase
Search found 27 matches
- 14 Jul 2022, 03:34
- Forum: Scripts and Functions (v2)
- Topic: Class_SQLiteDB v2.0.6 - 2023-11-28
- Replies: 55
- Views: 66121
- 04 Dec 2021, 04:47
- Forum: Ask for Help (v2)
- Topic: [V2.beta.3] FileAppend does not work like documented
- Replies: 1
- Views: 762
[V2.beta.3] FileAppend does not work like documented
[Moderator's note: Topic moved from Bug Reports.] The Help says about the second Parameter for using stdout for FileAppend: However, text sent to stdout will not appear at the command prompt it was launched from. This can be worked around by 1) compiling the script with the Ahk2Exe ConsoleApp direc...
- 15 May 2021, 11:57
- Forum: Ask for Help (v1)
- Topic: RegExMatch with multiple subpatterns
- Replies: 6
- Views: 358
Re: RegExMatch with multiple subpatterns
Thank you very much for your help mikeyww and teadrinker.
I was just thinking I should loop through the string by splitting it with the space as delimiter and use always one pattern for these substrings.
That gives me some homework to understand what your solutions are actually doing ...
I was just thinking I should loop through the string by splitting it with the space as delimiter and use always one pattern for these substrings.
That gives me some homework to understand what your solutions are actually doing ...
- 15 May 2021, 11:28
- Forum: Ask for Help (v1)
- Topic: RegExMatch with multiple subpatterns
- Replies: 6
- Views: 358
Re: RegExMatch with multiple subpatterns
Hi mikeyww, thanks for the quick response and your solution. I have many of those strings, in which the number of these substrings (like W12345.67) can vary. So instaed of having the same number of subpatterns, is there a way to define one general pattern which matches all the substrings? That was m...
- 15 May 2021, 10:47
- Forum: Ask for Help (v1)
- Topic: RegExMatch with multiple subpatterns
- Replies: 6
- Views: 358
RegExMatch with multiple subpatterns
Hi there, I try to come along with RegExMatch, but I don't get it ... ; here is the string: str := "W12345.12 blablabla bla M00000.00 bla" ; the RegExMatch captures only the first subpattern: FileAppend, % RegExMatch(str, "([WM][0-9]{5}\.[0-9]{2})", Match) ; shows 1 because RegExMatch found somethin...
- 01 Jul 2019, 01:21
- Forum: Bug Reports
- Topic: script started with shortcut key shows additional window
- Replies: 2
- Views: 1701
Re: script started with shortcut key shows additional window
Thank you very much lexikos for taking the time for a detailed analysis and providing solutions, this is very helpful.
- 27 Jun 2019, 07:05
- Forum: Bug Reports
- Topic: script started with shortcut key shows additional window
- Replies: 2
- Views: 1701
script started with shortcut key shows additional window
I created an executable from a small test script, which creates an empty gui: Gui, Show, w100 h100 return Then I created in Windows 10 (and also in Windows 7) a shortcut to this executable on the desktop. In the properties of the shortcut you can define a shortcut key (I used F10). The first time I ...
- 06 Aug 2018, 09:01
- Forum: Bug Reports
- Topic: if statement influences floating point number
- Replies: 13
- Views: 5247
Re: if statement influences floating point number
Thanks again.
I had no idea about the caching thing.
Maybe I should start looking at v2
This explains the difference with objects.Edit2* Read https://autohotkey.com/docs/Concepts.htm#caching.
I had no idea about the caching thing.
Maybe I should start looking at v2
- 06 Aug 2018, 08:39
- Forum: Bug Reports
- Topic: if statement influences floating point number
- Replies: 13
- Views: 5247
Re: if statement influences floating point number
Thanks for the detailed explanation. I try hard to get it in my head, but it is maybe too hot in Germany these days ... So here if ( String ) I used the variable as an expression, that's why it is converted to a floating point number, right? But why is it not converted, if I do this?: String := "152...
- 06 Aug 2018, 07:15
- Forum: Bug Reports
- Topic: if statement influences floating point number
- Replies: 13
- Views: 5247
Re: if statement influences floating point number
Thanks for your reply. But why I get then a different output by just commenting the "if" command? String := "1525.13000" ;if ( String ) FileAppend, % String . "`n", * List := [ String ] FileAppend, % List.1 . "`n", * Output: 1525.13000 1525.13000 As is doesn't matter, if I use String := "1525.13000"...
- 06 Aug 2018, 03:39
- Forum: Bug Reports
- Topic: if statement influences floating point number
- Replies: 13
- Views: 5247
if statement influences floating point number
I have the following code, which delivers an unexpected result (I guess): String := "1525.13000" if ( String ) FileAppend, % String . "`n", * List := [ String ] FileAppend, % List.1 . "`n", * Output: 1525.13000 1525.130000 If I comment out the one line with the "if" command, the output matches my ex...
- 14 Feb 2018, 08:47
- Forum: Bug Reports
- Topic: Loop (files & folders) - question mark as wildcard
- Replies: 1
- Views: 1300
Loop (files & folders) - question mark as wildcard
It seems that if I am using a question mark "?" as a wildcard in the file pattern of a "files & folders" loop, it does not match a dot ".".
Example: C:\Temp\1a.00.txt
this does not work:
Loop, Files, C:\Temp\?????.txt, F
this works:
Loop, Files, C:\Temp\??.??.txt, F
Version: 1.1.28.00
Example: C:\Temp\1a.00.txt
this does not work:
Loop, Files, C:\Temp\?????.txt, F
this works:
Loop, Files, C:\Temp\??.??.txt, F
Version: 1.1.28.00
- 06 Mar 2017, 06:11
- Forum: Scripts and Functions (v1)
- Topic: Copy filepath to clipboard in Windows Explorer
- Replies: 18
- Views: 14928
Re: Copy filepath to clipboard in Windows Explorer
This is already available in Windows native. If you select a file or folder in Windows Explorer and press the "Shift"-key while opening the context menu through right-mouse-click, you can enter the menu item "Copy as path". What I don't like is that the resulting string in the clipboard always is su...
- 25 Nov 2016, 05:30
- Forum: Scripts and Functions (v1)
- Topic: Excel COM Function Library
- Replies: 14
- Views: 8302
Re: Excel COM Function Library
Great library, thanks for sharing. I found that the following Excel Constants you define in your library are not according the Microsoft definition: xlLeft := -4159 should be xlLeft := -4131 xlToLeft := -4159 and xlRight := -4161 should be xlRight := -4152 xlToRight := -4161 I found this here: https...
- 28 Jan 2016, 09:24
- Forum: Scripts and Functions (v1)
- Topic: [Class] SQLiteDB - Update on 2022-10-04
- Replies: 303
- Views: 205884
Re: [Class] SQLiteDB
Hello just me, first of all thanks for the class, it's great. I just downloaded the latest SQLite DLL Version 3.10.2 This is not working any more with the check against _MinVersion := 36 , because you extract only the first to numbers of the actual version number (in this case 31) and an error messa...
- 28 Nov 2015, 04:37
- Forum: Suggestions on Documentation Improvements
- Topic: [Archived, Locked] Suggestions on documentation improvements
- Replies: 688
- Views: 290150
Re: Suggestions on documentation improvements
In almost every example, the variable names are just variable names and have no special meaning to the interpreter (but some have meaning to the reader). You can use virtually whatever name you want (except operators like and / or and built-in variable names), even if it's the name of a function or...
- 26 Nov 2015, 13:58
- Forum: Suggestions on Documentation Improvements
- Topic: [Archived, Locked] Suggestions on documentation improvements
- Replies: 688
- Views: 290150
Re: Suggestions on documentation improvements
I don't really understand the "keyword vs not" confusion you seem to be concerned about, but I suppose that the problem would be averted by teaching the basics of the language first. Ok, if you reduce it to this, my pull request doesn’t make sense. Meanwhile I understand the examples, but they did ...
- 25 Nov 2015, 09:29
- Forum: Suggestions on Documentation Improvements
- Topic: [Archived, Locked] Suggestions on documentation improvements
- Replies: 688
- Views: 290150
Re: Suggestions on documentation improvements
So by your reasoning, it would make sense to name every variable that stores an object created by [] or {} or new classname "MyObject", regardless of its purpose. You can call every variable that contains a string "MyString" and so on... I guess, I should be more precise about the reasons for my ch...
- 24 Nov 2015, 17:58
- Forum: Suggestions on Documentation Improvements
- Topic: [Archived, Locked] Suggestions on documentation improvements
- Replies: 688
- Views: 290150
Re: Suggestions on documentation improvements
Ok, fair enough, I thought you take the decision. The example with „baseObject“ is introduced with „Base objects are just ordinary objects“. I think „ MyObject“ can be more easily identified with an „ordinary object“ instead of using „baseObject“, which looks more like a Autohotkey key word. Same wi...
- 23 Nov 2015, 18:49
- Forum: Suggestions on Documentation Improvements
- Topic: [Archived, Locked] Suggestions on documentation improvements
- Replies: 688
- Views: 290150
Re: Suggestions on documentation improvements
you changed more than you originally said. i don't agree with naming everything 'MyObject' to replace stuff like 'baseObj' or 'thing' Well, you are right, I did more than I originally suggested, because I thought it makes sense to standardize the examples. I made a suggestion and you made a hint, I...