User-Defined Data Type

[bradley7]

Hi

I'm defining a data type

Type JobInfo
JobId As String
JobCustId As String
JobCustName As String
JobBusName As String
JobShortDesc1 As String
JobLongDesc1 As String * 400
JobAccType1 As String
JobNoOfItem1 As Integer
JobItemPrice1 As Integer
JobShortDesc2 As String
JobLongDesc2 As String * 400
JobAccType2 As String
JobNoOfItem2 As Integer
JobItemPrice2 As Integer
JobShortDesc3 As String
JobLongDesc3 As String * 400
JobAccType3 As String
JobNoOfItem3 As Integer
JobItemPrice3 As Integer
JobShortDesc4 As String
JobLongDesc4 As String * 400
JobAccType4 As String
JobNoOfItem4 As Integer
JobItemPrice4 As Integer
JobShortDesc5 As String
JobLongDesc5 As String * 400
JobAccType5 As String
JobNoOfItem5 As Integer
JobItemPrice5 As Integer
End Type

is there a better way to do this with an arraY?

EG
Type JobInfo
JobId As String
JobCustId As String
JobCustName As String
JobBusName As String
JobMoreInfo 5 time
JobShortDesc As String
JobLongDesc As String * 400
JobAccType As String
JobNoOfItem As Integer
JobItemPrice As Integer
end type

 

[RoryA]

You could create another type for the repeated info and then use an array of that type in the main type.

 

[bradley7]

thank you fotr answer

could you show me please

 

[RoryA]

type JobData
JobShortDesc As String
JobLongDesc As String * 400
JobAccType As String
JobNoOfItem As Integer
JobItemPrice As Integer
End type

And:

Type JobInfo
JobId As String
JobCustId As String
JobCustName As String
JobBusName As String
JobMoreInfo(4) as JobData
end type

 

[bradley7]

and that would make a 2d array

ta mate

 

[bradley7]

ok, i understrand jobs(1).customer but how do you refer to the 4 sub fields.
i was thinking jobs(1,1).JobShortDesc but that didn't work.
what about jobs(1).jobsmoreInfo(1).JobShortDesc ?

Is that right?

 

[RoryA]

Yes (though it's JobMoreInfo rather than JobsMoreInfo)

 

[bradley7]

thank you