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

Resolved PowersServer doesn't save the new value in date column using stored procedure in datawindow

  1. Issue
0
Votes
Undo
  1. Gita Shadabi
    Gita Shadabi
  2. PowerServer 2020 or older (Obsolete)
  3. Thursday, 17 September 2020 22:18 PM UTC

I have a datawindow with Datetime column which uses  stored procedure to save data.

when I change the date and tab out, and click on Save button the old data passes to the stored procedure and the new date doesn't save. I'm using the stored procedure update in my datawindow and not calling it directly from script and the date column is one of the arguments.When I use the dw.update() in the script, the old date is passed to the stored procedure not the new value.

This Scenario works on the thin client but not on the web.

Appeon PowerBuilder Cloud Pro

Version 2019 R2 Build 2353

PowerServer 2020 (PB Edition)

Windows 10

 

Database table lock when application terminated un...
FileService and PowerServer
Responses (1)
Armeen Mazda @Appeon
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Thursday, 17 September 2020 22:36 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 1

Chances are it is an unsupported feature.  We would have to see your code and know what database you are using to help further.

Another thing to be aware of is that PowerServer 2021 is making some big changes and it should basically support all PowerBuilder features.  Beta version targeted for January 2021.

Comment
Gita Shadabi
  1. Gita Shadabi
  2. Tuesday, 29 September 2020 20:56 PM UTC
We discovered that the data source had the same columns from two different tables without alias.

for example select t1.a, t2.a from t1, t2...It works on the thick client , but thin client doesn't like it. Gave names to the columns and the value got saved.
  1. Helpful
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Tuesday, 29 September 2020 23:06 PM UTC
"doesn't like it" usually means unsupported feature. Glad you were able to workaround the issue, and thanks for sharing the solution!
  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.
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.