• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • SQL Server Bit value converts from 1 to -1 automatically in powerbuilder datawindow

Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved SQL Server Bit value converts from 1 to -1 automatically in powerbuilder datawindow

  1. Issue
1
Votes
Undo
  1. sivaraj manoharan
    sivaraj manoharan
  2. PowerBuilder
  3. Thursday, 12 July 2018 11:18 AM UTC

We are using SQL Server 2012 database. we have a bit column in some tables. while retrieving them from database to datawindow bit 1 converts automatically into -1. in datawindow it is a number column. kindly advice on how to resolve the issue.

Powerbuilder EXE is connecting to SQL Server.
Dynamic Multi Character Currency Symbol Formats wi...
Accepted Answer
Michael Hartnett
Michael Hartnett Accepted Answer Pending Moderation
  1. Thursday, 12 July 2018 11:55 AM UTC
  2. PowerBuilder
  3. # Permalink

Hi Sivaraj,

This question has been asked before and seems to be how the SQL Native Client Interface handles the return value.

Se the following https://community.appeon.com/index.php/qna/q-a/sql-bit-columns-returning-1-instead-of-1-to-the-datawindow

Chris Pollach's suggestion to set the StaticBind DBParm to 0, on the connection string is the normal fix/workaround.

Michael

Comment
There are no comments made yet.
Responses (2)
sivaraj manoharan
sivaraj manoharan Accepted Answer Pending Moderation
  1. Sunday, 15 July 2018 05:14 AM UTC
  2. PowerBuilder
  3. # 1

Dear Michael, I have added the DBParm StaticBind = 0 before connecting the database . I works fine. Thanks for your support.

Comment
Michael Hartnett
  1. Michael Hartnett
  2. Friday, 20 July 2018 11:26 AM UTC
Very Welcome
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.