cancel
Showing results for 
Search instead for 
Did you mean: 

List of bank

Former Member
0 Kudos
179

Hi all.

How I can get list of banks only?

(recordset or some DI object)

Tnx.

View Entire Topic
Former Member
0 Kudos

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
0 Kudos

Tnx U, Juha.