Mike yearwood wrote:
Hi Paul
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. ;)
Quite so. My bald, not to say blunt, assertion that you (and Stephen)
were wrong was not meant to be rude or to cause ofence. Please accept
my apology.
I misinterpreted his problem. Sys(3055) should help. That must be some
mighty long where clause.
Indeed. What I am not sure about is whether the 2040 maximum value
applies to each of the clauses (FOR, IN, WHERE) or to some combination
of them. Neither do I know which other commands and functions are
affected by his setting.
_______________________________________________
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.
