Sign in to follow this  
Followers 0
Ghost21

Calling My SQL Experts / AutoIT

5 posts in this topic

First I don't want a UDF as thats keeping the Sql statements in the code and not in the database. This

is why I'm trying to pass the variable like I am.

Here I'm trying to pass the $DomainPC to the Database and get it to return anything..

Some indicator that it either sees it in the database or not.

$Recordset.open("call _RA2011_All_PCINFO ('@" & $DomainPc & "');", $Connection)
If $Recordset.RecordCount <> 0 Then
else
GUICtrlSetData($Edit, "Found New Device: " & $DomainPc & " on " & $Founddomain & @CRLF, 1)
$Connection.Execute("INSERT INTO PCData (DOMAIN,DEVICE) VALUES ('" & $Founddomain & "','" & $DomainPc & "')")
EndIf

This is the routine I have setup in the Mysql Database

-- --------------------------------------------------------------------------------

-- Routine DDL

-- Note: comments before and after the routine body will not be stored by the server

-- --------------------------------------------------------------------------------

DELIMITER $$

CREATE DEFINER=`root`@`localhost` PROCEDURE `_ra2011_all_pcinfo`(IN DEVICEvar varchar(25))

BEGIN

SELECT Domain, DEVICE, IP, MAC, SerialNumber, Description, Tombstoned

FROM PCData

WHERE DEVICE = DEVICEvar;

END

Share this post


Link to post
Share on other sites



#2 ·  Posted (edited)

Does anyone know how to call a Routine or a View in a MySQL DB from Autoit with a Variable ? PLEASE HELP..

Edited by Ghost21

Share this post


Link to post
Share on other sites

Look at ADO section in http://www.w3schools.com/

There are objects for this:

ADO Command and ADO Parameter

http://www.w3schools.com/ado/ado_ref_command.asp

http://www.w3schools.com/ado/ado_ref_parameter.asp

Share this post


Link to post
Share on other sites

I would like to say that helped.. but it just confussed me more..

I can't believe that everyoen puts the code in the program and not in the database. Then pass the required variable

to the database and have it return the results..

Share this post


Link to post
Share on other sites

There are reasons for that: stored procedure are not portable and only have little expressive power compared to applicative language(s).

So while it makes full sense to store as much SQL as needed in the form of constraints, triggers and views, stored procedure are much less of interest, should you have to move your DB from one engine to another.

Then having a procedure mapping a subselect is questionable. Can't you just use a subselect? You're turning the SQL engine into what it's not: an API for your application.


This wonderful site allows debugging and testing regular expressions (many flavors available). An absolute must have in your bookmarks.
Another excellent RegExp tutorial. Don't forget downloading your copy of up-to-date pcretest.exe and pcregrep.exe here
RegExp tutorial: enough to get started
PCRE v8.33 regexp documentation latest available release and currently implemented in AutoIt beta.

SQLitespeed is another feature-rich premier SQLite manager (includes import/export). Well worth a try.
SQLite Expert (freeware Personal Edition or payware Pro version) is a very useful SQLite database manager.
An excellent eBook covering almost every aspect of SQLite3: a must-read for anyone doing serious work.
SQL tutorial (covers "generic" SQL, but most of it applies to SQLite as well)
A work-in-progress SQLite3 tutorial. Don't miss other LxyzTHW pages!
SQLite official website with full documentation (may be newer than the SQLite library that comes standard with AutoIt)

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