DELETE TAG

Delete a tag

Syntax

      DELETE TAG <cOrderName> [IN <xcOrderBagName>]
             [, <cOrderName> [IN xcOrderBagName] list>]

Arguments

<cOrderName> is a character string that represents the order name.

<xcOrderBagName> is the name of a disk file containing one or more orders. You may specify <xcOrderBagName> as the file name with or without the path name or appropriate extension. If you do not include the extension as part of <xcOrderBagName>, Clipper uses the default extension of the current RDD.

<cOrderName …list> is an optional list of order and order bag name pairs, separated by commas. Any reference to <cOrderName> that results in either a null string (“”) or spaces is ignored. You can specify each order as a literal expression or as a character expression enclosed in parentheses. If you specify no extension for the order bag name, the current database driver supplies a default extension.

Description

This command removes an order from an order bag in the current or specified work area. If you do not specify an <xcOrderBagName>, all orders bags are searched in the current or specified work area. The first occurrence of <cOrderName> is deleted. A runtime recoverable error is raised if the order is not found.

If <cOrderName> is the active order, the database in the current or specified work area reverts to its identity order (natural or entry) and SET FILTER scoping.

A runtime error is raised if <xcOrderBagName> does not exist or if it exists but does not contain <cOrderName>.

The active RDD determines the order capacity of an order bag. The default DBFNTX and the DBFNDX drivers only support single-order bags, while other RDDs may support multiple-order bags (e.g., the DBFCDX and DBFMDX drivers).

Examples

      USE Customer VIA "DBFCDX" NEW
      SET INDEX TO Customer
      // Delete the Orders (Tags) Cust01 and Cust02 that
      // exist in the index file Customer
      DELETE TAG Cust01 IN Customer
      DELETE TAG Cust02 IN Customer
      // or
      // DELETE TAG Cust01 IN Customer, Cust02 IN Customer

Sealso

ORDDESTROY()