[[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]]


==== Need INDEX.FLUSH equivalent (OpenInsight Specific) ====
=== At 12 FEB 1998 12:05:39PM Ron Hollar wrote: ===
 
{{tag>"OpenInsight Specific"}}
 
<QUOTE>
In Arev, I have many commuter modules that do the following type of processing on a post-save process:



$INSERT INCLUDE, AREV.COMMON

...

OPEN 'FILES' TO FILES THEN

   OPEN 'VOLUMES' TO VOLUMES THEN

      READ FREC FROM FILES, DATAFILE THEN

         READV VREC FROM VOLUMES, FREC, 1 THEN

            FILE.NAME=DATAFILE:'*':FREC:'*':VREC

            INDEX.FLUSH( FILE.NAME, 'WO_ID_XREF')

         END

      END

   END

END



Is this capability available in OI3.5? If so, what filenames should be used, and what function name?
</QUOTE>
----

=== At 12 FEB 1998 01:20PM John Duquette wrote:  ===

<QUOTE>Ron,



You would use the Update_Index subroutine:



Its syntax is:



Update_Index(table_name, column_name, rebuildflag)



John Revelation	

</QUOTE>

----

=== At 12 FEB 1998 04:08PM Aaron Kaplan wrote:  ===

<QUOTE>$INDEX.FLUSH should still be there, unchanged.



apk@sprezzatura.com

[url=http://www.sprezzatura.com]Sprezzatura, Inc.[/url]

[img]http://www.sprezzatura.com/zz.jpg[/img]

</QUOTE>

----

=== At 13 FEB 1998 01:59AM Andrew P McAuley wrote:  ===

<QUOTE>Whoa dude! Too much work. In both AREV and OI just



    call index.flush(LiteralFileName, OptionalColumnName)



it'll do the rest 







Andrew P McAuley

A Hotel Room In Holland  Without His Normal Sig

</QUOTE>

----

=== At 13 FEB 1998 04:45PM Cameron Revelation wrote:  ===

<QUOTE>Ron,



[i]OPEN 'FILES' TO FILES THEN

OPEN 'VOLUMES' TO VOLUMES THEN[/i]



As in Arev 3.x, the names are SYSTABLES and SYSVOLUMES.  Same setup otherwise.



Cameron Purdy

info@revelation.com

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=37B949CC040811FF852565A9005DE6AD|View this thread on the  forum...]]