Progress 4GL Query help

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Chris Clunn
Sent: Monday, February 26, 2007 10:16 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Progress 4GL Query help


Good Morning,
I'm new to the 4GL Query language in BAQ and there are a couple things I
haven't been able to find in the documentation. Currently, I'm looking
to filter records using non-blank field as the criteria. I'm looking
for something like "is not null" and <> "" (i.e. blank/empty). Also, I
would like to concatenate fields (e.g. Address=Address1 & " " &
Address2). Is there a good tutorial on 4GL syntax?

Thanks,
Chris Clunn
This is an e-mail from Saab Barracuda LLC. It is for the intended
recipient only and may contain confidential and privileged information.
No one else may read, print, store, copy, forward or act in reliance on
it or its attachments. If you are not the intended recipient, please
return this message to the sender and delete the message and any
attachments from your computer. Your cooperation is appreciated.

###########################################

This message has been scanned by F-Secure Anti-Virus for Microsoft
Exchange. For more information, connect to http://www.f-secure.com/

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




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
Good Morning,
I'm new to the 4GL Query language in BAQ and there are a couple things I
haven't been able to find in the documentation. Currently, I'm looking
to filter records using non-blank field as the criteria. I'm looking
for something like "is not null" and <> "" (i.e. blank/empty). Also, I
would like to concatenate fields (e.g. Address=Address1 & " " &
Address2). Is there a good tutorial on 4GL syntax?

Thanks,
Chris Clunn
This is an e-mail from Saab Barracuda LLC. It is for the intended recipient only and may contain confidential and privileged information. No one else may read, print, store, copy, forward or act in reliance on it or its attachments. If you are not the intended recipient, please return this message to the sender and delete the message and any attachments from your computer. Your cooperation is appreciated.

###########################################

This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange.
For more information, connect to http://www.f-secure.com/

[Non-text portions of this message have been removed]
Progress uses the 'plus' sign to concacatenate, ' + ' instead of ' & '.
Having done much yet with filters, etc.
I did buy a book:
OpenEdge 10 Development: Progress 4GL Handbook
- author John Sadd
Available thru Amazon, but we don't have the Progress Pro-Vision package.

The book has come in handy as a reference, I'm mostly developing Configured Parts thru Vantage 6.10 at this time.

Bill
Chris Clunn <chris.clunn@...> wrote:
Good Morning,
I'm new to the 4GL Query language in BAQ and there are a couple things I
haven't been able to find in the documentation. Currently, I'm looking
to filter records using non-blank field as the criteria. I'm looking
for something like "is not null" and <> "" (i.e. blank/empty). Also, I
would like to concatenate fields (e.g. Address=Address1 & " " &
Address2). Is there a good tutorial on 4GL syntax?

Thanks,
Chris Clunn
This is an e-mail from Saab Barracuda LLC. It is for the intended recipient only and may contain confidential and privileged information. No one else may read, print, store, copy, forward or act in reliance on it or its attachments. If you are not the intended recipient, please return this message to the sender and delete the message and any attachments from your computer. Your cooperation is appreciated.

###########################################

This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange.
For more information, connect to http://www.f-secure.com/

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






---------------------------------
8:00? 8:25? 8:40? Find a flick in no time
with theYahoo! Search movie showtime shortcut.

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