3 Replies Latest reply on Sep 22, 2003 10:50 AM by 3542

    ORA-04117: Column aliases prevent StartEdit( )

    403468
      Okay, this is a weird one. I've been using oo4o for a year and never noticed this: you cannot call StartEdit() on an ODynaset that was created from a SELECT statement that contains column aliases. If you try, you'll get ORA-"04117: Not an updatable set".

      That is, this statement can be updated via StartEdit():

      SELECT name FROM Customer WHERE custnum = 20

      ... but this cannot:

      SELECT name myname FROM Customer WHERE custnum = 20

      Anybody know why? Just curious.