Code: Select all
UPDATE lager
SET bestnr = :bestnr , montage = 1, kennung = :kennung
WHERE ( (gang >= :gang) AND (platz >= :platz) AND ( BestNr='0') )
ORDER BY lager.kosten desc, lager.Gang, lager.Platz
LIMIT 1
Code: Select all
UPDATE lager
SET bestnr = :bestnr , montage = 1, kennung = :kennung
WHERE ( (gang >= :gang) AND (platz >= :platz) AND ( BestNr='0') )
ORDER BY lager.kosten desc, lager.Gang, lager.Platz
LIMIT 1
RETURNING gang
How the right way to use the RET_funktion?
Have you one example for your RET_ funktion?