Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. 1stpoint

    SQL Error in DataWindow

    I figured it out. I downloaded and applied the latest 7.0.3 EBF from sybase. It now works. It was a bug.
  2. 1stpoint

    SQL Error in DataWindow

    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.
  3. 1stpoint

    SQL Error in DataWindow

    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
  4. 1stpoint

    doc convertion to pdf

    There may be some "freeware" distillers. I am using this currently as Open Office natively reads word docs: http://www.bezirksreiter.de/PyOpenOffice.htm
  5. 1stpoint

    Pb 7.0.3 -> Windows 2003??

    Thanks for your information. The current version of PB is 10. Is it a pretty clean migration to go from 7 to 10?
  6. 1stpoint

    Pb 7.0.3 -> Windows 2003??

    We are upgrading our server to Windows 2003 and want to know if Powerbuilder 7.0.3 is supported on that platform. Thanks.
  7. 1stpoint

    Sql Syntax problem / PB 7.0.3

    The datawindow is already converted to syntax. I don't seem to be able to convert it back. ugh!
  8. 1stpoint

    Sql Syntax problem / PB 7.0.3

    LEFT OUTER JOIN is Ansi Standard. the (+) syntax is not. How do I have PB use the Ansi with Oracle?
  9. 1stpoint

    Sql Syntax problem / PB 7.0.3

    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.
  10. 1stpoint

    Sql Syntax problem / PB 7.0.3

    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...
  11. 1stpoint

    Sql Syntax problem / PB 7.0.3

    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...

Part and Inventory Search

Back
Top