Creating a Btree index via code (AREV 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 22 JUN 2003 10:36:05AM John Brighton wrote:

AREV Specific

I've tried the code I found on the web. Still can't get it to work. Bombs with a numeric expected and cannot tell what is causing it.

Does anyone have any code they knows works for creating a Btree index on a symbolic?

At 22 JUN 2003 10:59AM Ray Chan wrote:

John,

There should be no difference in the code for creating Btree index on a symbolic vs non-symbolic.

Maybe it would be helpful if you post the code that you are using.

Ray Chan

At 23 JUN 2003 01:40AM Peter Lynch wrote:

Here is a segment of code that does it through playback. The index must not exist before running it.

          TEMPLATE.FILE.NAME=COMMANDS'

          IF VIRTUAL.ENVIRONMENT=AREV3' THEN

              TEMPLATE.FILE.NAME=SYSWINDOWS'

END

          PLAYBACK= '{F5}WINDOW{SPACE}{@}'

          PLAYBACK := TEMPLATE.FILE.NAME

          PLAYBACK := '{@}{SPACE}BTREE{CR}'

          PLAYBACK :=FILE.NAME:  '{CR}'  : FIELD.NAME:  '{CR}Y{CR}'

          PLAYBACK := 'N'

          PLAYBACK := '{F9}'

          PLAYBACK := 'Y{CR}{ESC}'

          PLAYBACK := '{ESC}{SPACE}'

          PLAYBACK := '{CR}'

          CATALYST(  'K'  , PLAYBACK)

          THROW.AWAY=REPLY.MSG(  'Creating btree index for %1%|in file %2%'  ,  'Please Wait'  , FIELD.NAME:  '|'  : FILE.NAME)

          INPUT.CONVERSION='

          SAVE.DATA('DICT.': FILE.NAME, '7', INDEX.FIELD.NAME, INPUT.CONVERSION)

At 23 JUN 2003 03:05AM [url=http://www.sprezzatura.com" onMouseOver=window.status= Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:

Write numeric one onto field 6 of the dictionary item in question then call index.flush(FileName, ColumnName).

The Sprezzatura Group

World Leaders in all things RevSoft

At 23 JUN 2003 05:15AM Peter Lynch wrote:

I really like that solution. I can finally get rid of that playback script.

Is there a similar clean solution for building Xref indices?

At 23 JUN 2003 05:31AM [url=http://www.sprezzatura.com" onMouseOver=window.status= Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:

http://www.sprezzatura.com/revmedia/v2i4a2.htm

The Sprezzatura Group

World Leaders in all things RevSoft

At 23 JUN 2003 08:28PM John Brighton wrote:

I tried using that code in the knowledge base but couldn't get it to work. This sounds simpler, I'll try this.

Thanks,

John

View this thread on the forum...