Re: NewEra - SuperView joins
Posted in 1995
Scott, The problem with SuperView columns being swapped when they're imported into NewEra is Informix bug #38812. I believe it's fixed in upcoming version. The work around is to manually edit the SuperTable's join part (as you already figured out). Sorry, but I don't know anything about the outer problem. I suspect it's also a bug though. --Craig (craig@chemistry.utah.edu) > 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 > ...