Datawindow Error - Select error: Incorrect syntax near '='

[Former Member]

I am trying to create a datawindow based on a SP but I get this.

I'm using PB12  and SS 2008 (SQL Native Client).

at run time,

dw_1.setTrans(SQLCA)

dw_1.retrieve('10Z0122',2016,9)

Kindly shed some light on this.

Thank you very much!

[Former Member · Accepted solution]

Hi Ryan;

  Suggestion:  I would also try executing the Stored Procedure from the PB IDE's DataBase Painter first. In the DB Painter, activate the iSQL Session pane and use the EXECUTE SP_xxxxxxx  arg1, arg2, ... to run the SP and deem whether its actually working first before trying to build your DW.

HTH

Regards ... Chris

[Former Member · Accepted solution]

Impeccable as always!

Thank you!

[ricardojasso · Accepted solution]

So, what was the solution to the problem? What did you have to modify?