[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]
==== UPDATE INDEXES (OpenInsight Specific) ====
=== At 02 AUG 1999 10:31:42PM Tony Ayling - Harmony Solutions wrote: ===
{{tag>"OpenInsight Specific"}}
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
tayling@harmony-solutions.com
----
=== At 03 AUG 1999 02:37AM Don Bakke wrote: ===
Tony,
Mainly for compatability reasons we have always used Index.Flush instead of Update_Index. Perhaps that will work better for you.
dbakke@srpcs.com
[url=http://www.srpcs.com]SRP Computer Solutions[/url]
[img]http://www.srpcs.com/srpicon1.gif[/img]
----
=== At 03 AUG 1999 02:50AM Carl Pates - Sprezzatura Group wrote: ===
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 [i]real[/i] soon now ) for an article on how to get round this...
Regards
Carl
Sprezzatura Group
[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=895858EE3F7587D2852567C2000DE37A|View this thread on the forum...]]