Article View: borland.public.cppbuilder.database.multi-tier
Article #861Re: Syntax for master/detail if column names differ
From: Howard Lee Harkness
Date: Wed, 31 Jan 2001 13:41
Date: Wed, 31 Jan 2001 13:41
28 lines
2153 bytes
2153 bytes
"Jeff Overcash (TeamB)" <overcash@onramp.net> wrote: >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. I am trying to use a TbkmMemTable (in-memory table), so the query option is not an option here. I would think that there would be a way to use MasterSource/MasterFields with different names at runtime, since you can do it with the Designer on TTables. >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
Technical Details
Message-ID:
<j85g7to3j0kie3bs624h1cca4maukt19ao@4ax.com>Path:
arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!sn-xit-01!supernews.com!newshub2.rdc1.sfba.home.com!news.home.com!newsfeed.direct.ca!look.ca!feed-out.newsfeeds.com!newsfeeds.com!feed.newsfeeds.com!newsfeeds.com!news.bnb-lp.com!bornews.borland.com!not-for-mailReferences:
<g0fe7t8uljqr2f36ikqrsmc3vo6g16onj4@4ax.com> <3A77790B.7242F92D@onramp.net>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-31 05:42:00 PST From: Howard Lee Harkness <harkness@suespammers.org> Newsgroups: borland.public.cppbuilder.database.multi-tier Subject: Re: Syntax for master/detail if column names differ Date: Wed, 31 Jan 2001 07:41:23 -0600 Organization: YGBSM! Lines: 28 Message-ID: <j85g7to3j0kie3bs624h1cca4maukt19ao@4ax.com> References: <g0fe7t8uljqr2f36ikqrsmc3vo6g16onj4@4ax.com> <3A77790B.7242F92D@onramp.net> NNTP-Posting-Host: pppt17-176.ght.iadfw.net Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Newsreader: Forte Agent 1.8/32.548 Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!sn-xit-01!supernews.com!newshub2.rdc1.sfba.home.com!news.home.com!newsfeed.direct.ca!look.ca!feed-out.newsfeeds.com!newsfeeds.com!feed.newsfeeds.com!newsfeeds.com!news.bnb-lp.com!bornews.borland.com!not-for-mail