G'day

I am normalising our HR application and slowly removing Multi Value lists in favour of a List Box drawing Data from a Table. A button on the window calls another window for data entry of a new record and when closed - refreshes the VIEW window with the new record.

My problem is that I use BTREE.EXTRACT to get the records to place in the view and UPDATE_INDEXES with the update option never seems to work - fine if you REBUILD but now the tables are getting large the rebuild is getting really slow, and a bit unnecessary for just one new record.

Has anyone else experienced this or ca tell me how to get around it?

I would be grateful for any help or work around.

Thanks

Tony Ayling

[email protected]

Tony,

Mainly for compatability reasons we have always used Index.Flush instead of Update_Index. Perhaps that will work better for you.

[email protected]

SRP Computer Solutions

Hi Tony,

I'd say you have a problem with your indexes then …Before you call Update_Index do you have any transactions waiting to be flushed?

i.e. if you edit the 0 record in the !file are there any transactions waiting to go? May be worth checking…BTW this index is not on a symbolic column right? If so Index Transaction records don't always get created - see the latest SENL ( out real soon now ) for an article on how to get round this…

Regards

Carl

Sprezzatura Group

View this thread on the forum...