Re: Can I cocatenate 2 A correlatives ? D3/NT

#1

On Mar 6, 6:37 pm, "Corporate apparatchik" <johnmarsh... (AT) xtra (DOT) co.nz>
wrote:

Quote:

Thanks Alberto and Geoff for the responses.

Unfortunately the method you both outline doesn't work for me. The
synonym with the AN(MFGR.NAME):" ":N(MFGR.PART.NBR) statement in
attribute 8 returns two lots of the A;3:'*':4 data from the first part
of each of the MFGR.NAME and MFGR.PART.NBR synonyms. It's like the
translate to the POD file that occurs in each individual synonym is
being lost somewhere in the process of combining them together in a
new A correlative.

If I try the 2 individual A correlatives on their own they work fine,
it's just when I try to concatenate them together in a new A
correlative that they stop working.

regards

John

John,

In the MFGR.NAME & MFGR.PART.NBR synonyms, set the correlatives as
A;(3:'*':4)(TPOD;X;;37)
A;(3:'*':4)(TPOD;X;;15)
You can embed most correlatives within an A correlative (I think)

Geoff

#2

Geoff

thanks for your advice, using the brackets instead of the value mark
in the two A correlatives made things work when I concatenated them
together. Another report for the users can now be finished off...

regards

John

On Mar 7, 4:13 pm, "Geoff Goodchild" <goodchil... (AT) yahoo (DOT) com.au> wrote:

Quote:

On Mar 6, 6:37 pm, "Corporate apparatchik" <johnmarsh... (AT) xtra (DOT) co.nz
wrote:

Thanks Alberto and Geoff for the responses.

Unfortunately the method you both outline doesn't work for me. The
synonym with the AN(MFGR.NAME):" ":N(MFGR.PART.NBR) statement in
attribute 8 returns two lots of the A;3:'*':4 data from the first part
of each of the MFGR.NAME and MFGR.PART.NBR synonyms. It's like the
translate to the POD file that occurs in each individual synonym is
being lost somewhere in the process of combining them together in a
new A correlative.

If I try the 2 individual A correlatives on their own they work fine,
it's just when I try to concatenate them together in a new A
correlative that they stop working.

regards

John

John,

In the MFGR.NAME & MFGR.PART.NBR synonyms, set the correlatives as
A;(3:'*':4)(TPOD;X;;37)
A;(3:'*':4)(TPOD;X;;15)
You can embed most correlatives within an A correlative (I think)

Geoff- Hide quoted text -

- Show quoted text -

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Can I cocatenate 2 A correlatives ? D3/NT

comp.databases.pick comp.databases.pick

Re: Can I cocatenate 2 A correlatives ? D3/NT - 03-06-2007 , 09:13 PM

Re: Can I cocatenate 2 A correlatives ? D3/NT - 03-07-2007 , 02:27 AM