Publish date: 2003-01-05
Arrays reading (VB)
Sub sample5() Dim cn As New ADODB.Connection ' use file with parameters of connection cn.Open "file name=e:\database\employee.ibp" Dim cmd As New ADODB.Command cmd.ActiveConnection = cn 'read JOB.LANGUAGE_REQ VARCHAR (15) [1:5] cmd.CommandText = "select job_code,language_req from job" Dim rs As ADODB.Recordset Set rs = cmd.Execute Debug.Print "JOB.LANGUAGE_REQ --------------" ' copy of data of array field. Call of rs("language_req") always download Dim lang_req As Variant While Not rs.EOF Debug.Print "JOB_CODE:" & CStr(rs("job_code")) Debug.Print "LANGUAGE_REQ:" lang_req = rs("language_req") If (IsNull(lang_req)) Then Debug.Print ">[NULL]" Else Dim i As Long ' Walk of elements of array For i = LBound(lang_req) To UBound(lang_req) Debug.Print ">" & lang_req(i) Next i End If Debug.Print "----------------" rs.MoveNext Wend End Sub 'sample5