OraFAQ Forum: Forms » USE of JOIN In Forms 6i

Home » Developer & Programmer » Forms » USE of JOIN In Forms 6i (Forms 6i, Windows)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

USE of JOIN In Forms 6i [message #557741]

Fri, 15 June 2012 06:39

mmohsinaziz
Messages: 110
Registered: May 2012

Senior 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.

Report message to a moderator

Re: USE of JOIN In Forms 6i [message #557743 is a reply to message #557741]

Fri, 15 June 2012 06:51

Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I believe that Forms 6i doesn't understand ANSI joins. Rewrite the query.

Report message to a moderator

Re: USE of JOIN In Forms 6i [message #557744 is a reply to message #557741]

Fri, 15 June 2012 06:53

cookiemonster
Messages: 13925
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.

Report message to a moderator

Previous Topic:	Excel generation
Next Topic:	WRITE THE VALUES ON 2 LINES DIFFERENTS

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 05 21:37:47 CDT 2024