Click or drag to resize

Target Function

X#
Returns the alias of a table that is the target for a relation as specified in the Into clause of Set RELATION.

Namespace:  XSharp.VFP
Assembly:  XSharp.VFP (in XSharp.VFP.dll) Version: 2.19
Syntax
 FUNCTION Target(
	nRelationshipNumber,
	uArea
) AS STRING CLIPPER
Request Example View Source

Parameters

nRelationshipNumber (Optional)
Type: Usual
Specifies the number of a relationship. Include a number from 1 to the number of relationships out of the specified work area. The aliases of the target tables are returned (in no specific order) until nRelationshipNumber is greater than the number of relationships. When nRelationshipNumber is greater than the number of relationships, the empty string is returned.
uArea (Optional)
Type: Usual
Returns the alias of the target table in another work area. uArea specifies a work area number and specifies a table alias. By default, the alias of the target table from the current work area is returned if you don't specify the work area or alias.

Return Value

Type: String
Character
Examples
X#
1Close Databases
2Open Database (HOME(2) + 'Data\testdata')
3Use orders IN 0 Order order_id
4Use customer IN 0 Order cust_id
5Select orders
6Set RELATION TO cust_id Into customer
7? TARGET(1)  // Displays customer
8? TARGET(2)  // Empty string
See Also