Sign in to follow this  
Followers 0
Desker

lookin for help on getting autoit v3 to get info from a database list

9 posts in this topic

lookin for help on getting autoit v3 to get info from a database list

any help would be helpful

thx

Share this post


Link to post
Share on other sites



what kinda of database? access, sql, txt?

Share this post


Link to post
Share on other sites

lookin for help on getting autoit v3 to get info from a database list

any help would be helpful

thx

lookin for getting info from mysql or sql server then replying back with the nfo or a txt file would work if I can search in the file then report back the nfo of the line in the txt file

Share this post


Link to post
Share on other sites

I do use AutoIt with Mysql. Do you need help to connect ?

Or to create a text file from a SQL Table ?

Share this post


Link to post
Share on other sites

I do use AutoIt with Mysql. Do you need help to connect ?

Or to create a text file from a SQL Table ?

thx for the help Was just lookin for the commands to use. I've been lookin all over to find them

Share this post


Link to post
Share on other sites

#8 ·  Posted (edited)

Hello,

A simple which uses :

- An odbc Connection.

- Mysql (but this kind of very simple SQL Statement will work with others databases).

- The Beta Version of AutoIt which handles COM.

$ado = ObjCreate( "ADODB.Connection" )   ; Create a COM ADODB Object  with the Beta version
$ado.Open( "DSN=My_ODBC_DSN" )           ; Must exists in your odbc links.
$adors = ObjCreate( "ADODB.RecordSet" ) ; Create a Record Set to handles SQL Records
$adors.Open( " Select * from MyTable", $ado ); Execute a SQL Select

While not $adors.EOF                                              ;  
    ConsoleWrite( $adors.Fields( 1 ).Value&@CRlf )   ; First Column in th AutoIt console
    $adors.MoveNext                                             ; Go to the next
WEnd

HTH,

Francis

Edited by Francis Lennert (France)

Share this post


Link to post
Share on other sites

thx to both of you Francis Lennert & ivan for your help. The nfo both have gaven me has put me on the

right path.

thx

Desker

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0