I am trying to update the geometry of point data through a live-link to Oracle without altering the other attributes of the records. The workflow that I am currently using is:
1) Capture x,y 2) Update <tablename> set Obj = Createpoint(x,y) 3) Commit Table <tablename> Interactive Unfortunately, if other attributes for the object have been altered this approach updates all of the attributes, not just the geometry. To only update the geometry I plan to send a SQL statement direct to the database using the Server_Execute command. However to do this I need to get the unique ref for the connection handle. Any ideas? Colin Thornton. Informed Solutions Ltd, The Old Bank, Old Market Place, Altrincham, Cheshire, WA14 4PA UK Tel: +44(0) 161 942 2000 Fax: +44(0)161 942 2015 This e-mail and any attachments are sent in confidence, subject to applicable legal privilege and upon the basis that the recipient will conduct applicable virus checks. If you receive this e-mail in error please telephone us upon receipt on the above number. You are strictly prohibited from using, copying or disseminating it or any information contained in it save to the intended recipient. You are also advised that the opinions contained within this e-mail are those of the author and may not be those of Informed Solutions, its associates or Clients. Internet communications are not secure and Informed Solutions Ltd is not responsible for their abuse by third parties, nor for any alteration or corruption in transmission, nor for any damage or loss caused by any virus or other defect. --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
