Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #11732 > unrolled thread

Large filter crashing, looking for workaround

Started byMartin <Martin@spam.spam>
First post2018-06-29 13:57 +0100
Last post2018-07-03 11:43 +0100
Articles 4 — 2 participants

Back to article view | Back to comp.lang.clipper.visual-objects


Contents

  Large filter crashing, looking for workaround Martin <Martin@spam.spam> - 2018-06-29 13:57 +0100
    Re: Large filter crashing, looking for workaround "Dirk (Belgium)" <dirk.dot.herijgers@pbprojects.dot.be> - 2018-07-02 07:58 +0000
      Re: Large filter crashing, looking for workaround Martin <Martin@spam.spam> - 2018-07-03 09:33 +0100
      Re: Large filter crashing, looking for workaround Martin <Martin@spam.spam> - 2018-07-03 11:43 +0100

#11732 — Large filter crashing, looking for workaround

FromMartin <Martin@spam.spam>
Date2018-06-29 13:57 +0100
SubjectLarge filter crashing, looking for workaround
Message-ID<ph5ac9$b4b$1@dont-email.me>
Crashing when it calls VODBSetFilter()

What I would like to know, how would I do it with a special version 
using AdsSetFilter or AdsSetFilter100

VO limit is 256 but ADS limit is much higher

But I cannot even get a simple test to work.

Any ideas please?

[toc] | [next] | [standalone]


#11739

From"Dirk (Belgium)" <dirk.dot.herijgers@pbprojects.dot.be>
Date2018-07-02 07:58 +0000
Message-ID<phclv0$cdb$1@dont-email.me>
In reply to#11732
Hi Martin,

Your filter can be very small. Just call a function in your program,
like "Myfilter()"

That function can call a codeblock which is constructed just before you
place the filter.

Please try this suggestion,

Cheers, Dirk

===============================================

Martin wrote:

> Crashing when it calls VODBSetFilter()
> 
> What I would like to know, how would I do it with a special version
> using AdsSetFilter or AdsSetFilter100
> 
> VO limit is 256 but ADS limit is much higher
> 
> But I cannot even get a simple test to work.
> 
> Any ideas please?

[toc] | [prev] | [next] | [standalone]


#11740

FromMartin <Martin@spam.spam>
Date2018-07-03 09:33 +0100
Message-ID<phfcc1$h92$1@dont-email.me>
In reply to#11739
Not sure if this will work with ADS as complex code block filters I used 
in Clipper days had to be completely changed for VO.

The users are filtering on date ranges on two dates, a customer, a 
partial reference, about 8 fields in one file.

I gave myself more room by removing _FIELD-> but this will only allow 
one more search term.

Thanks

Martin


On 02/07/2018 08:58, Dirk (Belgium) wrote:
> Hi Martin,
> 
> Your filter can be very small. Just call a function in your program,
> like "Myfilter()"
> 
> That function can call a codeblock which is constructed just before you
> place the filter.
> 
> Please try this suggestion,
> 
> Cheers, Dirk
> 
> ===============================================
> 
> Martin wrote:
> 
>> Crashing when it calls VODBSetFilter()
>>
>> What I would like to know, how would I do it with a special version
>> using AdsSetFilter or AdsSetFilter100
>>
>> VO limit is 256 but ADS limit is much higher
>>
>> But I cannot even get a simple test to work.
>>
>> Any ideas please?
> 

[toc] | [prev] | [next] | [standalone]


#11741

FromMartin <Martin@spam.spam>
Date2018-07-03 11:43 +0100
Message-ID<phfk01$68d$1@dont-email.me>
In reply to#11739
Was on wrong handle

This works on 380 chars so far

METHOD AdsFilter (cFilter)	CLASS dbServer
LOCAL nHandle			AS LONGINT

nHandle			:= GetACETableHandle()

AdsClearFilter(DWORD(_CAST,nHandle))

RETURN AdsSetFilter(DWORD(_CAST,nHandle),String2PSZ(cFilter))


On 02/07/2018 08:58, Dirk (Belgium) wrote:
> Hi Martin,
> 
> Your filter can be very small. Just call a function in your program,
> like "Myfilter()"
> 
> That function can call a codeblock which is constructed just before you
> place the filter.
> 
> Please try this suggestion,
> 
> Cheers, Dirk
> 
> ===============================================
> 
> Martin wrote:
> 
>> Crashing when it calls VODBSetFilter()
>>
>> What I would like to know, how would I do it with a special version
>> using AdsSetFilter or AdsSetFilter100
>>
>> VO limit is 256 but ADS limit is much higher
>>
>> But I cannot even get a simple test to work.
>>
>> Any ideas please?
> 

[toc] | [prev] | [standalone]


Back to top | Article view | comp.lang.clipper.visual-objects


csiph-web