Sign in to follow this  
Followers 0
Rutto

AutoIT & Databases

5 posts in this topic

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 !

Share this post


Link to post
Share on other sites



#2 ·  Posted (edited)

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 by ioliver

"Blessed be the name of the Lord" - Job 1:21Check out Search IMF

Share this post


Link to post
Share on other sites

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 ... ?

:)

Share this post


Link to post
Share on other sites

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


AutoIt Links

File-String Hash Plugin Updated! 04-02-2008 Plugins have been discontinued. I just found out.

ComputerGetInfo UDF's Updated! 11-23-2006

External Links

Vortex Revolutions Engineer / Inventor (Web, Desktop, and Mobile Applications, Hardware Gizmos, Consulting, and more)

Share this post


Link to post
Share on other sites

yeah... I also wonder about it :)

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

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