VB6 Split string into an array Error "Can't assign into array" compile error

Question

I am trying to split a string into an array in VB6.

The string is stored in a database and looks like this:

"By Value : "

Sometimes it may include something more at the end after the colon, this is why I want to split it as I am comparing it in an if statement, as shown below.

Overall my code goes like this:

Dim deliveryType(2) As String

deliveryType = Split(vaGoodsInLine.FieldValue("Comment"), ":")

If deliveryType(0) = "By Value " Then
 'Do Something
End IF

I am getting the following error

I also tried defining the array as a variant with no size like this:

Public deliveryType() As Variant

But then I get this error

Does this answer your question? Public Array Compile Error - Can't assign to array — GSerg
– GSerg, Commented Jul 21, 2021 at 18:06
@GSerg unfortunately not, I am getting a Run-time error '13' Type mismatch — Jean Camargo
– Jean Camargo, Commented Jul 21, 2021 at 18:13
If you have redeclared deliveryType as Variant, then you should have not done that. You should have removed the fixed size. — GSerg
– GSerg, Commented Jul 21, 2021 at 18:17
Don't set the size on the array... Dim deliveryType(2) As String should just be Dim deliveryType() As String. Then, the original should be fine. For the second, you could try Dim deliveryType As Variant, without ()s, as Variant can already accept both arrays and non arrays. — User51
– User51, Commented Jul 22, 2021 at 13:08

Slugsie · Accepted Answer · 2021-07-22 21:32:05Z

1

Dim deliveryType() As String
deliveryType = Split(vaGoodsInLine.FieldValue("Comment"), ":")
Dim deliveryTypeValue As String

If Not UBound(deliveryType) = 0 Then
    deliveryTypeValue = NullStr(deliveryType(0))
End If
    
If deliveryTypeValue = "By Value" Then
    'Do Something
End IF

This worked for me.

edited Jul 22, 2021 at 21:32

Slugsie

9141 gold badge7 silver badges18 bronze badges

answered Jul 22, 2021 at 10:09

Jean Camargo

4003 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

User51 Over a year ago

Did your first 2 lines get combined into one?

Collectives™ on Stack Overflow

VB6 Split string into an array Error "Can't assign into array" compile error

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related