ADOSQL v6

[Thalon]

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]

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

[alnz123]

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

Much tidier, thanks