[<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
VS_SetOrder()        Set the controlling order of index files

Description:

  VS_SetOrder() controls which of the current work area's active indexes
  is the controlling index just like SET ORDER TO <expN> except
  VS_SetOrder() allows you to specify an ALIAS() for the index file.

Syntax:     

  l_Success = VS_SetOrder( c_NtxAlias )

Pass:       

  c_NtxAlias is a character expression that contains the base (a/k/a
  alias) name of the index file (ie. MYFILE.NTX would be "MYFILE").

Return:     

  l_Success is a logical expression that will be set to .T. if
  VS_SetOrder() was successful, otherwise .F.

Notes:      

  VS_SetOrder() is only available for Clipper v5.0x

Example:    

  IF VS_OpenDbf("CUST")     // Three indexes...
                            // CUST, SALE_TER, REGION

     VS_SetOrder("REGION")

  ENDIF

  ...
  ...


Usage:      

  VS_SetOrder() allows the programmer to not be concerned with the
  numeric order that dbSetOrder() requires.  This makes the application
  much more flexible should the database administrator remove/add
  indexes to the Data Dictionary.

See Also: VS_OpenDbf() VS_OpenLst()
This page created by ng2html v1.05, the Norton guide to HTML conversion utility. Written by Dave Pearson