Search found 9 matches

by kwibus
24 Feb 2016, 06:56
Forum: Scripts and Functions (v1)
Topic: [Func] ADOSQL - wraps ADO for executing SQL queries (AHK-L)
Replies: 43
Views: 94700

Re: [Func] ADOSQL - wraps ADO for executing SQL queries (AHK-L)

Hi VxE,

Trying out the code in the first post on this subject, I get an empty MsgBox.

What could be wrong?

Cheers, Ad
by kwibus
23 Feb 2016, 20:59
Forum: Ask for Help (v1)
Topic: Database
Replies: 12
Views: 6829

Re: Database

Hello, I found it; this small "challenge" is answered! :D strFilePath := "email.csv" ; gebruik := ! anders gaat het fout! HEEL BELANGRIJK ! col_Obj := fn_ReadCols(strFilePath) for key, val in col_Obj.Cols MsgBox % "column " key " is " val fn_ReadCols(strFile) { ; function to read in the first line o...
by kwibus
23 Feb 2016, 17:59
Forum: Ask for Help (v1)
Topic: Database
Replies: 12
Views: 6829

Re: Database

strFilePath := "email.csv" ; gebruik := ! anders gaat het fout! HEEL BELANGRIJK ! fn_1(strFilePath) fn_1(strFile) { ; function to read in the first line of a CSV, the "header fields". ; all field names should go into the object "Keys". ; I am so puzzled, why doesn't this work? Keys := {} FileRead, ...
by kwibus
21 Feb 2016, 11:11
Forum: Ask for Help (v1)
Topic: Database
Replies: 12
Views: 6829

Re: Database

Thank @Coco:
I'll read the documentation and work through the demo's.
But I keep asking myself: is such a vast library really necessary for my task? It is difficult to understand.
I think there are a lot of functions in it that I never will use.

Ad
by kwibus
21 Feb 2016, 08:47
Forum: Ask for Help (v1)
Topic: Database
Replies: 12
Views: 6829

Re: Database

Please, help! I have been reading lots of documentation, and I found a library ObjCSV.ahk, but that one is too complicated for me. Can someone give me somewhat simpler examples. What I need now, are examples / tips, how to convert CSV to a "Collection", an "object of objects" or "array of arrays", i...
by kwibus
20 Feb 2016, 11:01
Forum: Ask for Help (v1)
Topic: Database
Replies: 12
Views: 6829

Re: Database

As you will understand by now, if you did not guess already, I am a total newby to AHK. Not so much to programming in general. Anyway, the next small step makes me very happy; incredible, what AHK can do in only a few lines of code: Read in a (small) .csv file, gotten from a spreadsheet. Table := {}...
by kwibus
19 Feb 2016, 19:19
Forum: Ask for Help (v1)
Topic: Database
Replies: 12
Views: 6829

Re: Database

Hello, Me again. Using AHK, it is easy to Read in a file, like a CSV / text with x lines into a variable. The second step is also not too difficult, to Loop, Parse and get each line separately in an Array or Object. But, I am struggeling with the third step: to get the y individual fields from a "re...
by kwibus
19 Feb 2016, 13:59
Forum: Ask for Help (v1)
Topic: Database
Replies: 12
Views: 6829

Database

Hello, I am learning to write AHK scripts; I have to say, it is an awesome language! :D My challenge is: a "database" program: creating, deleting, displaying (in a GUI / grid / Listview), editing, reading, writing, all of it. I found some examples, in the docs, forums, how to read a csv / text file....
by kwibus
17 Feb 2016, 08:42
Forum: Tutorials (v1)
Topic: Simple Arrays for Dummies from a non-programmer
Replies: 8
Views: 12988

Re: Simple Arrays for Dummies from a non-programmer

@Joe Glines:
Thanks! I am also at the very start now. My first question is about these lines:

Code: Select all

RAlt::
Browser_Forward::Reload
RControl::
Browser_Back::
What is there use? Are these necessary?

Go to advanced search