Skip to Content
avatar image
Former Member

"Fractional truncation" error using PowerBuilder 12.1 with SQL 2016

Hi

We are testing our legacy PowerBuilder 12.1 app against SQL 2016, and during INSERT operations have started seeing intermittent errors that say "Fractional truncation":


SQLSTATE = 01004
[Microsoft][ODBC SQL Server Driver]Fractional truncation

No changes made to database.

INSERT INTO dbo.payment ( yy, number, sequence, paid, date, numbers, contract, installment, code, total, fees, comment, receipt, sequence2 ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )

--

We ran a SQL trace, were able to identify two queries that failed, along with their values. However, when we run the queries by hand, they both succeeded.

Any ideas, suggestions, pointers greatly appreciated

Thanks

JQ

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jun 23, 2017 at 07:31 PM

    Commenting to see if this will show up in feed.

    Add comment
    10|10000 characters needed characters exceeded