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

Resolved Problem updating sql statements

  1. Issue
0
Votes
Undo
  1. Jesus Perez
    Jesus Perez
  2. PowerServer 2020 or older (Obsolete)
  3. Thursday, 9 February 2023 16:15 PM UTC

I have changed an sql update and deployed my aplication but in the mobile device is not working in that statement. I created a new aplication and perfectly works.

there is a cache or something like that in the server that is woring wrong?

I'm using PB2019 and powerserver 2020.

What can I do?

 

Thanks 

Powerbuilder 2022 with PowerSever 2019/20
Disconnect database transaction in PowerServer 202...
Responses (2)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 9 February 2023 16:25 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 1

Hi Jesus;

   Right after the App deployment .. did you try recycling IIS?

Regards ... Chris

Comment
Load more comments
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Friday, 10 February 2023 18:14 PM UTC
There may be some unsupported syntax in your statement
  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Friday, 10 February 2023 18:47 PM UTC
Hi Jesus .. If the IIS restart corrects your deployment latest App issue - then YES. ;-)
  1. Helpful 1
Jesus Perez
  1. Jesus Perez
  2. Friday, 10 February 2023 18:56 PM UTC
Armeen,



There are not unsupported syntax in my statement because in testing application works ok.
  1. Helpful
There are no comments made yet.
Armeen Mazda @Appeon
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Thursday, 9 February 2023 17:57 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 2

What database are you using and what SQL statement is not working?

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.