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!

Register Log in
  • 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: *

  • Users: semoG
  • Order by date
  1. semoG

    PB DW report SELECT : ERROR - WHY ?

    Just checked the sqlsyntax parameter in sqlpreview event and it seems okay. I in fact executed that in toad and it works.
  2. semoG

    PB DW report SELECT : ERROR - WHY ?

    Hi there, thanks for your answer. The Database is Oracle. Yes in toad the sql statement executes: SELECT M.NIS_RAD, M.SEC_NIS, M.NUM_ACU, M.F_ACU, (SELECT DESC_EST FROM ESTADOS WHERE ESTADO = M.EST_ACU) AS ESTADO_ACORDO, M.F_RENOV, M.CANT_CUOTAS, (SELECT NVL(SUM(IMP_CUOTA),0)...
  3. semoG

    PB DW report SELECT : ERROR - WHY ?

    Hi there guys, I'm having a problem it seems that I have a problem with and DW SQL. The same SQL query works flawless on toad returning 2900 lines, but when executed in PB it returns an error: "SELECT ERROR:" with an ok button. I have tried regenerate the DW, also tried rebuild it, I have...

Part and Inventory Search

Back
Top