VBA-SQL-Library icon indicating copy to clipboard operation
VBA-SQL-Library copied to clipboard

SQLSelect — AddHaving passes wrong argument order

Open Ben-Gonzalez-97 opened this issue 3 months ago • 0 comments

SQLSelect: correct AddHaving argument order

  • Component: src/ClassModules/SQLSelect.cls (around 71–95)

Problem

  • Calls SQLCondition.Create with (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

  1. 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.

Ben-Gonzalez-97 avatar Oct 16 '25 13:10 Ben-Gonzalez-97