List of bank

[Former Member]

Hi all.

How I can get list of banks only?

(recordset or some DI object)

Tnx.

[Former Member · Accepted solution]

Description

The following example shows the DoQuery and MoveNext methods.

Source code

Dim Count As Long

Dim FldName As String

Dim FldVal As String

Dim i As Long

Dim RecSet As SAPbobsCOM.Recordset

Set RecSet = vCmp.GetBusinessObject(BoRecordset)

RecSet.DoQuery ("SELECT * FROM ODSC")

Count = RecSet.Fields.Count

While RecSet.EOF = False

'The inner loop runs over all the fields in one record (line) of the table

For i = 0 To Count - 1

FldName = RecSet.Fields.Item(i).Name

FldVal = RecSet.Fields.Item(i).Value

'Here you can manipulate the data as you want

Next i

'Move to the next record

RecSet.MoveNext

Wend

HTH

Juha

[Former Member · Accepted solution]

Tnx U, Juha.