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
|