Infrastructure Map Server Forum
Welcome to Autodesk’s Infrastructure Map Server Forums. Share your knowledge, ask questions, and explore popular Infrastructure Map Server topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

oracle preserve single quotes

1 REPLY 1
Reply
Message 1 of 2
ebnesom
265 Views, 1 Reply

oracle preserve single quotes

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
1 REPLY 1
Message 2 of 2
Anonymous
in reply to: ebnesom

SELECT *
FROM GIS.SDO_SWCSCULVERTIN
WHERE OBJECTID IN (#PreserveSingleQuotes(OBJ_KEYS)#)
ORDER BY OBJECTID


(or something like that)

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report