Re: How to handle selection from a large list with SQL backend

Steve Ellenoff wrote: > I'm curious what the best approach for this scenario is when working > with a non-vfp backend. > > User has a custom query based form where they can enter numerous > different criteria to select which data records to include in a > report they will run. When they click pr

Re: How to handle selection from a large list with SQL backend

Thanks Ted & Stephen, I'll try out those strategies and see how it goes.. At 01:27 PM 11/21/2008, you wrote: >On Fri, Nov 21, 2008 at 11:53 AM, Steve Ellenoff ><[EMAIL PROTECTED]> wrote: > > > > Another idea I had was to write to a temp table on the backend the > > records the user selected and t

Re: How to handle selection from a large list with SQL backend

On Fri, Nov 21, 2008 at 11:53 AM, Steve Ellenoff <[EMAIL PROTECTED]> wrote: > > Another idea I had was to write to a temp table on the backend the > records the user selected and then select from the temp table and > original table to get the final result. What I don't like about this > idea is hav

Re: How to handle selection from a large list with SQL backend

On Fri, Nov 21, 2008 at 10:53 AM, Steve Ellenoff <[EMAIL PROTECTED]> wrote: > I'm curious what the best approach for this scenario is when working > with a non-vfp backend. > > User has a custom query based form where they can enter numerous > different criteria to select which data records to incl

How to handle selection from a large list with SQL backend

I'm curious what the best approach for this scenario is when working with a non-vfp backend. User has a custom query based form where they can enter numerous different criteria to select which data records to include in a report they will run. When they click proceed the app pulls down the dat