1. Luca DG
  2. PowerBuilder
  3. Wednesday, 20 February 2019 18:43 PM UTC

Hi

in my application I use the SQLPreview event in Datawindows for logging purpose writing on a log table the SQL's command used by DW's.

I'm using Microsoft SQL Server (2008 to 2012).

Since I have begin to use the NChar datatype for foreign chars (like hebrew and greek) I have to set to '0' the DisableBind parameter in SQLCA.

From that point the SQLSyntax in SQLPreview event doesn't contain the parameter of the query but only '?'

UPDATE customer SET name= ? WHERE iD= ? 

With DisableBind = 1 I have the correct SQLSyntax :

UPDATE customer SET name= 'Luke' WHERE iD= 123

But doesn't not work with NChar data.....

I have tried several combination of DisableBind, StatiBind and NCharBind on the connection string but I have not find the right combination.

 

Any suggestions ?

 

Thanks, Luca.



There are no replies made for this question yet.
However, you are not allowed to reply to this question.