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.SeasonID, Bankbook.Data1, Bankbook.Data2
FROM Bankbook WHERE (Bankbook.SeasonID=GetParameterWaarde('strActiefSeason'))
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.SeasonID, Bankbook.Data1, Bankbook.Data2
FROM Bankbook WHERE (Bankbook.SeasonID=GetParameterWaarde('strActiefSeason'))
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