Hi Paul
Message: 8
Date: Thu, 24 Aug 2006 16:53:27 +0100
From: Paul Newton <[EMAIL PROTECTED]>
Subject: Re: Long SQL WHERE clauses
To: [EMAIL PROTECTED]
Message-ID: <[EMAIL PROTECTED]>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Dominic Burford wrote:
> A quick investigation seems to indicate that SYS(3055) might do the
> trick.
>
And Stephen and Mike appear to be wrong in their suggestions - see
http://code-magazine.com/article.aspx?quickid=0404022&page=3
If you are not bound by a low memory environment, consider using
SYS(3055) to set the complexity level of the FOR and WHERE clauses to
its maximum value of 2040 when you set up the environment for your
applications. This allows more complex SQL statements and more values
with IN. See the Help files for a list of other commands and functions
that are affected by this setting.
> Regards
>
Your diplomacy *appears* to need some work. ;)
I misinterpreted his problem. Sys(3055) should help. That must be some
mighty long where clause.
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
