Creating temporary table

[Ruslan Zasukhin]

on 12/9/03 11:18 PM, jda at jda at his.com 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
>> 
> 
> Do I need to create a file, or can this be done with a
> 
> tempDB = new myDatabase

You will need also 

    tempDb.Create( and here you should specify path to TMP folder.

> and then populate tempDB.myTable? And although the details of the db
> organization won't change during a session, of course the data in the
> temp file may change many times (each time the author does a real,
> not a sub-, search).

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------