stimulsoft-reports-js/SQL Adapter Serialization Issue
Posted: Tue Feb 20, 2024 4:31 pm
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:
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:
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
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 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 Is there any way to get around this issue?
Regards,
Russell