cancel
Showing results for 
Search instead for 
Did you mean: 

RFC_READ_TABLE more then one Options line ?

Former Member
0 Kudos

Hello,

has anyone figured out how the RFC_READ_TABLE line can have more then ONE(!) OPTIONS line to submit a long where clause?

It works fine in SE37 but I can't get it to work with vbscript:

...
Set func1 = FunctionCtrl.Add("RFC_READ_TABLE")
        func1.exports("QUERY_TABLE") = "TBTCO"
        func1.exports("DELIMITER") = ";"
        func1.tables("OPTIONS").data = "SDLSTRTDT = '20090131' AND"
        func1.tables("OPTIONS").data = "JOBNAME = 'ANDI_TEST'"
...

It reads the last OPTIONS line only in the moment ?

Thank you for your thoughts !

Andi

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Here it is:


SET TableOptions=func1.Tables("OPTIONS")
        TableOptions.appendrow	
	TableOptions.value(1,1) ="SDLSTRTDT = '20080131' AND "
	TableOptions.appendrow	
	TableOptions.value(2,1) ="JOBNAME = 'ANDI_TEST' AND "
        TableOptions.appendrow	
	TableOptions.value(3,1) ="STATUS = 'A'"

I tried it with 10 lines now and it works a treat.

Former Member

Thanks Andi, excellent work!

Cant give you points for some reason though