Home » Developer & Programmer » Forms » USE of JOIN In Forms 6i (Forms 6i, Windows)
USE of JOIN In Forms 6i [message #557741] Fri, 15 June 2012 06:39 Go to next message
mmohsinaziz
Messages: 85
Registered: May 2012
Member
I am using the following query in Form 6i

SELECT VDATE, RATE INTO :LP_DATE , :LP_RATE
FROM
(SELECT S.ITCODE, S.VDATE, S.RATE,S.SUPPLIER
FROM
(SELECT ITCODE,MAX(VDATE)VDATE
FROM STORE_ITEM_RATE
GROUP BY ITCODE) I
JOIN STORE_ITEM_RATE S ON I.ITCODE = S.ITCODE
AND I.VDATE = S.VDATE
AND S.ITCODE='033900005'
) LP;

When I complie the above query It gives me the followng error while the same query is working fine in PL/SQL and Reports 6i

Error 103 at Line 6, Coumn 15
Encountered the symbol "JOIN" when expecting the one of the followings:

], with group having intersect, minus start union where
connect

Please help me to resolve this issue.
Re: USE of JOIN In Forms 6i [message #557743 is a reply to message #557741] Fri, 15 June 2012 06:51 Go to previous messageGo to next message
Littlefoot
Messages: 19477
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I believe that Forms 6i doesn't understand ANSI joins. Rewrite the query.
Re: USE of JOIN In Forms 6i [message #557744 is a reply to message #557741] Fri, 15 June 2012 06:53 Go to previous message
cookiemonster
Messages: 10909
Registered: September 2008
Location: Rainy Manchester
Senior Member
Please read and follow How to use [code] tags and make your code easier to read?

Forms 6i doesn't recognize the ansi sql syntax.
Either rewrite the sql to not use the join keyword or create a view based on the select and use that instead.
Previous Topic: Excel generation
Next Topic: WRITE THE VALUES ON 2 LINES DIFFERENTS
Goto Forum:
  


Current Time: Sat Aug 23 12:22:46 CDT 2014

Total time taken to generate the page: 0.07947 seconds