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

Examples

          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()