Skip to Content
0

Vers12, Fatal error: like operator and parameter

Jan 12, 2017 at 11:36 AM

128

avatar image

Hi

Like operator in SQL queries with parameter do not work !

Sample:


create table test(Name char(4));

insert into test (name) values ('2011');
insert into test (name) values ('2012');
insert into test (name) values ('2013');
insert into test (name) values ('2014');
insert into test (name) values ('2015');
insert into test (name) values ('2016');
insert into test (name) values ('2017');
insert into test (name) values ('2018');
insert into test (name) values ('2019');


select * from test where name like :NAME;

If you execute this in ARC and enter any value, the first select works, changing the paramter value will not return any result.

We upgraded a couple of customers between Christmas and New Year and have to switch back to Ver.11!!

This needs to fixed urgently!

Marcus

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Hakan Haslaman
Jan 16, 2017 at 09:42 AM
0

Please open a support incident, so we can forward it to the engineering.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jan 16, 2017 at 03:56 PM
0

Hi

I cannot open a support incident:


Step 1 Before you report an incident, we require you to carry out a search using the search box above.

But there is no box to enter any search and so I cannot proceed....

What to do?

Share
10 |10000 characters needed characters left characters exceeded
Michael Loop
Jan 17, 2017 at 10:41 PM
0

Marcus,

You do not see the region circled?

If not, please attach a screenshot of what you see.

Regards,

Mike Loop
Senior Support Engineer
SAP Product Support


Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jan 18, 2017 at 07:57 AM
0

Hi

Today it worked.

,

Hi

Today it worked

Share
10 |10000 characters needed characters left characters exceeded