1. Vignesh Ramkumar
  2. PowerServer
  3. Tuesday, 5 September 2023 07:49 AM UTC

Hi,

Recently we migrated our application into Powerserver 2021 version. While migrating we faced some below Unsupported Powerserver features in PFC libraries

  • sqlreturndata
  • previewinsert
  • previewdelete
  • previewupdate

when i searched help docs 

https://docs.appeon.com/ps2021/bk06ch02s01s05.html

https://docs.appeon.com/ps2021/bk06ch02s01s06.html

not able to find the workaround for the above PFC feature

 

Kindly help me to identify the workaround for the above features.

 

Thanks

Vignesh

Accepted Answer
Bruce Armstrong Accepted Answer Pending Moderation
  1. Thursday, 7 September 2023 21:47 PM UTC
  2. PowerServer
  3. # Permalink

What you should be getting are "warnings", not errors.  For reasons I'll elaborate on below, you should be able to just ignore them.

In the current release of PowerBuilder, the sqlpreview event on the datawindow and datastore will never fire events where the sqltype is previewinsert, previewdelete and previewupdate on the client when you are using PowerServer services.  Which means the code in question in sqlpreivew will just never fire.  That makes a lot of sense given that it's the middle tier services, not the client, that is generating the SQL.  Even what is provided for a sqltype of previewselect is of limited value fpr a PowerServer client app as tha is just what the datawindow would have generated if it was talking directly to the database and may have little to do with what PowerServer actually uses.

The only thing hat PFC uses that event for is the SQLSpy service.  That simply means that the SQLSpy service won't work for a PowerServer client app.  Just don't use that service in that case, because as indicated above it wouldn't be showing you much of any value if it did return the SQL statements.

 

Comment
  1. Armeen Mazda @Appeon
  2. Thursday, 7 September 2023 23:23 PM UTC
Adding to what Bruce said, did you test your application and there is some functionality not working? Also, make sure you are using latest version of PFC it has been updated to be compatible with PB 2022. https://github.com/OpenSourcePFCLibraries/2022
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 5 September 2023 15:19 PM UTC
  2. PowerServer
  3. # 1

Hi Vignesh;

  FWIW: Those restrictions are also present in PS 2022, as follows:

https://docs.appeon.com/ps2022/SQLPreview.html

https://docs.appeon.com/ps2022/SQLReturnData_property.html

Unfortunately (AFAIK), there are no workarounds yet in the PFC framework for these. I would also suggest though posting this issue in the PFC forum to get see if they can provide you a PFC specific based workaround: https://github.com/OpenSourcePFCLibraries

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.