Article View: borland.public.cppbuilder.database.multi-tier
Article #859Re: Syntax for master/detail if column names differ
From: Jeff Overcash (TeamB)
Date: Wed, 31 Jan 2001 02:31
Date: Wed, 31 Jan 2001 02:31
28 lines
2051 bytes
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.198References:
<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