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.
I notice that in this PR https://github.com/Beakerboy/VBA-SQL-Library/pull/43, you added a `.gitattributes` file that makes it so that line endings are converted to LF in the Git index. I've personally read...
Updated Function JoinString() to add mandatory parenthesis support on MS Access JOIN Query New Function Code: Private Function JoinString() Dim R As Long Dim I As Long Dim Lines() As...
Issue detected when attempting to create SQLString if 2 or more tables are necessary to JOIN. the resulting SQL contains error and cannot be used.
It’s possible to use an SQL reserved word as a field name. The library should quote field names by default to avoid errors if a user attempts this.
INSERT and CREATE do not use a WHERE clause, while SELECT, DELETE, and UPDATE do. They could inherit from different parent objects.
When master is updated, check if bin/vbaProject.bin was changed. If so, Create a new excel Addin and push it as a release.
Escape tablename: '/[^A-Za-z0-9_.]+/' Escape alias: '/[^A-Za-z0-9_]+/' Database: '/[^A-Za-z0-9_.]+/' Field. '/[^A-Za-z0-9_.]+/' Like