My only suggestion is to look to see if the network user login has a database field, table, or other restriction that causes different figures to be returned somewhere in the SQL query.<br><br>Steve<br><br><font size="1">-- <br>
Steve Peacocke<br>Software Development Manager<br>InSoft (NZ) Ltd.<br>P.O. Box 21051, Hamilton, New Zealand<br>Phone: 07 839-3233<br>Mobile: 0274 100-122</font><br><br><br><div class="gmail_quote">On Wed, May 28, 2008 at 4:26 PM, John Davys <<a href="mailto:john.davys@rezare.co.nz">john.davys@rezare.co.nz</a>> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>
<div><span><font face="Arial" size="2">This is an odd one
but I have had the problem demonstrated to me today as I found it hard to
believe.</font></span></div>
<div><span><font face="Arial" size="2"></font></span> </div>
<div><span><font face="Arial" size="2">I'm using BDS 2006,
Delphi personality plus the TMS component set. The application uses a
mathematical model to simulate heat transfer and does millions of calculations
solving differential equations numerically to generate temperatures over time
etc. The results are displayed in a TMS grid and a TeeChart component draws a
graph of them.</font></span></div>
<div><span><font face="Arial" size="2"></font></span> </div>
<div><span><font face="Arial" size="2">The strange thing is
that the calculations & graph come out fine if the user is logged into the
pc as a local user but not if the user is logged into the pc as a domain user.
The numbers calculated are garbage in the second case. So that's the same app,
on the same hardware, only difference being the logged in user. No exceptions
are generated, it runs without apparent error.</font></span></div>
<div><span><font face="Arial" size="2"></font></span> </div>
<div><span><font face="Arial" size="2">When logged into the
network, the user is part of a large company network (Microsoft Active
Directory) that has a strict lockdown policy where most users are severely
restricted in what they can do or see. </font></span><span><font face="Arial" size="2">When logged in as a local user
he is in the Administrators group whereas logged in as a domain user he won't
be.</font></span></div>
<div><span><font face="Arial" size="2"></font></span> </div>
<div><span><font face="Arial" size="2">This is running
under XP, SP2. It is recent hardware, an HP laptop.</font></span></div>
<div><span><font face="Arial" size="2"></font></span> </div>
<div><span><font face="Arial" size="2">I can't duplicate
the problem on any of my development or test machines. I'm on a different
network but it's still MS active directory and I'm logged in as a network
user.</font></span></div>
<div><span><font face="Arial" size="2"></font></span> </div>
<div><span><font face="Arial" size="2">A further point of
interest is that a tester, in a different organisation, reports the same issue
i.e. it doesn't produce the correct answers as a network user but does on a
standalone pc. In this case the standalone pc is a physically different
machine.</font></span></div>
<div><span><font face="Arial" size="2"></font></span> </div>
<div><span><font face="Arial" size="2">I'm struggling to
come up with any kind of mechanism that could account for this behaviour. Any
ideas?</font></span></div>
<div><font face="Arial" size="2"></font> </div>
<div align="left"><font face="Arial" size="2"><span>Cheers</span></font></div>
<div align="left"><font face="Arial" size="2">John</font></div>
<div align="left"><font face="Arial" size="2"></font> </div>
<div align="left"><font face="Arial" size="2">--------------------------------------------------------------------------------</font></div>
<div align="left"><font face="Arial" size="1">John Davys</font></div>
<div align="left"><font face="Arial" size="1">Senior Consultant - Database
Systems</font></div>
<div align="left"><font face="Arial" size="1">Rezare Systems Limited</font></div>
<div align="left"><font face="Arial" size="1">Hamilton, New Zealand</font></div>
<div align="left"><font face="Arial" size="1">ph: (07) 857 0824</font></div>
<div align="left"><font face="Arial" size="1">mobile: (027) 557 0824</font></div>
<div align="left"><font face="Arial" size="1"><a href="http://www.rezare.co.nz/" target="_blank">http://www.rezare.co.nz</a></font></div>
<div align="left"><font face="Arial" size="2"></font> </div>
<div> </div></div>
<br>_______________________________________________<br>
NZ Borland Developers Group - Delphi mailing list<br>
Post: <a href="mailto:delphi@delphi.org.nz">delphi@delphi.org.nz</a><br>
Admin: <a href="http://delphi.org.nz/mailman/listinfo/delphi" target="_blank">http://delphi.org.nz/mailman/listinfo/delphi</a><br>
Unsubscribe: send an email to <a href="mailto:delphi-request@delphi.org.nz">delphi-request@delphi.org.nz</a> with Subject: unsubscribe<br></blockquote></div><br>