Infrastructure Map Server Developer

Infrastructure Map Server Developer

Reply
Valued Contributor
ebnesom
Posts: 51
Registered: ‎10-02-2003
Message 1 of 2 (92 Views)

oracle preserve single quotes

92 Views, 1 Replies
05-07-2008 09:32 PM
I have several report queries that pull data from either shape file or an odbc connection. I am trying to switch one of these to an oracle odbc. however the syntax I have used for the msaccess connection doesn't isn't correct for the oracle. Can anyone help?
Thanks
SELECT * FROM GIS.SDO_SWCSCULVERTIN WHERE OBJECTID values (#PreserveSingleQuotes(OBJ_KEYS)#) ORDER BY OBJECTID
*Jason Birch
Message 2 of 2 (92 Views)

Re: oracle preserve single quotes

05-08-2008 05:45 PM in reply to: ebnesom
SELECT *
FROM GIS.SDO_SWCSCULVERTIN
WHERE OBJECTID IN (#PreserveSingleQuotes(OBJ_KEYS)#)
ORDER BY OBJECTID


(or something like that)
Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.
Need installation help?

Start with some of our most frequented solutions or visit the Installation and Licensing Forum to get help installing your software.