- This topic has 0 replies, 1 voice, and was last updated 7 years, 7 months ago by .
Viewing 1 post (of 1 total)
Viewing 1 post (of 1 total)
- You must be logged in to reply to this topic.
Home › Forums › eaDocX queries › SQL Search works in EA but not in eadocx.
Home › Forums › eaDocX queries › SQL Search works in EA but not in eadocx.
I’m using eadocx 3.9.3.9 with EA 13 with an Oracle database.
I want to drive the Word doc section with an EA search (see attachment). The sql works in EA but gives the following error if I call it from eadocx as a report:
Microsoft OLE DB Provider for ODBC Drivers [-2147467259] [Oracle][ODBC][Ora]ORA-00911:invalid character
Any ideas?
BTW
Ive made the strings after the AS clause simple strings as previously advised.
Download eaTeamWorks today for several free for life features, plus no obligation, 30-day trials of all the products: eaDocX, ea Revision Manager, eaSheets, Model Expert and PortfolioManager. Discover for yourself why we sell the world’s best-selling Enterprise Architect extension.
Download