Got an extensive Access program on my PC with a backend mysqldb with a provider. I know how to get a Pass Through Query running for a simple query but I get stuck with the following SPT query (SQL Pass_through):
SELECT Bankbook.Date, Bankbook.Season ID, Bankbook.Data1, Bankbook.Data2
FROM Bankbook WHERE (Bankbook.Seaso nID=GetParamete rWaarde('strAct iefSe ason'))
The parameter (season) is set during the startup of the program.
What do I have to include in the query so that the query accepts the parameter?
I need a very detailed answer as I don't know much about SQL.
Thanks, Harry
SELECT Bankbook.Date, Bankbook.Season ID, Bankbook.Data1, Bankbook.Data2
FROM Bankbook WHERE (Bankbook.Seaso nID=GetParamete rWaarde('strAct iefSe ason'))
The parameter (season) is set during the startup of the program.
What do I have to include in the query so that the query accepts the parameter?
I need a very detailed answer as I don't know much about SQL.
Thanks, Harry