Hi
On DataFlex Report 8.1.0.36, I encounter the following error when executing a report using stored procedure with an nvarchar parameter.
"Error: HY104, [Microsoft][ODBC Driver 13 for SQL Server]Invalid precision value"
The happens on both ODBC Driver 13 and 17.
The following is an example of a stored procedure:
Code:
CREATE OR ALTER PROCEDURE [dbo].[wpRpt_AcmRoleCode_AccessByRoles]
(
@RoleCodes nvarchar(255) = null
)
AS
BEGIN
set nocount on;
create table #AccessRoleDisplay(
AccessSeq int
,AccessType nvarchar(255)
,AccessName nvarchar(255)
,AccessCatalog nvarchar(30)
,AccessValues nvarchar(255)
)
;
select * from #AccessRoleDisplay
END
GO