|Subject:||Re: Tcursor SetRange() and SetGenFilter()
|Date:||17 Sep 2020 00:29:48 -0400
|From:||"Kevin Zawicki" <firstname.lastname@example.org>
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?
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 <email@example.com> 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
>In a custom method I set a filter:
>dynFilt["Cull"] = TRUE ;//dynfilt is dynamic array
>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.