Issue with using relations between two external tables

Posted by mihai_neagoe on 25-Oct-2013 03:07

Hi,

I am using two external tables Article and ArticleAttribute and made a relation between them. On the Article page I added a grid component for ArticleAttribute and on ArticleAttribute page a lookup to Article. I have a problem saving the Article when there are ArticleAttributes linked and also when saving an ArticleAttribute whith Article set. An error is raised:

ERROR: Error in query SELECT NAME, PRODUCTID, PRODUCTSTATUS, PRODUCTTYPE FROM ARTICLE WHERE null=?: RB_179: Error preparing statement for query SELECT NAME, PRODUCTID, PRODUCTSTATUS, PRODUCTTYPE FROM ARTICLE WHERE null=? [DataDirect][OpenEdge JDBC Driver][OpenEdge] Syntax error in SQL statement at or about "null=?" (10713)

I suppose this error is raised because the foreign key is not identified. Did anyone had this issue?

Thanks

All Replies

Posted by sidury on 28-Oct-2013 11:06

Hello,

CR # PSC00278182 filed for this issue. I will update you on the ETA

Thank you.

This thread is closed