SELECT COMMAND BAD RESULTS! (OpenInsight 16-Bit Specific)
At 04 APR 2002 10:06:23PM b cameron wrote:
We have a client site with 125 users on Novell 5.1, Client 3.30.0.0
using the lh.nlm 5.0.
If I log in to Novell as 1 user and then into the OI app. and
do RLIST("SELECT CLIENTS",5,
,
,'') I get a different numberof items returned than with my own user logins to Novell and OI.
I have higher rights then the users in question.
I have tried to see if the OI user levels are affecting things
but do not have conclusive results.
BTW - the clients table has approx. 75000 records of an average
byte size of 800k.
Any help is appreciated!
At 05 APR 2002 12:17PM Don Miller - C3 Inc. wrote:
Is the table being searched somehow different depending on the login name? Same native name, but belongs to a different "account", perhaps. If it's "GLOBAL" it shouldn't matter. Is the table Indexed? and is !TABLE somehow different from one login to the next, if so. Otherwise, there shouldn't be any difference based on the security / rights of the user unless you have somehow included some restrictions that are not obvious (perhaps network rights), since a select may imply a sort-file if you are doing a select by clause.
Just a thought
Don
At 05 APR 2002 02:04PM b cameron wrote:
Don,
Those are the kind of thoughts we need, thanks.
I will look at some of those issues. There have
been more than a few hands in the soup.
With re: to OI users. We have not implemented our
own user table and login protocol yet. Simply
using OI's and most users are 'USERS' only.
I suspect, as you that it may be network rights.
Any more information is appreciated.
Thanks!