NewEra - SuperView joins
Posted in 1995
I seem to be having a problem with my superview join. I created a superview with ViewPoint Pro. It is a simple 0 to 1 join and it looks fine when viewing the relationships. The data also looks okay when viewing what is actually stored in the database tables. However, when I paste the columns with NewEra's window painter, my joined fields become reversed: Actual relationship - table1.fldx = table2.fldy Window painter insists on - table1.fldy = table2.fldx Window Painter also refuses to write an outer join for the relationship. I can manually modify the 4gl generated and my program works okay but that means I can no longer use Window Painter to move fields around or change other display characteristics. It also means that I cannot trust superviews to maintain the much more complex relationships I will be encountering in this project. Has anyone run into this problem? Am I missing something simple here? ----------- There are more things in heaven and earth, Horatio, ---------------- Scott Holmes <sholmes@netcom.com> Informix 4GL Applications ---------------- Than are dreamt of in your philosophy. ------------------------