Karl-Heinz Mali wrote: > After reading carefully the documentation, I' am not able to > find information > about updateable odbc joins. > I want to update the following statement "select * from > STAMMDATEN left outer > join PERSONAL on STAMMDATEN.PERSONALNR = 0" with SQLSetPos(hstmt, > 1, SQL_UPDATE, SQL_LOCK_NO_CHANGE) and get the error "7008: > update of this > table not allowed". > Are joins updateable with MaxDB ODBC?
No, cursor based on joins are not updateable in MaxDB. The only way to update joins directly is via updateable join views. Have a look at http://www.sapdb.org/7.4/htmhelp/c7/12ffe306ab11d3a97d00a0c9449261/frameset.htm Kind regards Holger SAP Labs Berlin -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
