Skip to Content

Vers12, Fatal error: like operator and parameter

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Jan 16, 2017 at 09:42 AM

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 16, 2017 at 03:56 PM

    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?

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 17, 2017 at 10:41 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 18, 2017 at 07:57 AM

    Hi

    Today it worked.

    ,

    Hi

    Today it worked

    Add comment
    10|10000 characters needed characters exceeded