Visual Foxpro 6.0

  • Thread starter Thread starter ola.privelius
  • Start date Start date
O

ola.privelius

I have a problem with the set filter function in foxpro. I want to make
a query that picks out all entries in an field that contain data.. any
data, but not entries that are empty. Is this at all possible?
 
This newsgroup is for Microsoft Access. You should post your question in a
FoxPro news group.
 
Hi Ola,

Since this is an MS Access newsgroup, I'm confused whether you are working
in Visual FoxPro (and just couldn't find a "fox" newsgroup) or you are
trying to use the FoxPro SET FILTER command via ODBC, which is not possible.

If you're working in FoxPro you can use the Empty() or IsBlank() functions
to separate data from lack of data. For example,

Select * From MyTable Where Empty("MyField")

To get an idea of the difference between Empty() and IsBlank() see
http://fox.wikis.com/wc.dll?Wiki~IsNullIsBlankEmpty~VFP . You can, of
course, read about these two functions in the FoxPro documentation in the
MSDN Library.
 
Back
Top