Today I tried to use the APG-button in de DirectSQL-screen, but I can't see the additional value. Here's the statement I want to implement:
SELECT TOP(1) Waarde FROM ST_StaffelsPCF WHERE Vestiging= N':1' AND Artikelnummer= N':2' AND Kenmerk= N':3' AND Argument= N':4' AND Staffel>:5 ORDER BY Staffel
The program is called by 6 parameters, one of them being the output parameter. If I use the APG I get the following message.
If I remove all the parameters the APG works. But what's the use then?