VBA Strongly Typed Arguments

[ChloeRadshaw]

I always use Option Explicit and the compiler to check I am not doing anything stupid but I cannot understand why this is not flagged up as an incorrect type issue.


The function explcitily requests a fields datatype, whereas I am passing a recordset.

Why is this allowed?



Dim resultSet as ADODB.RecordSet

Call getDouble(resultSet, "SomeColumn")

Public Function getDouble(flds As fields, columnName As String) As Double
If (IsNull(flds.Item(columnName))) Then
getDouble = DEFAULT_DOUBLE
Else
getDouble = CDbl(flds.Item(columnName))
End If
End Function

[Oorang]

Hi Chloe,
You need to pass resultSet.Fields.

[Bob Phillips]

I think that Chloe probably knows that alraedy, but it doesn't tell her why the compiler allows it and doesn't choke.

[Oorang]

Ah, right... Helps if you read :oops: The reason the compiler is allowing you to not use Fields, is because Fields is the default method of the Class. You can tell from the little blue dot in the object browser.

http://img3.imageshack.us/img3/910/objectbrowser.png

[ChloeRadshaw]

Awesome - Thanks

This site rocks.