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:

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.

www.sprezzatura.com_zz.jpg

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...