Skip to main content

All Questions

Tagged with
Filter by
Sorted by
Tagged with
34 votes
5 answers
17k views

Creating ADODB Parameters on the fly

I have put together a small wrapper class to simplify creating parameterized ADODB queries with VB6/VBA. At this point I'm keeping things simple, so it's only supporting input parameters and from what ...
Mathieu Guindon's user avatar
5 votes
1 answer
5k views

Making VBA generated dynamic SQL statements safe against injection

I need to use SQL extensively in VBA macros that I write. Since the DB is from our enterprise application, I use vendor's library for this. I generate dynamic queries, sometimes with many ...
Teeracroptus's user avatar