Timeline for VBA-Sync code feedback
Current License: CC BY-SA 4.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 18, 2020 at 2:28 | comment | added | ARickman | @beyphy I have had to use the ADODB library so extensively that I have created several of my own wrapper classes. Overtime I have improved them, from an architectural standpoint and by documenting and addressing the various bugs in the library. It took many man hours to get to the point I have it at now, so I figure it is worth sharing with others so they don't have to do the same. Saying that, here is the github link to the code: github.com/rickmanalexander/ADODBDataAccessAPI. | |
| Aug 17, 2020 at 23:27 | answer | added | TinMan | timeline score: 2 | |
| S Aug 17, 2020 at 22:54 | history | suggested | Greedo | CC BY-SA 4.0 |
Fix formatting
|
| Aug 17, 2020 at 22:13 | comment | added | beyphy | Ah I have no idea. Thanks for the heads up though. My code wasn't really meant to handle a scripting text file. So if it doesn't work I'll just put it as a caveat on my github. | |
| Aug 17, 2020 at 21:00 | history | tweeted | twitter.com/StackCodeReview/status/1295465445219328007 | ||
| Aug 17, 2020 at 18:47 | comment | added | TinMan |
In order to respond to events of an object in a scripting text file you will need to declare the library and type of object. The only way this can be done is using CreateObject. For example Set Connection = WScript.CreateObject("ADODB.Connection", "Connection_"). With this setup Sub Connection_ExecuteComplete(RecordsAffected, pError, adStatus, pCommand, pRecordset, pConnection) will fire correctly. But I'm not sure that this will work in a scripting class. Hopefully, with a little duck, one of the real Gurus can elaborate on this.
|
|
| Aug 17, 2020 at 18:44 | review | Suggested edits | |||
| S Aug 17, 2020 at 22:54 | |||||
| Aug 17, 2020 at 17:18 | review | First posts | |||
| Aug 17, 2020 at 19:02 | |||||
| Aug 17, 2020 at 17:14 | history | asked | beyphy | CC BY-SA 4.0 |