Yes, Thanks Dale
--- In vantage@yahoogroups.com, "Dale Schuerman" <dale.schuerman@...> wrote:
>
> Keith,
>
>
>
> IF xxx is one part then you would:
>
>
>
> Find first part where part.partnum = "xxx" no-lock no-error.
>
> If available part then
>
> Display part.partnum part.ExpenseChart.
>
>
>
> IF multiple parts begin "xxx" then you would:
>
> For each part where part.partnum = begins "xxx" no-lock.
>
> Display part.partnum part.ExpenseChart.
>
> End.
>
>
>
> Hope this helps
>
>
>
>
>
> Dale E. Schuerman
>
> Senior Consultant
>
> Epicor Certified Consulting Partner
>
>
>
> RAM Software Systems, Inc.
>
> 972-669-0763 x233 (voice)
>
> 972-669-9603 (fax)
>
> mailto:dale.schuerman@...
> <BLOCKED::blocked::mailto:dale.schuerman@...> (email)
>
> http://www.ramsys.com <BLOCKED::blocked::http://www.ramsys.com/>
> (website)
>
>
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Keith
> Sent: Friday, October 23, 2009 10:06 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Get BAQ into Progress 4GL Query
>
>
>
>
>
> I need to create a progress query for a BPM - 1st timer here. Can I
> convert/extract a BAQ into 4GL? IF not, is there a referance or a tool
> for writing progress queries? I have some experience with SQL, but sytax
> is different.
>
> What I need is this (roughly):
>
> for each Part no-lock
> return Part.PartNNum, Part.ExpenseChart
> Where Part.PartNNum = xxx
>
>
>
>
> ########################################################################
> Attention:
> This email message is privileged and confidential. If you are not the
> intended recipient please delete the message and notify the sender.
> Any views or opinions presented are solely those of the author.
>
> This email message has been scanned for Viruses and Content and cleared
> by MailMarshal SMTP
>
> For more information go to http://www.ramsys.com
> ########################################################################
>
>
> [Non-text portions of this message have been removed]
>