Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Finding Parent Tag-Name field
Message
From
07/09/2001 11:34:07
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Classes - VCX
Miscellaneous
Thread ID:
00553797
Message ID:
00553830
Views:
15
This message has been marked as a message which has helped to the initial question of the thread.
>Hello all:
>
>In a Class - Is there a way to find out the parent Tag-Name when looking at a child table when a relation has been defined beetween Parent/Child, having only the child table available?
>
>Thank you.

Roger,
With only child there how is the relation is defined ? Do you mean database level ? If so you could query :
lcChild = upper(lcTable)
lnRels = adbobjects(arrRels, 'RELATION')
for ix=1 to lnRels
 if arrRels[ix,1]=lcChild
    ? 'Parent table :',arrRels[ix,2]
    ? 'Parent tag   :',arrRels[ix,4]
    ? 'Child tag    :',arrRels[ix,3]
 endif
endfor
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform