Subject | RE: [firebird-support] How to get detail strings all concatenated |
---|---|
Author | Mercea Paul |
Post date | 2008-10-01T08:17:39Z |
I forgot to put LIST function in sql to look like this:
Select m.Mastername||(select LIST(d.DetailName,;) from DetailTable d where
d.MasterId=m.MasterId) from MasterTable m
Regards,
Paul
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of HugoHiasl
Sent: Wednesday, October 01, 2008 09:47
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] How to get detail strings all concatenated
I think he is talking about multiple detail strings per master record and he
wants to concatenate these.
You need to create a stored function which concatenate all strings and
returns it as one string. This function needs then to be called with the
parentkey as parameter and can be included in your initial call like "select
mastername, yourconcfunction(masterid) from MasterTable"
_____
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Mercea Paul
Sent: Mittwoch, 1. Oktober 2008 07:27
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] How to get detail strings all concatenated
From: firebird-support@ <mailto:firebird-support%40yahoogroups.com>
yahoogroups.com
[mailto:firebird-support@ <mailto:firebird-support%40yahoogroups.com>
yahoogroups.com] On Behalf Of Marcelo
Sent: Tuesday, September 30, 2008 22:55
To: firebird-support@ <mailto:firebird-support%40yahoogroups.com>
yahoogroups.com
Subject: [firebird-support] How to get detail strings all concatenated
Hi all!
I want to get a master record along with a concatenation of detail
strings in a single record.
How do I do it?
Greeting, Marcelo.
_
[PM] Try
Select m.Mastername||(select d.DetailName from DetailTable d where
d.MasterId=m.MasterId) from MasterTable m
Regards,
Paul
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
Select m.Mastername||(select LIST(d.DetailName,;) from DetailTable d where
d.MasterId=m.MasterId) from MasterTable m
Regards,
Paul
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of HugoHiasl
Sent: Wednesday, October 01, 2008 09:47
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] How to get detail strings all concatenated
I think he is talking about multiple detail strings per master record and he
wants to concatenate these.
You need to create a stored function which concatenate all strings and
returns it as one string. This function needs then to be called with the
parentkey as parameter and can be included in your initial call like "select
mastername, yourconcfunction(masterid) from MasterTable"
_____
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Mercea Paul
Sent: Mittwoch, 1. Oktober 2008 07:27
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] How to get detail strings all concatenated
From: firebird-support@ <mailto:firebird-support%40yahoogroups.com>
yahoogroups.com
[mailto:firebird-support@ <mailto:firebird-support%40yahoogroups.com>
yahoogroups.com] On Behalf Of Marcelo
Sent: Tuesday, September 30, 2008 22:55
To: firebird-support@ <mailto:firebird-support%40yahoogroups.com>
yahoogroups.com
Subject: [firebird-support] How to get detail strings all concatenated
Hi all!
I want to get a master record along with a concatenation of detail
strings in a single record.
How do I do it?
Greeting, Marcelo.
_
[PM] Try
Select m.Mastername||(select d.DetailName from DetailTable d where
d.MasterId=m.MasterId) from MasterTable m
Regards,
Paul
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]