Paradox Community

Items in pnews.paradox-programming

Subject:Re: Tcursor SetRange() and SetGenFilter()
Date:17 Sep 2020 00:29:48 -0400
From:"Kevin Zawicki" <numberjack@wi.rr.com>
Newsgroups:pnews.paradox-programming


You can use a range and filter, at least I just tested on a tcursor open
to a table.

Based on what you said:

>"Date Separator missing"
I think this is a specific message, applying a non valid date to date.

is dynFilt empty prior to this?

dynFilt.view()

Is CULL a logical field - add logical cast
>dynFilt["Cull"] = logical(TRUE )


Is CULL on the form / table frame?
If not add it (you can make it run visible false).

Test the filter alone.
Can you set the filter before the range?
Without the range?



Peter <peterspammenot@whiteknight.email> wrote:
>Upon opening a form I open a tcursor and do a setrange. In a custom 
>method I need to work only on the records that are 'live', in the table

>I have a logical field with values False/True.
>
>The setrange looks like this:
>tcuCur.setRange(EmpID, Wdate, Wdate) ;//empid and wdate are fields on 
>the form
>
>
>In a custom method I set a filter:
>dynFilt["Cull"] = TRUE         ;//dynfilt is dynamic array
>tcuCur.setGenFilter(dynFilt)
>
>When I run the method it chokes on the setGenFilter, it complains that 
>it cannot "set order/range" and the next part says "Date Separator missing".
>
>What I am getting from this is that when setting the filter it is 
>including the fields EmpID and Wdate. I thought that a tcursor could do

>a filter on only an existing range of records.
>
>Can anyone shed some light on this? Thanks.
>
>
>Peter


Copyright © 2004 thedbcommunity.com