Home » Developer & Programmer » Forms » Problem in join relation
Problem in join relation [message #227710] Thu, 29 March 2007 02:36 Go to next message
emadbsb
Messages: 334
Registered: May 2005
Location: egypt
Senior Member

hii all

I am joining two block by a relation
in the relation property on the block leverl

ITFXXXXXX.GBR_CODE = ITFDTXXXX.ITF_GBR_CODE AND    
ITFXXXXXX.GBR_GCO_CODE = ITFDTXXXX.ITF_GBR_GCO_CODE AND    
ITFXXXXXX.NO = ITFDTXXXX.ITF_NO AND
ITFXXXXXX.GST_CODE_FROM = ITFDTXXXX.GST_CODE AND
ITFXXXXXX.GST_CODE_TO = ITFDTXXXX.GST_CODE_TO



it gives me an error of
error while parsing join condition


although when i try this condition in sql
it doesnot result an error

Thanks for everyone helped and helping me
Re: Problem in join relation [message #227858 is a reply to message #227710] Thu, 29 March 2007 19:07 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Did you reread your post before submitting it? What does 'error of error' mean? Please post the error code and error message.

Check your datatypes. First, in the 'where' clause. Then compare the 'into' field datatypes against the 'select' field datatypes. [Okay, the second part is not applicable in this case. Sorry.]

David

[Updated on: Thu, 29 March 2007 19:07]

Report message to a moderator

Previous Topic: Where can I find D2K tutorial? (renamed: dear sir)
Next Topic: how ca i save?????
Goto Forum:
  


Current Time: Sun Dec 04 02:15:14 CST 2016

Total time taken to generate the page: 0.09416 seconds