VBA-SQL-Library
VBA-SQL-Library copied to clipboard
SQLSelect — AddHaving passes wrong argument order
SQLSelect: correct AddHaving argument order
- Component:
src/ClassModules/SQLSelect.cls(around 71–95)
Problem
- Calls
SQLCondition.Createwith(Field, op, Value)but signature is(Expression1, Expression2, Operator).
Snippet (actual)
NewHaving.Create Field, op, Value
Expected
NewHaving.Create Field, Value, op
Steps to Reproduce
- Add a HAVING with a non-default operator.
Actual
- Generates the comparison with swapped operands/operator.
Proposed Fix
- Pass
(Field, Value, op)consistently in both branches.