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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by 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.- semoG
- Post #4
- Forum: Sybase: PowerBuilder
-
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)...- semoG
- Post #3
- Forum: Sybase: PowerBuilder
-
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...- semoG
- Thread
- Replies: 5
- Forum: Sybase: PowerBuilder
