AutoIT & Databases

[Rutto 0]

Hi everybody,

I would like to store data in a DB instead of using variables.

Is there a way to use DB data in a script ?

Thanks in advice !

[ioliver 0]

It depends on how you want to save your data, and what DB you are using. I use Access with a VB Script, and I just run an "Insert" SQL Query.

There is a program called SQLCMD (SQLCMD) that you can use to run SQL queries from a Command Prompt that may be usefull with AutoIt. But, I haven't used it much, so it's just a suggestion.

Ian

Edit: Hyperlink

Edited October 7, 2004 by ioliver

[trids 1]

Can you be more specific: do you mean a RDBMS like SYBASE/MS-SQL server etc; or just a collection of fields like in a CSV file; or ... ?

[JSThePatriot 11]

The first thing we need to know so we can tell you if autoit can store and get info from a data system then let us know which you plan to use whether it be Access, Oracle, Sysbase, My-SQL, SQL Server... and the list goes on. Let us know please. I have worked alot with VBA and Access so if you go that route I may be of assistance, also check out the database forum at www.dbforums.com best forum I have found for databases.

I know access databases could easily be manipulated using AutoIt.

JS

[friends 0]

yeah... I also wonder about it

If AutoIT can deal with database (any database), that would be great !