Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Incremental Search text box and a grid
Message
From
21/07/1999 04:05:32
 
 
To
20/07/1999 16:51:21
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00243836
Message ID:
00244021
Views:
18
Hi john.

>I know this can be done, i have tried all sorts of stuff to no success.
>
>I have a text box that does which the user types in and it does an incremental search and performs an sql select into a cursor based on whats typed. I can browse that cursor and all is well. I can't seem to get the cursor to be displayed inside the grid so the user can see what is there based upon the input.
>
>any help/thoughts would be appreciated.
>

If the structure of the result set does not change, set up an updateable cursor in your form load using create cursor and bind it to your grid. Then, when you get the results of the SQL select, zap the cursor that you are using as the grid's RecordSource and APPEND FROM DBF('SqlResult').

Zapping the grid's RecordSource does not close the table and therefore will not reset the grid.

Marcia
Previous
Reply
Map
View

Click here to load this message in the networking platform