Need INDEX.FLUSH equivalent (OpenInsight Specific) [Revelation On-Line Wiki]

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

At 12 FEB 1998 12:05:39PM Ron Hollar wrote:

OpenInsight Specific

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?

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

Ron,

You would use the Update_Index subroutine:

Its syntax is:

Update_Index(table_name, column_name, rebuildflag)

John Revelation

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

$INDEX.FLUSH should still be there, unchanged.

apk@sprezzatura.com

Sprezzatura, Inc.

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

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

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

Ron,

OPEN 'FILES' TO FILES THEN OPEN 'VOLUMES' TO VOLUMES THEN

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

Cameron Purdy

info@revelation.com

View this thread on the forum...