Exception "A condition specified dynamically has an unexpected format" with RFC_READ_TABLE

Question

I'm using .Net Sap Connector 3 and function "RFC_READ_TABLE" to read PA0001 table data.

Where condition I'm using seem stupid, but it's only to explain that my problem is the length of this expression.

If I use:

MANDT = '100' OR MANDT = '100' OR MANDT = '100' OR MANDT = '100'

it work. But if I use

MANDT = '100' OR MANDT = '100' OR MANDT = '100' OR MANDT = '100' OR MANDT = '100'

I have this exception: "A condition specified dynamically has an unexpected format".

I tried to break the string with the character ~ and specify this character as a separator

function.SetValue ("DELIMITER", "~")

but the problem persists

Help me!

I found the problem. WHere condition cannot exceeds 72 chars :( — Daniele, Oct 25 '13 at 14:06
Resolved! In code you have to split where-condition and add every item generated IRfcTable inputTableOptions = function.GetTable("OPTIONS"); string[] aWhere = sWhereExpression.Split("~".ToCharArray()); foreach (string cond in aWhere) { inputTableOptions.Append(); inputTableOptions.SetValue("TEXT", cond); } — Daniele, Oct 25 '13 at 15:28

score 0 · Answer 1 · answered Oct 21 '21 at 12:01

Adding OP's comment as an answer to help future visitors:

OPTIONS line has a 72 char limitation, so if one has a long condition the solution would be to split it into several lines:

inputTableOptions = function.GetTable("OPTIONS"); 
string[] aWhere = sWhereExpression.Split("~".ToCharArray()); foreach (string cond in aWhere) { inputTableOptions.Append(); 
inputTableOptions.SetValue("TEXT", cond);

Exception "A condition specified dynamically has an unexpected format" with RFC_READ_TABLE

1 Answers1