About Database Connectivity

[pablo]

Hi there,

I am new to AutoIt v3.

In the past I have used VB6, ADO and Access.

Currently I have been making applications using VBscript and HTA.

Also looked into creating apps with PHP.

But I really like AutoIt v3!

After downloading AutoIt v3, I quickly learned how to create

GUI's and associate events and used controls such as FileOpen and FolderOpen(i think that is the syntax).

I think AutoIt can be an amazing full fledged language!

There are 4 thing I would like to know:

(1) Where can you find the syntax required to do ADO(I searched the forum and saw some posts on database connectivity) but I could not find any tutorials on the tutorial site.(I wish to connect to Firebird database)

Please direct me where to find information on this.

(2) Once connected to a database is there a GRID like GUI component to display the retrieved data?

(3) How to display html links on a form, and when clicked behave like it would on HTML page.

(4) Is there a grid like component that actually looks and behaves like an excel sheet to be embedded into a windows form?

I would really appreciate if you could direct me to tutorials on this if they exist.

Sincerely,

Pablo

[rabothole]

(1) Where can you find the syntax required to do ADO(I searched the forum and saw some posts on database connectivity) but I could not find any tutorials on the tutorial site.(I wish to connect to Firebird database)

Hi Pablo,

i found this a while ago but i cant remember where but here it is :

there is a couple of my bla bla in side duno where is the original script,

expandcollapse popup

; ADODB_GUI, v1.0
; Author: Chris Haney
;
; GUI wrapper example for "Database.au3" UDF.
; This will only run in the beta version of autoit, at the present time.

#include <GUIConstants.au3>
#include <Database.au3>

opt("TrayIconDebug", 0)   ;0=no info, 1=debug line info
opt("ExpandEnvStrings", 1)   ;0=don't expand, 1=do expand
opt("ExpandVarStrings", 1)   ;0=don't expand, 1=do expand

; Declare Global variables
Dim $username = "", $password = "", $aRecords, $list, $i, $i1, $i2, $button1
Dim $databaseread = IniRead("c:\delfin\system\control.sys", "Database", "Path", "")
Dim $query = "select username, passwd from cci_credit_check"; for all but text connections
Dim $DSN = "DRIVER=Firebird/InterBase(r) driver; UID=SYSDBA; PWD=password; DBNAME="& $databaseread &";"; SQL connector
;~ MsgBox(0, "" ,$databaseread)
$aRecords = _ReadData($DSN, $query)

; Create a listview of all the records


    For $i = 0 to UBound($aRecords,2)-1
        $i2 = 0 + 1
        $username = ""
        $username = $aRecords[$i][$i1]
        $password = $aRecords[$i][$i2]
        
    Next; $i
GUICreate("Users", 500, 500)
GUISetState (@SW_SHOW)

While 1
    $msg = GUIGetMsg()
    
    
    
    If $msg = $GUI_EVENT_CLOSE Then ExitLoop

    


WEnd
MsgBox(0, "Values","Your Username is : " & $username & @CRLF & "Your Password is : " & $password )

You'll need the Firebird ODBC driver

Cheers.

[randallc]

Hi,

If you look at the lonks in my signature,there are zip files for

1. Access connection; try the GuiListView display there.

2. SQL; shows GuiListView and embedded Excel at once from SQLite.

@ptrex used an SQL database with Excel display too, but not sure if it still works (might be ibn the SQL command examples in the help file now; I haven't looked)

Best, randall