Article View: borland.public.vdbase.data.sql
Article #141Re: Length Limit of Filter String?
From: Thomas Preston
Date: Thu, 21 Jan 1999 00:00
Date: Thu, 21 Jan 1999 00:00
36 lines
1618 bytes
1618 bytes
I was encountering an error in a complex filter string that had the format . . . form.rowset1.filter=(this=that OR that=this) AND (thisthing=thatthing OR thatthing=thisthing) AND (a=1 OR a=2 OR b=1 OR b=2 OR c=1 OR c=2 OR d=1 OR d=2 OR e=1 OR e=2 OR f=1 OR f=2 OR g=1 OR g=2 OR h=1 OR h=2 OR i=1 OR i=2) AND (theother=this OR this=theother) The problem was in the longest segment (a=1 . . .). I think that there must be a limit to the number of arguments contained within parens. Anyway . . . I resolved the issue by modifying the form (splitting the controls). In other words . . . WHEN ALL ELSE FAILS, MANIPULATE THE DATA. Tom Preston tgp@compuserve.com On Wed, 20 Jan 1999 14:49:30 +0800, "Geoff S. Wass" <gswass@ibm.net> wrote: >Tom, > >It will be 512, 1024, 2048 or 4096 - I don't know at all but these >numbers seem to be associated with other limits in the mists of my mind. >I know 4096 is the longest line you can have, but I don't know if it is >the longest filter string. Why do you ask? > >-- >Geoff Wass >Kuala Lumpur, Malaysia > > >=>=> More dBASE info at http://members.theglobe.com/Geoff_Wass <=<= > >
Technical Details
Message-ID:
<36a771af.9942236@forums.borland.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<36a4afb3.62426926@forums.borland.com> <36A57C79.42E3DFBA@ibm.net>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: ff5a1,3a53f38599f8e07c X-Google-Attributes: gidff5a1,public From: Thomas Preston Subject: Re: Length Limit of Filter String? Date: 1999/01/21 Message-ID: <36a771af.9942236@forums.borland.com> X-Deja-AN: 435314534 References: <36a4afb3.62426926@forums.borland.com> <36A57C79.42E3DFBA@ibm.net> Organization: Another Netscape Collabra Server User Newsgroups: borland.public.vdbase.data.sql