CONTAINS: Searching for operator ... Error 2874

Posted by Stefan Marquardt on 23-Jun-2011 05:00

Hello,

our application provides a service for text searches. (Sonic MQ listener)

We use contains and add "*" bei default.

But how to explain programs using this service that operatorss like ! are not allowed for searching?

Any chance to search for !, ... ?

How to prevent the ABL error "QBW syntax error - unexpected end of query. (2874)"?

In this moment the client who calls the service is only our own and we have a discussion which team (client or server) has to change something.

Stefan

All Replies

Posted by Admin on 23-Jun-2011 05:49

In this moment the client who calls the service is only our own and we have a discussion which team (client or server) has to change something.

 

Both.

When providing a service, the team writing the service should make it "idiot-proof". Even the worst service consumer shouldn't cause the service to crash.

When writing the consumer, it would be nice if the consumer would prevent requests to the service that are known to cause errors.

But the service provider should always be prepared for "idiot consumers".

This thread is closed