>I am new to using SPT and am wondering if the only way to index is to "INDEX ON whatever TO index"? I am using VFP tables now but I am using SPT to be able to use a different data back end in the future without modifying the code much. I need to set relations into my cursors I have created for reporting.
>
>Thanks in advance.
>
>Tommy
You can use TAG instead of TO. The cursor must be in row buffering and not table buffering as well. When you close the cursor, the index [temp]file is erased automagically along with the temp dbf file of the cursor.
Can you not create a multi-table cursor to join your tables instead of using multi cursors and relations? Or is that not feasible because of the number of tables involved?
Mark McCasland
Midlothian, TX USA