Client Specified with Select Statement is Inconsistent

[Former Member]

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

[Former Member]

Please make sure the addition is inserted directly after dbtab.

FROM mara
  CLIENT SPECIFIED

Thanks

Lalit Mohan Gupta

[Former Member]

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

[Former Member]

request you to please paste both the queries?

[Former Member]

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

[Former Member]

solved myself

[Former Member]

Why do you want it removed??

Rob