How to Obtain Name of Child Database Alias in a Relation

Last reviewed: June 27, 1995
Article 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

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: June 27, 1995
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.