Print Thread
TOracleScript commented semicolon
#8323 04/18/06 09:05 PM
Joined: Apr 2006
Posts: 10
M
Member
OP Offline
Member
M
Joined: Apr 2006
Posts: 10
TOrcaleScript seems to have problem with commented semicolons:

CREATE OR REPLACE FORCE VIEW tmp_daily
( resort, resv_name_id, from_resv_id )
AS
-- this is a comment that breaks TOracleScript;
-- only when ; is last non-blank char in line
SELECT
'Resort' , 'Resort1', '1'
FROM DUAL

executed with TOracleQuery works fine, with TOracleScript returns exception 'ORA-00928: missing SELECT keyword'

Anything I'm missing here?

D5 DOA 4.0.6.2

Re: TOracleScript commented semicolon
#8324 04/18/06 09:59 PM
Joined: Aug 1999
Posts: 22,217
Member
Offline
Member
Joined: Aug 1999
Posts: 22,217
This problem has been fixed. Let me know if you need a pre-release.


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.363s Queries: 14 (0.174s) Memory: 2.4964 MB (Peak: 3.0394 MB) Data Comp: Off Server Time: 2024-05-14 07:06:59 UTC
Valid HTML 5 and Valid CSS