RE: SQL not optimised - Rushmore failing

2008-09-12 Thread NickC
Getting back to the original problem I think I have found the cause, not necessarily the solution but at least getting closer. Further testing suggests that the cause is SET ANSI ON!!! In ADO SET ANSI is ON by default, I don't know if there is any way that can be changed. Have been testing

Re: SQL not optimised - Rushmore failing

2008-09-12 Thread Paul Hill
On Fri, Sep 12, 2008 at 11:41 AM, NickC [EMAIL PROTECTED] wrote: Getting back to the original problem I think I have found the cause, not necessarily the solution but at least getting closer. Further testing suggests that the cause is SET ANSI ON!!! In ADO SET ANSI is ON by default, I don't

RE: SQL not optimised - Rushmore failing

2008-09-12 Thread NickC
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Hill Sent: 12 September 2008 11:59 To: ProFox Email List Subject: Re: SQL not optimised - Rushmore failing On Fri, Sep 12, 2008 at 11:41 AM, NickC [EMAIL PROTECTED] wrote: Getting back