1. Sofhin Wong
  2. PowerBuilder
  3. Thursday, 2 March 2023 07:35 AM UTC

Anyone knows why would this happened?

 

 

 

I'm using Power Builder 12.5 and databse is MS-SQL ServerP

This error prompted when I retrieve the newly created document.

Sivaprakash BKR Accepted Answer Pending Moderation
  1. Saturday, 4 March 2023 11:15 AM UTC
  2. PowerBuilder
  3. # 1

This error might occur when you try to use 

dw_1.SetSQLSelect 

which tries to replace a column's datatype with another datatype.  

As Roland says, you need to check whether the original datawindow's column matches with the updated [through SetSQLSelcet] datawindows columnss' data type.  

HTH

Happiness Always
BKR Sivaprakash

 

Comment
There are no comments made yet.
Roland Smith Accepted Answer Pending Moderation
  1. Thursday, 2 March 2023 16:09 PM UTC
  2. PowerBuilder
  3. # 2

I think there is a datatype mismatch in your DataWindow. Probably it is expecting a number for a column but received non-numeric data.

Make sure the DataWindow is has the correct datatypes for the SQL it has.

Comment
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 2 March 2023 13:44 PM UTC
  2. PowerBuilder
  3. # 3

Hi Sofhin;

  PB runtime internal error codes only go from 001 through 300. Also, their message look & feel is quite different.

   So this 999 error seems to be ADO.Net related. In fact, it seems to relate to your SQL Select failing. 

   You might want to try running your Select statement in the PB IDE's DB Painter's iSQL Pane. For this test, the DB Painter should give you more information. If not, try a different SS connection mechanism (like SNC). HTH

Regards ... Chris 

Comment
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.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.