Filter by form or selection

TheMSsForum.com: The Microsoft Software Forum

I have recently been working on an Access project and have found the Filter
by Form and Filter by Selection functionallity really fantastic.

Is there anything like this available in FoxPro? Any add-on to do this?

Thanks,
Cat
Top

Re: Filter by form or selection by Anders

Anders
Thu Apr 03 11:54:09 CDT 2008

"Filter by Selection"
SELECT * FROM Recipes WHERE LOWER(recipe) LIKE '%breakfast% INTO CURSOR Temp
or
SET FILTER TO 'breakfast' $ recipe

Filter By Form and Filter By Input are really the same thing in different
wrappings. You can easily make little forms where you specify fields and
search criteria to
match these Access interface services.

-Anders

"Cat Chowdy" <chowdycattakethisoutatgmaildotyouknow> wrote in message
news:OC1upRRlIHA.5396@TK2MSFTNGP04.phx.gbl...
>I have recently been working on an Access project and have found the Filter
>by Form and Filter by Selection functionallity really fantastic.
>
> Is there anything like this available in FoxPro? Any add-on to do this?
>
> Thanks,
> Cat
>



Top

Re: Filter by form or selection by Cat

Cat
Fri Apr 04 07:39:56 CDT 2008

Yes, I know I can roll my own. But it sometimes is nice to have the
functionallity straight out of the box. I want to move this client from the
Access app to VFP, and the most important thing to them is this Filter by
Form and Filter by Selection way of finding appropriate records.

Thanks,
Cat


"Anders Altberg" <anders.altberg> wrote in message
news:%23ELYYtalIHA.2268@TK2MSFTNGP02.phx.gbl...
> "Filter by Selection"
> SELECT * FROM Recipes WHERE LOWER(recipe) LIKE '%breakfast% INTO CURSOR
> Temp
> or
> SET FILTER TO 'breakfast' $ recipe
>
> Filter By Form and Filter By Input are really the same thing in different
> wrappings. You can easily make little forms where you specify fields and
> search criteria to
> match these Access interface services.
>
> -Anders
>
> "Cat Chowdy" <chowdycattakethisoutatgmaildotyouknow> wrote in message
> news:OC1upRRlIHA.5396@TK2MSFTNGP04.phx.gbl...
>>I have recently been working on an Access project and have found the
>>Filter
>>by Form and Filter by Selection functionallity really fantastic.
>>
>> Is there anything like this available in FoxPro? Any add-on to do this?
>>
>> Thanks,
>> Cat
>>
>
>
>


Top