Seal Report Forum
»
Report Edition
»
Reports
»
How to use N prefix(unicode sign) in generated restriction string
Rank: Newbie
Groups: Registered
Joined: 1/8/2016(UTC) Posts: 2  Location: sanandaj Thanks: 1 times
|
Would you tell me, please, where I can use N prefix before string in filter string?
seal will generate sql like:
SELECT ..... FROM a_table WHERE a_field in ('x','y')
but for unicode problem I must change pattern to
SELECT ..... FROM a_table WHERE a_field in (N'x',N'y')
Thank for guidence.
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209  Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
I imagine you need that for special characters.
Actually you cannot do that with the current version,
you have to re-build the project and modify the function
GetSQLValue(string value, DateTime date, Operator op) in ReportRestrictions.cs to add the N
We will check if adding this option is relevant for the incoming 2.0 version.
|
 1 user thanked epf for this useful post.
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 1/8/2016(UTC) Posts: 2 Location: sanandaj Thanks: 1 times
|
Originally Posted by: epf  I imagine you need that for special characters.
Actually you cannot do that with the current version,
you have to re-build the project and modify the function
GetSQLValue(string value, DateTime date, Operator op) in ReportRestrictions.cs to add the N
We will check if adding this option is relevant for the incoming 2.0 version. i need that for special characters and this problem is for all right to left Languages like Hebrew and Arabic that uses unicode characters.
|
|
|
|
|
|
Seal Report Forum
»
Report Edition
»
Reports
»
How to use N prefix(unicode sign) in generated restriction string
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
