Thread View: borland.public.cppbuilder.database.multi-tier
3 messages
3 total messages
Started by Howard Lee Harkness
Tue, 30 Jan 2001 22:16
Syntax for master/detail if column names differ
Author: Howard Lee Harkness
Date: Tue, 30 Jan 2001 22:16
Date: Tue, 30 Jan 2001 22:16
17 lines
1454 bytes
1454 bytes
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
Re: Syntax for master/detail if column names differ
Author: 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)
Re: Syntax for master/detail if column names differ
Author: 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
Thread Navigation
This is a paginated view of messages in the thread with full content displayed inline.
Messages are displayed in chronological order, with the original post highlighted in green.
Use pagination controls to navigate through all messages in large threads.
Back to All Threads