DBSELECTAREA()

Change to another work area

Syntax

DBSELECTAREA(<xArea>) --> NIL

Arguments

<xArea> Alias or work area

Returns

DBSELECTAREA() always returns NIL.

Description

This function moves the Harbour internal primary focus to the work area designated by <xArea>. If <xArea> is numeric, them it will select the numeric work area;if <xArea> is character,then it will select the work area with the alias name.

DBSELECTAREA(0) will select the next avaliable and unused work area. Up to 255 work areas are supported.Each work area has its own alias and record pointer, as well as its own FOUND(),DBFILTER(),DBRSELECT(), and DBRELATION() function values.

      FUNCTION Main()
      LOCAL nId
      USE Tests NEW INDEX Tests
      USE Tests1 NEW INDEX Tests1
      DBSELECTAREA(1)
      nId:=Tests->Id
      DBSELECTAREA(2)
      IF DBSEEK(nId)
         ? Tests1->cName
      ENDIF
      DBCLOSEALL()
      RETURN NIL

Status

Ready

Compliance

This function is CA-CLIPPER compatible.

Files

Library is rdd

See Also

• DBUSEAREA()
• SELECT()