Hi All,
I am developing something you might find interesting - and I need some help!

I have written a 'Hot Search' form - for looking up a patient using surname and DOB; please read on ...

The search is 'hot' i.e. as soon as you type a letter in the surname field a search is triggered and the (top 50) matches appear in a grid.

With SQL server this works very nicely, interactive change event fires of an Asynchronous query to server (a built in typing delay of .25 seconds before query is sent to reduce traffic). As the query is sent asynchronously the user experiences no typing delay, the query is fully optimised on SQL server and grid is populated almost instantly with a database of a million or so patients - so this is cool.

However - I have a problem!! The search needs to work in the same way but with a data source of FoxPro native tables.

I really need the asynchronous behaviour - OK I thought, the asynchronous property is only present in a connection - so I need to create a connection via ODBC to reach the fox tables - I can then set the asyn property .T. and have very few code changes as a result.

However I did not predict the behaviour of this .. I discover the client is then running the query and fox wait for the query to complete and then loads the data asynchronously. The cursor then sits waiting for the query to end before accepting another key press.

So my understanding is that I need to get this query onto the server -but how do I do this with native FoxPro tables, is there any way I can get FoxPro to work in a client server way with native FoxPro tables?

Can you help ?

Many thanks in advance