How to Obtain Name of Child Database Alias in a Relation

ID: Q119694

The information in this article applies to:

Microsoft FoxPro for MS-DOS, version 2.5x, 2.6
Microsoft FoxPro for Windows, versions 2.5x, 2.6
Microsoft FoxPro for Macintosh, versions 2.5b, 2.5c

SUMMARY

Sometimes it is useful to programmatically derive the name of a child database that is related to the current (parent) database. The program below demonstrates how to do this.

MORE INFORMATION

The following program demonstrates how to use the SET() function to determine the name of the child database:

   SELECT 1
   USE customer IN 1 ORDER cno
   USE invoices IN 2 ORDER cno
   SET RELATION TO cno INTO invoices
   * The following line will place the alias "INVOICES"
   * in the memory variable m.child.
   m.child=RIGHT(SET("RELATION"),LEN(SET("RELATION"))- ;
           RAT(" ",SET("RELATION")))

NOTE: Instead of SET(), you could use the TARGET() function, which returns the alias name of the nth child database related to a specified alias.

Additional reference words: FoxMac FoxDos FoxWin 2.60 2.50 2.50a 2.50b 2.50c KBCategory: kbenv kbprg kbcode KBSubcategory: FxenvMemory

Last Reviewed: June 27, 1995