generating index on the fly?

generating index on the fly?

Postby MOISES » Sun Sep 09, 2007 11:08 am

Hi,

I have a database opened in shared mode and indexed. I can´t close the database or the index.

I would like to add a new index on the fly, do a report, and restore the original index, but I can´t close either the database or index.

There must be:

openfile()
....

doreport()



function openfile()

select 1

use test index test shared new


select 2

use other index other shared new


function doreport()

select 1

saveoriginalindex()

createnewindexonthefly()

report

restoreoriginalindex()



I have tried set index &tempind additive and OrdSetFocus( 1), but always uses the new temp index, not the original one that I must restore.


How can I do it?. Thanks a milion!!!!!!!!!!!!!!!!!!!!!
MOISES
 
Posts: 838
Joined: Wed Aug 22, 2007 10:09 am

Re: generating index on the fly?

Postby Enrico Maria Giordano » Sun Sep 09, 2007 11:20 am

The easier way might be to open your original table in a new area with a different alias.

EMG
User avatar
Enrico Maria Giordano
 
Posts: 8710
Joined: Thu Oct 06, 2005 8:17 pm
Location: Roma - Italia

Postby MOISES » Sun Sep 09, 2007 12:07 pm

Yes, you were right!!!!. Thanks a lot!!!!!!!
MOISES
 
Posts: 838
Joined: Wed Aug 22, 2007 10:09 am


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: Google [Bot] and 35 guests