11/26/2024 3:25:15 AM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss using the SalesLogix OLE DB Provider from external applications (including usage of built-in provider procedures). View the code of conduct for posting guidelines.
|
|
|
|
Outer Join of Oracle table errors out in SalesLogix OLEDB Provider
Posted: 03 Apr 07 6:43 PM
|
Hi,
I am using the following SQL in VB Script and trying to run using SalesLogix OLEDB Provider
select p.opportunityid, p.fcs_proposalid, q.fcs_quoteid, q.quote_number, q.amount,
max(nvl(r.rollout_date,sysdate-1)) rollout_date
from fcs_proposal p, fcs_quote q, fcs_quote_item qi, fcs_rollout r
where q.fcs_proposalid = p.fcs_proposalid
and qi.fcs_quoteid(+) = q.fcs_quoteid
and r.fcs_quote_itemid(+) = qi.fcs_quote_itemid
and p.confidence_percentage > 0
and q.status in ('Completed','Partially Booked')
group by p.opportunityid, p.fcs_proposalid, q.fcs_quoteid, q.quote_number, q.amount
order by p.fcs_proposalid, q.fcs_quoteid, q.quote_number
My connect string is
strSLXConn = "Provider=SLXOLEDB.1;Data Source=sv-slxdev;Initial Catalog=CRMTEST;User Id=Admin assword=adminersist Security Info=True;Extended Properties=Port=1706;Log=On"
When I run the script, I get the following error
Error: Failed to parse SQL
Code: 8004277A
Source: SalesLogix OLE DB Provider.
Once I remove (+) signs in the query the script runs fine. But we need to have that (+) sign as part of join, otherwise no or some rows will be ignored.
Can any one tell me how to handle this situation?
Thanks,
Satheesh
|
|
|
|
Re: Outer Join of Oracle table errors out in SalesLogix OLEDB Provider
Posted: 03 Apr 07 9:56 PM
|
fiogf49gjkf0d Change the query to use explicit join syntax.
ie:
select t1.field1, t2.field2
from table1 t1
left join table2 t2
on t1.keyfield = t2.keyfield
where t1.field3 = 'Other conditions if necessary, etc'
Know what I mean? The (+) is not interpreted by the SLX provider. |
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|