Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Set filter to doesn't work ?

Status
Not open for further replies.
ChrizzA

ChrizzA

Programmer
Jun 8, 2005
11
NL
Hello,

I've got a problem with the function "set filter to". I have a dataset which includes a date field. For some records this date field is filled, for other it's empty. Now i only want to show the records where this date field is empty, so i was thinking of doing this with a filter since i need the other records later on.

Currently i have something like this:

set filter to mydatefield == ctod('') in mytable

But this doesn't work for some reason because i still see records which have their datefield filled.

Can someone please help me with this ?

P.S. I allready searched here on this forum and with google but can't the right answer.
 
Sort by date Sort by votes
Try
Code: 
set filter to empty(mydatefield)


Although I would not recommend a filter, but rather an SQL statement.



Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.
ReFox XI (www.mcrgsoftware.com)
 
Upvote 0 Downvote
I've have tried your suggestion but the records with a date keep showing up in my dataset. Is there anything else i need to do ?

This dataset is filled using a sql statement, but i want to show the records on screen without a date and then use both in my report so i thought a filter would be a better idea than filling the dataset twice with sql. If i don't get this going quickly that is what i'm gonna do :)
 
Upvote 0 Downvote
I've have tried your suggestion but the records with a date keep showing up in my dataset.
Click to expand...

Really? I cannot imagine why they would show up in your filtered data. Here is a test.

Code: 
CREATE CURSOR mytable (date1 d)
APPEND BLANK
? EMPTY(date1)  &&& .T.


Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.
ReFox XI (www.mcrgsoftware.com)
 
Upvote 0 Downvote
Personally, I'd go with Mike's SQL suggestion - filters can be pretty slow, especially with large datasets.

However, one thing to keep in mind with your filter scenario is that you have to move the record pointer after you set the filter for the filter to take effect. Just issue a LOCATE will move it to the first filtered record.

Regards,
Jim
 
Upvote 0 Downvote
After applying the filter and moving the record pointer with a locate, the records with a date are still there. If i enter your command in the command window like this:

Code: 
? empty(mytable.mydatefield)

This returns .F. which offcourse is logical and thereby should not be present in my dataset when i set the filter.
 
Upvote 0 Downvote
Are you sure you have the correct table selected when setting the filter? Filters only apply to the currently selected table.
So if you set filter in one table, then select another, there will be no filter.


-Dave Summers-
[cheers]
Even more Fox stuff at:
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

xinjie
  • Locked
  • Question
CursorAdapter.CursorRefresh doesn't seem to work when starting a VFP transaction 1
2
Replies
20
Views
880
Chris Miller
Chris Miller
Jay9988
  • Locked
  • Question
VFP to doesn't launch Ms Word's mailmerge 1
Replies
10
Views
1K
Jay9988
Jay9988
Bryan - Gendev
  • Locked
  • Question
Problem with SET DEFAULT TO 2
2 3 4
Replies
74
Views
1K
Bryan - Gendev
Bryan - Gendev
Piotr Czekalski
  • Locked
  • Question
How to set font size and type in TXT file thru VFP6/9 3
2 3
Replies
57
Views
2K
Piotr Czekalski
Piotr Czekalski
SitesMasstec
  • Question
Set a TAG for a field programmaticaly 3
2
Replies
29
Views
1K
SitesMasstec
SitesMasstec

Part and Inventory Search

Sponsor

Back
Top