Tuesday, May 1, 2007

Tip of the Day: Using New SET PROGRESS Command in R:BASE for Windows

Supported Versions:

. R:BASE 7.6 for Windows (Build: 7.6.1.30420 or higher)
. R:BASE C/S:I 7.6 for Windows (Build: 7.6.1.30420 or higher)
. R:BASE Turbo V-8 for Windows (Build: 8.0.15.30420 or higher)

Syntax: SET PROGRESS ON/OFF

Default: OFF

Did you know that you can use the new SET PROGRESS ON command to
display a cool progress bar to show the progress when building
indexes, packing or reloading a database?

You may use this new setting when rebuilding INDEXes, PACKing or
RELOADing a database.

Example 01:

  CONNECT RRBYW14
  PACK INDEX

Example 02:

  CONNECT RRBYW14
  PACK TABLE Customer
  PACK TABLE InvoiceHeader
  PACK TABLE InvoiceDetail

Example 03:

  CONNECT RRBYW14
  RELOAD RRBYWNEW

Example 04:

  DISCONNECT
  SET MULTI OFF
  PACK RRBYW14
  SET MULTI ON

Example 05:

  DISCONNECT
  SET MULTI OFF
  CONNECT RRBYW14
  PACK
  SET MULTI ON

Enjoy and make sure to have fun!

Very Best R:egards,

Razzak.

Reply via email to