DIM Statement

[David Portwood]

I read a warning that a Dim statement such as:

Dim mySQL, RecSource, fldNames As String

is incorrect and should instead be written:

Dim mySQL as String, RecSource as String, fldNames as String

Is this true? It compiles ok. What is the problem?

 

[Allen Browne]

Yes. That's correct.

This is a valid line of code:
Dim mySQL
Since you did not specify a type, you get a variant.

Similarly the line:
Dim mySQL, RecSource, fldNames As String
gives you 2 untyped variables (so Variant), and one string.

That's a trap if you expect to get 3 strings.

To demonstate it's true, add these 2 lines after your single-line
declaration:
mySQL = Null
fldNames = Null
Since the Variant can contain Null, the first line succeeds.
Since the String cannot contain Null, the 2nd line gives error 94 when
executed.

 

[David Portwood]

I see. I will keep this in mind.

Thanks very much, Allen.