Skip to Content
0
Former Member
Dec 02, 2005 at 02:20 PM

Visual Basic Table extract returns null

65 Views

Hi,

I have a VB program that logs onto a target system and downloads a table into a csv file. However it only returns the first 5-6 columns - all subsequent columns return null values.

I'm using the following code:

Set MyFunc = R3.Add("TABLE_ENTRIES_GET_VIA_RFC")

Dim oParam1 As Object

Dim oParam2 As Object

Dim oParam3 As Object

Dim oParam4 As Object

Set oParam1 = MyFunc.exports("LANGU")

Set oParam2 = MyFunc.exports("ONLY")

Set oParam3 = MyFunc.exports("TABNAME")

Set oParam4 = MyFunc.Tables("SEL_TAB")

oParam1.Value = "E"

oParam2.Value = ""

oParam3.Value = tabval

oParam4.Rows.Add

oParam4.Value(1, "ZEILE") = tabquery

Result = MyFunc.CALL

If Result = True Then

Set NAMETAB = MyFunc.Tables("NAMETAB")

Set SEL_TAB = MyFunc.Tables("SEL_TAB")

Set TABENTRY = MyFunc.Tables("TABENTRY")

Else

and then exporting to a text file.

Any ideas appreciated!

Thanks

Gary