Wanted source for BAQ syntax

Yahoo Archive
1
As Kevin said, check out the Progress Reference Manual. That's where I learned most of the Progress functions I used in BAQ calculated fields. You might also want to checkout the 4GL handbook as well.

David


--- In vantage@yahoogroups.com, "randyweb" <weber.randy@...> wrote:
>
> Does anybody know of a good source for BAQ syntax for calculated fields? I want to know the functions such as REPLACE, SUBSTRING, etc.
>
> And specifically, I need help with the REPLACE function. Some Part Description fields have carriage returns. Can I get rid of them with something like REPLACE(Part.PartDescription, Chr(13) & Chr(10),"")
>
> I know this from VB - will it work in a BAQ?
>
> Thanks in advance.
>
> Randy Weber
>
2
Does anybody know of a good source for BAQ syntax for calculated fields? I want to know the functions such as REPLACE, SUBSTRING, etc.

And specifically, I need help with the REPLACE function. Some Part Description fields have carriage returns. Can I get rid of them with something like REPLACE(Part.PartDescription, Chr(13) & Chr(10),"")

I know this from VB - will it work in a BAQ?

Thanks in advance.

Randy Weber
3
Randy,



Check out the openedge reference manual:
http://communities.progress.com/pcom/docs/DOC-15972







From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
randyweb
Sent: Saturday, March 19, 2011 3:24 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Wanted source for BAQ syntax





Does anybody know of a good source for BAQ syntax for calculated fields? I
want to know the functions such as REPLACE, SUBSTRING, etc.

And specifically, I need help with the REPLACE function. Some Part
Description fields have carriage returns. Can I get rid of them with
something like REPLACE(Part.PartDescription, Chr(13) & Chr(10),"")

I know this from VB - will it work in a BAQ?

Thanks in advance.

Randy Weber





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