Re: MS Access ODBC call to set session variable in MySQL

[Beate Steiner]

Hello David,

you can call your procedure from Aces like this

Connection.Execute "SELECT myProcedure(myParam)"

If you need a Seesion Variable, you can create another procedure, to set the Variablelike this.

/* mySQL*/
delimiter //
DROP FUNCTION IF EXISTS setVar//
CREATE FUNCTION setVar (Var CHAR(255)) RETURNS INTEGER
BEGIN
SET @myVar = Var;
RETURN 0;
END //
delimiter ;

/*ACESS*/
Connection.Execute "SELECT setVar(myParam)"
Connection.Execute "SELECT myProcedure()"