Concatenate/Combine for a Calculated Field

Yahoo Archive
#1
Trying it with the Quicksearch, it won't allow you to use that as a return column. It (The Return Column) goes blank when you go back into the quicksearch and it does not allow you to Test Quick Search either.


----- Original Message ----
From: Bill Baraski <bilbaraski@...>
To: vantage@yahoogroups.com
Sent: Thursday, December 6, 2007 4:45:28 PM
Subject: Re: [Vantage] Concatenate/Combine for a Calculated Field

worked perfectly, now I can't figure out how to bring back the selected column/row since it's not part of the data adapter. Says "invalid key"

----- Original Message ----
From: Bernie Walker <bwalker@adcocircuit s.com>
To: "vantage@yahoogroups .com" <vantage@yahoogroups .com>
Sent: Wednesday, December 5, 2007 11:18:46 AM
Subject: RE: [Vantage] Concatenate/ Combine for a Calculated Field

I'm trying to make 2 Data Fields into 1 for a BAQ. The reason I'm doing this is so I can bring back 2+ fields from a QuickSearch since you can only return 1. The fields I'm trying to combine are (QuoteDtl.QuoteNum & "-" & QuoteDtl.QuoteLine) . The way I thought you would do it is via a Calculated Field. I tried a couple of ways without any luck. I can add the two together without a problem though. Anyone with a Progress background help?

These are a couple of the ways I tried. These just bring back QuoteNum
+ Quoteline
QuoteDtl.Quotenum + ' - ' + QuoteDtl.QuoteLine QuoteDtl.Quotenum + " - " + QuoteDtl.QuoteLine

Thanks,

Chris

How about

STRING(QuoteDtl. Quotenum) + " - " + STRING(QuoteDtl. QuoteLine)

??

____________ _________ _________ _________ _________ _________ _
Looking for last minute shopping deals?
Find them fast with Yahoo! Search. http://tools. search.yahoo. com/newsearch/ category. php?category= shopping

[Non-text portions of this message have been removed]





____________________________________________________________________________________
Never miss a thing. Make Yahoo your home page.
http://www.yahoo.com/r/hs

[Non-text portions of this message have been removed]
#2
I'm trying to make 2 Data Fields into 1 for a BAQ. The reason I'm doing
this is so I can bring back 2+ fields from a QuickSearch since you can
only return 1. The fields I'm trying to combine are (QuoteDtl.QuoteNum
& "-" & QuoteDtl.QuoteLine). The way I thought you would do it is via a
Calculated Field. I tried a couple of ways without any luck. I can add
the two together without a problem though. Anyone with a Progress
background help?

These are a couple of the ways I tried. These just bring back QuoteNum
+ Quoteline
QuoteDtl.Quotenum + ' - ' + QuoteDtl.QuoteLine
QuoteDtl.Quotenum + " - " + QuoteDtl.QuoteLine

Thanks,

Chris
#3
I'm trying to make 2 Data Fields into 1 for a BAQ. The reason I'm doing this is so I can bring back 2+ fields from a QuickSearch since you can only return 1. The fields I'm trying to combine are (QuoteDtl.QuoteNum & "-" & QuoteDtl.QuoteLine). The way I thought you would do it is via a Calculated Field. I tried a couple of ways without any luck. I can add the two together without a problem though. Anyone with a Progress background help?

These are a couple of the ways I tried. These just bring back QuoteNum
+ Quoteline
QuoteDtl.Quotenum + ' - ' + QuoteDtl.QuoteLine QuoteDtl.Quotenum + " - " + QuoteDtl.QuoteLine

Thanks,

Chris

How about

STRING(QuoteDtl.Quotenum) + " - " + STRING(QuoteDtl.QuoteLine)


??
#4
If that doesn't work, why not do an appropriate QuoteNum BAQ search and then, in those results, a secondary filter/search for the QuoteLine(s) if interest?



Bernie Walker <bwalker@...> wrote:


I'm trying to make 2 Data Fields into 1 for a BAQ. The reason I'm doing this is so I can bring back 2+ fields from a QuickSearch since you can only return 1. The fields I'm trying to combine are (QuoteDtl.QuoteNum & "-" & QuoteDtl.QuoteLine). The way I thought you would do it is via a Calculated Field. I tried a couple of ways without any luck. I can add the two together without a problem though. Anyone with a Progress background help?

