AutoHotkey Community

[Sean]

It queries the database through ADO.

NEED: COM Standard Library.

[PhiLho]

Beside the base functionality (which is useful), it seems you offer a good range of helper functions for Com support.
I guess it needs the latest version of AutoHotkey (v.1.0.46.08 at least), you should have mentioned it to avoid messages like "It doesn't work"...
Do you know a good online tutorial for Com? I always wanted to learn it, but never went very far, this could be a good new opportunity.
_________________
vPhiLho := RegExReplace("Philippe Lhoste", "^(\w{3})\w*\s+\b(\w{3})\w*$", "$1$2")

[Sean]

[majkinetor]

I know superb COM tutorial. I have read 4,5 of them already using different languages, but this one makes it crystal clear. It describes COM architecture in detail rather then explaining how to use it. It does so by creating simple COM object starting from blank C struct that at the end becomes valid COM class.

There are 6 articles (some form of mini book). Its made by the man who created cwebpage.dll. My recomendation is to go to tutorial 6 (last one) and download the source code for it. In that archive, the author made html with all 6 articles, and all 6 source archives in the form of book with the TOC.

This is the link to the first article:
http://www.codeproject.com/com/com_in_c1.asp

This is the link to the package containing all 6:
http://www.codeproject.com/com/com_in_c6/com_in_c6_src.zip

Its really extraoridnary set of articles. Don't miss it. Read every one of them as they are connected. Then you will see COM in its real lite.

I was learning this to understand Seans code better and to see what should I do to create COM interface in AHK. This article showed me that it is possible to create such thing in AHK to behave the very same as for instance in VBScript. TypeLibraries that are needed to decifer COMs data structures and interfaces are available as COM objects too, and those can be quieried in AHK to create VTable that can be used to invoke COM object inteface methods from the ahk script.

2 Sean
If you want to create COM interface in AHK for AHK then I suggest you to create new topic on AHK Wiki so all interested can colaborate. I have pretty good understanding about the topic now, seems that PhilHo and foom are willing to help too... This is good oportunity for all of us to learn more about COM and do something useful for the community along the way.
_________________

[Sean]

[PhiLho]

[majkinetor]

[washboard]

Can you please give an example of the instruction to read an Excel sheet, please ? Would it be possible to implement the reading of float values ?
Thanks for your answer.

[Sean]

[majkinetor]

all ado things work the same.

Just look on the net to see excell connection string then quiery the sheet
using

Select *
from [Sheet$]
_________________

[washboard]

@ majkinetor
Thanks. I will search for this "excel connection string", but ...
@ Sean
As in Excel there are float values, would it be possible to retrieve them (you said taht for the moment they are not managed) ? In your example you access to an mdb database file. May be there can be float values in it, too ? Thanks for your work.

[Sean]

[majkinetor]

you can get float values as strings.

This option also resides in excell connection string.

This is my C# function

[tfcahm]

Here's a verbatim re-write of the original script at the top of this thread using the most recent CoHelper.ahk. It's simpler now thanks to the Invoke() function. Starting from this example it's been pretty easy to build scripts that manipulate Access databases, though some knowledge of ADO is required.

[Sean]