Calvin,
Try this query...
for each EmpBasic outer-join Where EmpBasic.Company = cur-comp no-lock,
first LaborDtl outer-join Where LaborDtl.Company = EmpBasic.Company
and LaborDtl.ActiveTrans = yes
and LaborDtl.EmployeeNum = EmpBasic.EmpID no-lock
BY LaborDtl.EmployeeNum:
It works for me.
It worked with the join in either direction, but for an outer join, it
seemed more sensible to be looking from he EmpBasic to the LaborDtl as every
LaborDtl should have one and only one employee linked.
I think it was the rest of the query that was giving problems not the join.
Good luck,
Aaron Hoyt
-----Original Message-----
From:
vantage@yahoogroups.com [mailto:
vantage@yahoogroups.com]On Behalf
Of Calvin Dekker
Sent: Monday, April 18, 2005 11:51 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Help
Pat -
Try the syntax you sent and then add fields to the query to be displayed.
All I get is the following errors:
Unable to understand after "open" (247)
Invalid statement (254)
Could not understand line 24. (198)
Missing FOR, FIND, or CREATE for a table with Company in current block
(232)
Could not understand line 30 (196)
The syntax works for me in a stand alone program but not in the BAQ.
Am I the only one getting errors when I try to run the BAQ?
Calvin
-----Original Message-----
From:
vantage@yahoogroups.com [mailto:
vantage@yahoogroups.com]On Behalf
Of
pjw@...
Sent: Monday, April 18, 2005 9:24 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Help
Calvin,
Query sample using Left Outer Join:
for each LaborDtl no-lock where LaborDtl.Company = CUR-COMP
and LaborDtl.PayrollDate = Today,
first EmpBasic outer-join no-lock where EmpBasic.Company = LaborDtl.Company
and EmpBasic.EmpId = LaborDtl.EmployeeNum,
Patrick Winter
sSc Specialty Screw Corporation
Vantage 6.10.514, Progress 9.1D08, Windows 2003 Server, Crystal 8.5.3.975
-----Original Message-----
From:
vantage@yahoogroups.com [mailto:
vantage@yahoogroups.com] On Behalf Of
Calvin Dekker
Sent: Monday, April 18, 2005 8:51 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Help
Pat -
I can't seem to find the syntax for a LEFT-OUTER join in BAQ.
Once I type in the correct syntax for the link, when I try to choose fields
it errors telling me no such field exists even though I have selected it
from the field list it gives me.
All my attempts have yielded errors. If someone has found a way to perform
LEFT and RIGHT OUTER joins in the BAQ, please share with the group.
Thanks,
Calvin
-----Original Message-----
From:
vantage@yahoogroups.com [mailto:
vantage@yahoogroups.com]On Behalf Of
pjw@...
Sent: Monday, April 18, 2005 8:16 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Help
You can't in BAQ?
What's the hold up? Can't you type in the link outside the wizard?
Patrick Winter
-----Original Message-----
From:
vantage@yahoogroups.com [mailto:
vantage@yahoogroups.com] On Behalf Of
Calvin Dekker
Sent: Friday, April 15, 2005 11:12 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Help
You can't make the link in the BAQ but you can do this in Report Builder or
Crystal.
There is no link since JobMtl.MtlSeq = PORel.JobSeq
In Crystal or Report Builder do a LEFT OUTER JOIN and link as follows:
JobMtl.Company -> PORel.Company
JobMtl.JobNum -> PORel.JobNum
JobMtl.AssemblySeq -> PORel.AssemblySeq
JobMtl.MtlSeq -> PORel.JobSeq
HTH,
Calvin
-----Original Message-----
From:
vantage@yahoogroups.com [mailto:
vantage@yahoogroups.com]On Behalf Of
PLAMAN DICK
Sent: Friday, April 15, 2005 10:42 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Help
Paul,
you will have to add another table or two. I was able to link POHed to
PORel to JobHed to JobMtl in the BAQ.
Play around with this linkage, maybe you can eliminate one of the tables.
good luck.
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
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
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
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
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
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