Progress Intersolv DSN

[incubi]

Well I wanted my first post to be a positive one so I hope this helps someone.

I'm new to AutoIT but wanted to test it. Our company runs an OLD copy of Progress database (8.3b) and the ODBC driver is Intersolv 3.11 with a days worth of reading this forum I was able to connect and query the database.

It was very easy in the end.

$DB = ObjCreate("ADODB.Connection")

$DB.Open("DSN=dsn_name" & ";UID=user" & ";PWD=pass")

$sql = "Select cell From cell Where true"

$Results = $DB.Execute($sql)

This is from another post.

$sql = "Select cell From cell Where true"

$QueryResults = $myDB.Execute($sql)

With $QueryResults

If .RecordCount Then

While Not .EOF

$Cell= .Fields("cell").Value

$Description = .Fields("description").Value

$Output = $Output & $Cell & @TAB & $Description &@CRLF

.MoveNext

WEnd

EndIf

EndWith

MsgBox(0,"",$Output)

$DB.Close

[PsaltyDS]

Welcome to AutoIt.

[incubi]

Welcome to AutoIt.

Thank you!

Would you have any ideas where I could be some examples or ideas how to code a data grid window?

Now that I'm connected to our database I should probably do something with it

[PsaltyDS]

Thank you!

Would you have any ideas where I could be some examples or ideas how to code a data grid window?

Now that I'm connected to our database I should probably do something with it

Depends on what you mean by "data grid window".

You can layout controls in a GUI with a rectangular pattern with the standard GUI functions.

Grid controls as drawn by some forms based application suites are not accessible to AutoIt because they are owner-drawn by the controlling app, not by the standard Windows APIs.

AutoIt also already has a pretty effective UDF for working with Excel spread sheets.

Can you define your term a little more?