79582253

Date: 2025-04-19 10:05:38
Score: 1
Natty:
Report link

I found the reason for the error. It is the keyword "Enums".

It should be "Enum". That is,

SELECT
    MoneyInOut.Date AS Date,
    MoneyInOut.InOut AS InOut,
    MoneyInOut.Currency AS Currency,
    MoneyInOut.Value AS Value,
    MoneyInOut.Comment AS Comment
FROM
    Document.MoneyInOut AS MoneyInOut
WHERE
    MoneyInOut.InOut = VALUE(Enum.MoneyInOut.In)

This single letter "s" caused so much trouble :)

Reasons:
  • Has code block (-0.5):
  • Self-answer (0.5):
  • Low reputation (1):
Posted by: IT Student