Forum

steinhauer
Participant
    Has successfully completed the online course Introduction
    Has successfully completed the online course Intermediate (200)
5 years, 12 months ago #18012
Up
0
Down
::

Hello Malfurion,

thank you for your reply.

But something is wrong here. My where-clause is longer

where …
and …
and ..
and pur.t_orno =: gs_auftrag:

When testing the connector, I get the following error message:

{
“message”: “Falsche Syntax in der Nähe von ‘:’.”,
“success”: false
}

I tried like instead of =, the result remains the same.
gs_auftrag is a global variable of type string, which is initialized with a default value.
In the application I need a structure, gs_projekt.
I test:

and pur.t_orno in( :gs_projekt:)

the result is unfortunately the same error message. With fixed Parameter

and pur.t_orno = ‘100023276’

the query works.