stimulsoft-reports-js/SQL Adapter Serialization Issue

[russell.pooley]

Hello all,

I previously reported an issue with the slow performance of the Blazor version so have now moved on to using the JS version which is going well at the moment aside from a small issue.

If we use the following SQL in the query as an example:

Code: Select all

Select h.Id as hid,t.Name as Template, cast(h.__InsertTimestamp as INT) as SurveyNumber
    --SITE DETAILS
    ,Max(CASE WHEN q.Name = 'HiddenSite' THEN a.[Value] END) AS [SiteName]
    FROM Table 

When it is sent up to the server via the StiOptions.WebServer.url for some reason all the /r and /n are stripped from the query in the request so you end up with the query being sent as the following:

Code: Select all

Select h.Id as hid,t.Name as Template, cast(h.__InsertTimestamp as INT) as SurveyNumber     --SITE DETAILS    ,Max(CASE WHEN q.Name = 'HiddenSite' THEN a.[Value] END) AS [SiteName]    FROM Table 

This creates a problem because SQL Server interprets the -- as a comment and thus the entire SQL from that point.
Is there any way to get around this issue?

Regards,
Russell

[Lech Kulikowski]

Hello,

We need some time to investigate the issue. We will let you know about the result.

Thank you.
#13810

[Lech Kulikowski]

Hello,

The issue is fixed. The fix will be available in the next release build.

Thank you.