Results 1 to 10 of 10

Thread: DataFlex Report 2022 - HY104 Invalid Precision Value

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Mar 2018
    Location
    Singapore
    Posts
    15

    Default DataFlex Report 2022 - HY104 Invalid Precision Value

    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
    Last edited by utama; 9-May-2022 at 08:31 PM. Reason: not able to attach an image for the error.
    Willy Tanta Utama
    Winnfii Pte Ltd
    www.winnfii.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •