🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: Syntax for master/detail if column names differ

#861
From: Howard Lee Harkness
Date: Wed, 31 Jan 2001 13:41
28 lines
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-mail
References: <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