ADOSQL v6

Post your working scripts, libraries and tools.
Thalon
Posts: 17
Joined: 24 Nov 2016, 04:55

Re: ADOSQL v6

Post by Thalon » 21 May 2024, 12:15

alnz123 wrote:
06 May 2024, 21:12
2. The element extraction from the array should look something like:
You can also just do something like this:

Code: Select all

Results := ADOSQL( ConnectionString, "
(
    Select top 3 No_, Description from [Project] where [No_] like 'SAMPLE-%'
)")

;Show first result only
MsgBox Results[2][1] "`n" Results[2][2]

;Show all three results one after another
for Index, Result in Results
{
    if Index > 1    ;Skip Header line
        MsgBox Result[1] "`n" Result[2]
}

pho7271
Posts: 12
Joined: 07 Dec 2023, 08:19

Re: ADOSQL v6

Post by pho7271 » 23 May 2024, 08:29

@Ruevil2
Can you provide an operation Example of CSV file V2 version, thank you

alnz123
Posts: 14
Joined: 31 Jan 2021, 22:01

Re: ADOSQL v6

Post by alnz123 » 24 May 2024, 04:23

Thalon wrote:
21 May 2024, 12:15

;Show first result only
MsgBox Results[2][1] "`n" Results[2][2]
Much tidier, thanks

Post Reply

Return to “Scripts and Functions (v2)”