on 07-03-2012 1:25 PM
Hi all,
In RFC_TABLE_READ as I can put in an option like? when the field type like * XXXX *.
It's more if someone could tell which are the operators that exist in the where clause.
Thank you very much
Are you sure you are developing in Java? Can you be more specific what you want to do?
Regards,
Benny
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Benny,
Yes, I'm sure, I attaching my code:
try { | |||
JCoParameterList jcoParameterList = function.getTableParameterList(); | |||
JCoTable jcoTableOptions = jcoParameterList.getTable("OPTIONS"); | |||
JCoTable jcoTableFields = jcoParameterList.getTable("FIELDS"); | |||
jcoTableOptions.clear(); | |||
jcoTableFields.clear(); | |||
jcoTableOptions.appendRow(); | |||
jcoTableOptions.setValue("TEXT", "XBLNR CT '*" + sXBLNR.trim() + "*' AND "); | |||
jcoTableOptions.appendRow(); | |||
jcoTableOptions.setValue("TEXT", "UMSKZ EQ 'I'"); |
jcoTableFields.appendRow(); | |||
jcoTableFields.setValue("FIELDNAME", "REBZG"); | |||
jcoTableFields.appendRow(); | |||
jcoTableFields.setValue("FIELDNAME", "REBZJ"); | |||
jcoTableFields.appendRow(); | |||
jcoTableFields.setValue("FIELDNAME", "REBZZ"); | |||
jcoTableFields.appendRow(); | |||
jcoTableFields.setValue("FIELDNAME", "SGTXT"); | |||
connect.execute(function); |
JCoTable jcotable = function.getTableParameterList().getTable("DATA"); |
In the bold line I need put one LIKE, but I don't know the operation code for this.
This code have the next error:
com.sap.conn.rfc.exceptions.RfcGetException: A condition specified dynamically has an unexpected format.
Many thanks.
Hello All,
Could you please tell me if I want to send big query for OPTION table what should be the better approach. One in my mind we can execute in batch.
As option field having some limitation in size So I am getting invalid sql exception due to truncation on my query.
Thanks in advance
Raj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
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.