These are a couple of the ways I tried. These just bring back QuoteNum
+ Quoteline
QuoteDtl.Quotenum + ' - ' + QuoteDtl.QuoteLine QuoteDtl.Quotenum + " - " + QuoteDtl.QuoteLine

Thanks,

Chris

How about

STRING(QuoteDtl.Quotenum) + " - " + STRING(QuoteDtl.QuoteLine)

??





---------------------------------
Never miss a thing. Make Yahoo your homepage.

[Non-text portions of this message have been removed]
#5
The BAQ Search didn't allow me to return the selected QuoteLine column

dim whereclause as string = "CustNum = " & CustNum
Dim QuoteSearch As DataSet = SearchFunctions.listLookup(otrans, "QuoteDtlSearchAdapter", recSelected, True, whereClause)
if (RecSelected) Then
QuoteDtl.dataView(QuoteDTL.ROW)("QuoteNum") = QuoteSearch.Tables(0).Rows(0)("QuoteNum")
QuoteDtl.dataView(QuoteDTL.Row)("QuoteLine")= QuoteSearch.Tables(0).Rows(0)("QuoteLine")
End if


Every time it brings back the QuoteNum but not the QuoteLine. It always returns 1 for the Quoteline reguardless of what line is selected.
Now the question I have is, it works fine with the base, QuoteDTLSearchAdapter. Should I be using that as the adapter in the listlookup, or should I be using something else in that spot? The BAQ Search I am using is named, "WCC-QLSearch". It seems like I should be able to call a BAQ directly but I don't have a clue what the syntax for it would be.

Thanks,

Chris

----- Original Message ----
From: Robert Brown <robertb_versa@...>
To: vantage@yahoogroups.com
Sent: Wednesday, December 5, 2007 11:34:42 AM
Subject: RE: [Vantage] Concatenate/Combine for a Calculated Field

If that doesn't work, why not do an appropriate QuoteNum BAQ search and then, in those results, a secondary filter/search for the QuoteLine(s) if interest?



Bernie Walker <bwalker@adcocircuit s.com> wrote:


I'm trying to make 2 Data Fields into 1 for a BAQ. The reason I'm doing this is so I can bring back 2+ fields from a QuickSearch since you can only return 1. The fields I'm trying to combine are (QuoteDtl.QuoteNum & "-" & QuoteDtl.QuoteLine) . The way I thought you would do it is via a Calculated Field. I tried a couple of ways without any luck. I can add the two together without a problem though. Anyone with a Progress background help?

These are a couple of the ways I tried. These just bring back QuoteNum
+ Quoteline
QuoteDtl.Quotenum + ' - ' + QuoteDtl.QuoteLine QuoteDtl.Quotenum + " - " + QuoteDtl.QuoteLine

Thanks,

Chris

How about

STRING(QuoteDtl. Quotenum) + " - " + STRING(QuoteDtl. QuoteLine)

??

------------ --------- --------- ---
Never miss a thing. Make Yahoo your homepage.

[Non-text portions of this message have been removed]





____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ


[Non-text portions of this message have been removed]
#6
worked perfectly, now I can't figure out how to bring back the selected column/row since it's not part of the data adapter. Says "invalid key"


----- Original Message ----
From: Bernie Walker <bwalker@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Wednesday, December 5, 2007 11:18:46 AM
Subject: RE: [Vantage] Concatenate/Combine for a Calculated Field



I'm trying to make 2 Data Fields into 1 for a BAQ. The reason I'm doing this is so I can bring back 2+ fields from a QuickSearch since you can only return 1. The fields I'm trying to combine are (QuoteDtl.QuoteNum & "-" & QuoteDtl.QuoteLine) . The way I thought you would do it is via a Calculated Field. I tried a couple of ways without any luck. I can add the two together without a problem though. Anyone with a Progress background help?

These are a couple of the ways I tried. These just bring back QuoteNum
+ Quoteline
QuoteDtl.Quotenum + ' - ' + QuoteDtl.QuoteLine QuoteDtl.Quotenum + " - " + QuoteDtl.QuoteLine

Thanks,

Chris

How about

STRING(QuoteDtl. Quotenum) + " - " + STRING(QuoteDtl. QuoteLine)

??




____________________________________________________________________________________
Looking for last minute shopping deals?
Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping

[Non-text portions of this message have been removed]