topic Re: Client Specified with Select Statement is Inconsistent in Application Development and Automation Discussions

Client Specified with Select Statement is Inconsistent

Former Member — Fri, 30 Dec 2011 12:31:52 GMT

Hello All,

I am trying to fetch records from a database table across all possible Clients. But the select statement(with client specified) fetches only records from the current Client. I am trying to do the same with same database table in other part of the program but with different selection criteria and its working fine here. Any clues of whats happening??

Best regards,

rama

Re: Client Specified with Select Statement is Inconsistent

Former Member — Fri, 30 Dec 2011 12:50:16 GMT

Please make sure the addition is inserted directly after dbtab.

FROM mara
  CLIENT SPECIFIED

Thanks

Lalit Mohan Gupta

Re: Client Specified with Select Statement is Inconsistent

Former Member — Fri, 30 Dec 2011 12:54:04 GMT

As i mentioned, its working in one part of the program and not working in other part. The table i am using is EVER.

Best regards,

rama

Re: Client Specified with Select Statement is Inconsistent

Former Member — Fri, 30 Dec 2011 12:58:48 GMT

request you to please paste both the queries?

Re: Client Specified with Select Statement is Inconsistent

Former Member — Fri, 30 Dec 2011 13:37:16 GMT

Just got the doubt whether there is data corresponding to the given selection criteria. There is no data. So the statement is absolutely fine.

The problem is the system where i have access has no data so i have to do the coding and test on other systems.

Thanks for your time

Any way to delete my thread?

Best regards,

rama

Re: Client Specified with Select Statement is Inconsistent

Former Member — Fri, 30 Dec 2011 14:03:20 GMT

solved myself

Re: Client Specified with Select Statement is Inconsistent

Former Member — Fri, 30 Dec 2011 16:49:45 GMT

Why do you want it removed??

Rob