on 01-31-2008 12:53 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Andi, excellent work!
Cant give you points for some reason though
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.