APG on DirecSQL [XPA2.5]

Florian Groothuis

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
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?

Join main@magicu-l.groups.io to automatically receive all group messages.