VBA-SQL-Library
VBA-SQL-Library copied to clipboard
Beakerboy
Object-based Database Interaction for VBA. Create SQL Statements with VBA objects instead of string concatination.
As mentioned in [this comment](https://github.com/Beakerboy/VBA-SQL-Library/issues/56#issuecomment-1844498212), the current `.gitattributes` configurations makes it so that anyone who clones the project will see that it has pending changes. That's because Git will normalize...
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 ```vb...
SQLHelperFunctions: correct toISO Format masks (mm vs nn) - Component: `src/Modules/SQLHelperFunctions.bas` (top) ### Problem - Uses month/minute masks incorrectly; minutes display as month. ### Snippet (actual) ```vb Public Function toISO(dt)...
README: fix API typos and incorrect examples - Component: `README.md` ### Problems (examples) - `.innerJoin` (should be `.InnerJoin`). - Missing comma: `.AddWhere "u.favorite" "c.name"`. - Assignment instead of call: `.AddHaving...
SQLSubselect: SelectAs getter returns wrong variable - Component: `src/ClassModules/SQLSubselect.cls` (around 0–39) ### Problem - Getter returns an undefined identifier instead of the backing field. ### Snippet (actual) ```vb Property Get...
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) ```vb NewHaving.Create...
SQLSelect: fix UNION storage/rendering and clause order - Component: `src/ClassModules/SQLSelect.cls` ### Problems - Stores the class identifier instead of the instance in `Union`. - Name mismatch between `sUnion` and `aUnion`;...
SQLSelect: type LeftJoin/RightJoin params as String - Component: `src/ClassModules/SQLSelect.cls` (around 120–143) ### Problem - Untyped parameters (`Variant` ByRef) cause mismatches when passed into `AddJoin`. ### Snippet (actual) ```vb Public Sub...