Creating temporary table

[Charles Yeomans]

On Tuesday, December 9, 2003, at 03:55  PM, jda wrote:

> I have what I hope is a question with a simple solution. I'd like to 
> generate a cursor and display the results in a list (V4RB). Then I 
> want to let users do an iTunes-like subsearch of the cursor. I think 
> the way to do this is to create a temporary table from the contents of 
> the cursor, and do subsearches on that (at least until Valentina 2.0, 
> where searching within cursors will be allowed I think). I've looked 
> in the examples but didn't see this. What would be the steps I'd need 
> to do to populate a temporary table from the cursor?
>

Here's what I would do.  Create a new database in the TemporaryItems 
folder; you'll only need to do this once per runtime.  Then add a new 
table to it, using the cursor fields to define the fields of the new 
table. Then dump the cursor into the new table, and search away.

Charles Yeomans