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

Creating a Btree index via code (AREV Specific)

At 22 JUN 2003 10:36:05AM John Brighton wrote:

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