🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.multi-tier
Article #859

Re: Syntax for master/detail if column names differ

#859
From: Jeff Overcash (TeamB)
Date: Wed, 31 Jan 2001 02:31
28 lines
2051 bytes
Instead of Tables maybe you should look at queries.  The detail query just needs
a where clause that has as the param name the same as the master column.

Howard Lee Harkness wrote:
> 
> I need to build a MasterSource/MasterFields entry at runtime, but the
> related columns have different names in the two tables.  I am unable
> to locate an example that does not assume that the names of the joined
> columns are identical.
> 
> Can somebody tell me how to join columns with different names?
> 
> From helpfile:
> 
> Orders->MasterFields = "CustNo";
> 
> if the master column was named "Customer", and the detail column was
> named "Person", what would that instruction have to look like?
> 
> --
> Spam Me and Get Sued <harkness@suespammers.org>
> see www.suespammers.org for details & free spam-nuking email account

-- 
Jeff Overcash (TeamB)   | Talk about failure
(Please do not email    | To fall is not to fail
 me directly unless     | Failure isn't about falling down
 asked.  Thank You)     | Failure is staying down (Marillion)
Technical Details
Message-ID: <3A77790B.7242F92D@onramp.net>
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!nntp-relay.ihug.net!ihug.co.nz!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!bornews.borland.com!dnews!63.178.173.198
References: <g0fe7t8uljqr2f36ikqrsmc3vo6g16onj4@4ax.com>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fcd2b,ecc0c723951c66fb
X-Google-Attributes: gidfcd2b,public
X-Google-ArrivalTime: 2001-01-30 18:35:54 PST
Message-ID: <3A77790B.7242F92D@onramp.net>
Date: Tue, 30 Jan 2001 21:31:39 -0500
From: "Jeff Overcash (TeamB)" <overcash@onramp.net>
Organization: TeamB
X-Mailer: Mozilla 4.75 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: borland.public.cppbuilder.database.multi-tier
Subject: Re: Syntax for master/detail if column names differ
References: <g0fe7t8uljqr2f36ikqrsmc3vo6g16onj4@4ax.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 63.178.173.198
X-Trace: 30 Jan 2001 18:31:54 -0800, 63.178.173.198
Lines: 28
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!nntp-relay.ihug.net!ihug.co.nz!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!bornews.borland.com!dnews!63.178.173.198