1. Anna Uden
  2. PowerServer Web
  3. Friday, 20 April 2018

I have my application upgraded to PB 17 Build 1756.  Works great so far as a desktop application connecting to MS SQL Server 2016 using the SNC SQL Native Client driver. 

I deployed it to the PowerServer Web successfully and am able to retrieve data from the database.  However, if the timestamp column is included in the result set, no rows are returned to datawindows.  Just returns 0 rows and no errors.  

Is this because the reselectrow function is not supported?

 

 

 

Appeon Support Team Accepted Answer Pending Moderation
0
Votes
Undo

Hi Anna,

Yes, the DataWindow ReselectRow method is unsupported.

Workaround #1

If the DataWindow's source table has a primary key, to work around this issue, follow the steps below:

Step 1: Use GetItem() to get the value of the primary column in the current row.

Step 2: Use SQL statement to retrieve data for the current row according to the value of the primary key.

Step 3: Use SetItem() to assign values to each column in the current row.

Step 4: Change the status of the current row to "NotModified!"

Workaround #2

Replace the ReselectRow function with the Retrieve function.


If there is still the issue, please provide a simple PB case to reproduce it to us for more study, thanks.

Regards,
ZhaoKai

Comment
There are no comments made yet.
  1. Monday, 23 April 2018
  2. PowerServer Web
  3. # 1
Chris Pollach Accepted Answer Pending Moderation
0
Votes
Undo

Hi Anna;

  Did you declare the connection mechanism to your SS2016 DB in PowerServer's Data Source as MS SS Native Driver ?

Regards ... Chris

Comment
Yes.  It has the MS SQL Server Native Driver



 



 



 

  1. Anna Uden
  2. Friday, 20 April 2018
There are no comments made yet.
  1. Friday, 20 April 2018
  2. PowerServer Web
  3. # 2
  • 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. Learn More