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

SQLSelect — union array not initialized & name mismatch

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

SQLSelect: initialize aUnion and fix name mismatch

  • Component: src/ClassModules/SQLSelect.cls (declarations and initializer)

Problem

  • Declares sUnion() while other code references aUnion(); not initialized in Class_Initialize.

Expected

Private aUnion() As Variant

Private Sub Class_Initialize()
    ReDim aJoin(0)
    ReDim vFields(0)
    ReDim aOrder(0)
    ReDim aUnion(0)
    ' ...
End Sub

Steps to Reproduce

  1. Use UNION features without prior array setup.

Actual

  • Append/iteration fails or produces wrong SQL.

Proposed Fix

  • Rename to aUnion and ReDim in initializer.

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