VBA Rubberducking

« first day (193 days earlier) ← previous day next day → last day (2987 days later) »

RubberDuck

15:43

Go away @ticker. Nothing of interesting there today.

1 hour later…

vba4all

16:44

@RubberDuck may not necessarily be applicable here but have a look : stackoverflow.com/q/26537692/2140173

basically predefining the data types along with names if you play with it

doesn't do the strong typing but as a whole is a big part of it

my hat looks screwed up

RubberDuck

Interesting @vba4all... Interesting indeed. Not sure if that's gonna help in this case though. I'm hitting a SQL Server Db

That's a funny pic btw

vba4all

if youre just trying to make a simple wrapper

make a class, read the rs.Fields and dynamically create another class that has read-only properties

im off for the night

RubberDuck

17:13

See ya @vba4all! Thanks for the advice.

4 hours later…

Duga

21:06

[retailcoder/Rubberduck] ckuhn203 opened issue #118: Auto-Implement Interface feature

> Add some kind of tool that allows you to select a Class to implement, and autopopulate a skeleton "template" of all the properties,subs,functions that will be required in the implementing class. Will probably use class names starting with `I` as available selections.

For example, given an Interface `ICyclesDataAdapter`

Option Explicit

Public Property Get Cycles() As Cycles
End Property

Public Property Get Recordset() As ADODB.Recordset
End Property
...

Running the tool should result in a new class module that looks like this.

Implements ICyclesDataAdapter

Public Property Get Cycles() As Cycles

End Property

Public Property Get Recordset() As ADODB.Recordset

End Property

Private Property Get ICyclesDataAdapter_Cycles() As Cycles

End Property

Private Property Get ICyclesDataAdapter_Recordset() As ADODB.Recordset

End Property

[retailcoder/Rubberduck] ckuhn203 added label enhancement to issue #118: Auto-Implement Interface feature

[retailcoder/Rubberduck] retailcoder commented on issue #118: Auto-Implement Interface feature

> I like that one

Sent from my Samsung mobile
On Dec 16, 2014 4:06 PM, "Christopher McClellan" <[email protected]>
wrote:

> Add some kind of tool that allows you to select a Class to implement, and
> autopopulate a skeleton "template" of all the properties,subs,functions
> that will be required in the implementing class. Will probably use class
> names starting with I as available selections.
>
> For example, given an Interface ICyclesDataAdapter
>
> Option Explicit
>
...

> Public Property Get Cycles() As Cycles
> End Property
>
> Public Property Get Recordset() As ADODB.Recordset
> End Property
>
> Running the tool should result in a new class module that looks like this.
>
> Implements ICyclesDataAdapter
>
> Public Property Get Cycles() As Cycles
>
> End Property
>
> Public Property Get Recordset() As ADODB.Recordset
>
> End Property
>
> Private Property Get ICyclesDataAdapter_Cycles() As Cycles
>
> End Property
>
> Private Property Get...

ICyclesDataAdapter_Recordset() As ADODB.Recordset
>
> End Property
>
> —
> Reply to this email directly or view it on GitHub
> <https://github.com/retailcoder/Rubberduck/issues/118>.
>

Mat's Mug

note to self: don't include quoted text when replying with phone

RubberDuck

hahahaha

RubberDuck

21:24

I may have made a terrible mistake.......

I have added all of those code modules to my project to add this new functionality.

I think about 1/3 will get removed for deployment, but still...

Duga

[retailcoder/Rubberduck] ckuhn203 opened issue #119: Extract Interface

> Related to #118 (Inverse of basically)

Create an Interface class based on the currently active (or perhaps selected) Class module.
Name should be `I & Classname`
All Private Sub, Functions, & Properties should be removed.
All content between signature and "End" should be removed.

RubberDuck

@Mat'sMug ^

Duga

[retailcoder/Rubberduck] retailcoder commented on issue #119: Extract Interface

> I believe this is a duplicate of the "Extract interface" refactoring.

Sent from my Samsung mobile

RubberDuck

d'awwwww

Hmmmm I can't find that though.