Question Re: Datawindow Error - Select error: Incorrect syntax near '=' in Technology Q&A

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

Former Member — Thu, 01 Sep 2016 02:27:02 GMT

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!

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

Former Member — Thu, 01 Sep 2016 03:20:19 GMT

Hi Ryan;

Can you attach the full source of the SP so we can see the In/Out variable assignments?

Thanks ... Chris

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

Former Member — Thu, 01 Sep 2016 04:19:31 GMT

Here:

Thank you, Chris!

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

Former Member — Thu, 01 Sep 2016 13:21:09 GMT

Thanks Ryan;

Well ... that looks pretty straightforward from what I can see.

I wonder if an SQL trace might help here! Since you mentioned that you were using a native SS connection, the code should be:

SQLCA.DBMS = "TRACE SNC"

Then lets see exactly what is going on during the Retrieve ().

Regards ... Chris

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

Former Member — Fri, 02 Sep 2016 12:55:02 GMT

Try prefacing each argument name with "@", as in:

@empid = :empid, @sal_year = :sal_year, etc.

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

Former Member — Fri, 02 Sep 2016 14:00:32 GMT

You are missing the Server and Database Name in NOT EXISTS condition ..

Please change from tbl_register_trial_salary to PCMA_PIS_ASE.pis_db.dbo.tbl_register_trial_salary .

It should work..

Also change the execute in datawindow as follow

execute dbo.get_register_traial_list; 1 @empid = :empid , @sal_year = :sal_year , @sal_month = :sal_month

Regards,

Jahir

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

Former Member — Fri, 02 Sep 2016 14:16:52 GMT

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

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

Former Member — Fri, 02 Sep 2016 23:30:24 GMT

Impeccable as always!

Thank you!

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

Former Member — Fri, 02 Sep 2016 23:31:18 GMT

Thank you!

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

Former Member — Fri, 02 Sep 2016 23:50:06 GMT

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