I believe it's already converted to syntax. When I click the Design menu the only option is Covert to Graphics.
I see the syntax but only part of it and I can't scroll down to see the rest. The syntax window is gray.
I keep getting an SQL error when trying to Retrieve in my datawindow. When I edit the SQL, a grey screen showing the syntax appears but does not allow me to see the whole SQL statement. Is this a bug? I am using PB 7.0.3
There may be some "freeware" distillers. I am using this currently as Open Office natively reads word docs:
http://www.bezirksreiter.de/PyOpenOffice.htm
Update:
Apparently the LEFT OUTER JOIN syntax, which works find in an ODBC tool is not being interpreted by Oracle correctly.
"FROM {oj BWDBO.stsu_ship_unit LEFT OUTER JOIN ..."
causes the ORA-00911 error message. If I change the outer join to .. WHERE a = b (+), it works properly.
Go figure.
Here is the SQL code:
SELECT BWDBO.stsu_ship_unit.cont_scl_no ,
BWDBO.stsu_ship_unit.cont_ordr_no ,
...(snip)...
BWDBO.stsu_ship_unit.su_expt_ctl_class_no
FROM {oj BWDBO.stsu_ship_unit LEFT OUTER JOIN bwdbo.stsc_contract_register ON...
I have a Window that calls a datawindow with lookup values. I have unit tested the data window and it works properly but when I run the Window I get the error:
Select Error ORA-00911: invalid character.
Also, in the data window SQL builder I cannot see the entire SQL statement. Has anyone...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.