Dataset as complex Procedure
Hi,
I have a problem in retrieving the datafields for my report, I am using Delphi10.2 + NativeDB + SQL Anywhere + Fastreport 5:
AsaSession -> AsaDataset(containing a call to a complex procedure in DB) -> Datasource -> frxDBDataset -> frxReport.
The complexity in the called procedure is that it has several IF statements.
Problem: when I connect my Report to the frxDBDataset then I get no any data fields.
When I replace the SQL in the AsaDataset with a simple sql-query, then I get all those fields in my report normally.
Any help?
I have a problem in retrieving the datafields for my report, I am using Delphi10.2 + NativeDB + SQL Anywhere + Fastreport 5:
AsaSession -> AsaDataset(containing a call to a complex procedure in DB) -> Datasource -> frxDBDataset -> frxReport.
The complexity in the called procedure is that it has several IF statements.
Problem: when I connect my Report to the frxDBDataset then I get no any data fields.
When I replace the SQL in the AsaDataset with a simple sql-query, then I get all those fields in my report normally.
Any help?