We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

SQL ParserForm doesn't parse SQL Query

Hi,

I am using Aspose.cells for Reporting Services Excel add in. I am not able to fetch data from SQL database as
SQLParserForm doesn’t recognize comma between columns in select list and all the column names are merged under Fields.
image.png (3.3 KB)
image.png (3.6 KB)
Any ideas how to resolve this?

Thanks.

@sbommi1

Thanks for using Aspose.Cells for Reporting Services.

We were able to observe this issue as per your screenshots and logged it in our database for investigation and for a fix.

This issue has been logged as

  • CELLSRS-505 - SQL ParserForm does not parse SQL Query

@sbommi1

Thanks for using Aspose APIs.

Please download and try the following fix. It should fix your issue. Let us know your feedback.

This issue has been resolved. I see that ‘Update’ is missing in SQLParserForm but the query get parsed.

Thank you.

@sbommi1,

Thanks for your feedback and using Aspose APIs.

It is good to know that your issue is resolved with the latest fix. Let us know if you encounter any other issue, we will be glad to look into it and help you further.