Hi Michel, It's probably MapInfo that bars you from updating a view, since a view by definition has no unique usually auto-incremented integer ID column (and Pro doesn't bother to/has no way to determine if it has).
However, you can "cheat" it - if you KNOW you have such a column in your view, and it IS indeed unique (your head on the platter!) - by renaming it to MI_PRINX. As a rule of thumb, the unique field in your view needs to be on the inside of all outer joins. This is a necessary work-around in both Pro and MapX for spatialized views. Best regards / Med venlig hilsen Lars V. Nielsen -------------------------------------------------------- Hvenegaard & Meklenborg Rugaardsvej 55, DK-5000 Odense C Denmark http://www.hvm.dk ----- Original Message ----- From: "michel Van Asten" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, October 10, 2003 10:43 AM Subject: MI-L UPDATING DATA WITH ODBC LINK > Hi, > > We need to display XY data located in an oracle database. we access data via > ODBC and an ORACLE view ( JOIN of two table) > Data are displayed correctly but we cant update the location of points. Is > it a limitation of Mapinfo, ODBC or ORACLE ? > > If somebody has any suggestion ? > > Regards, > > Michel Van Asten > > > --------------------------------------------------------------------- > List hosting provided by Directions Magazine | www.directionsmag.com | > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > Message number: 8699 > --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 8703
