1. Joel Norby
  2. .NET DataStore
  3. Friday, 12 June 2020 21:31 PM UTC

Hi.

We're working on coverting our app from PB to C# and using the Appeon DWNet extensions for our datawindows.  Our customers have custom dws and we are trying build datastore objects by loading the dw .srd files at run time.  Using this example to do this: https://docs.appeon.com/appeon_online_help/powerscriptmigrator2019r2/api_reference/PowerScript.Bridge/DataObject/DataObject/Constructor/DataObject1.html

 

This is working for datawindows that have a stored procedure datasource without parameters and also for datawindows that use SQL as a datasource. What it isn't working for is the situation with a dw with a stored procedure as a datasource that has parameters. We get the following error:

 

The rest of our standard dws are working fine - have used the Snapdevelop tools to create models and dataservices for those datawindows.

Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Friday, 12 June 2020 21:58 PM UTC
  2. .NET DataStore
  3. # 1

The .NET DataStore does not support ASE.  We are working to support this in PowerBuilder 2019 R3.  Please open a  support ticket and provide the code sample that is failing so we can resolve in the next revision.

Just FYI, the databases currently supported are SQL Server, Oracle, SQL Anywhere, PostgreSQL, MySQL, SQLite.

Comment
  1. Joel Norby
  2. Monday, 15 June 2020 15:20 PM UTC
Thanks, I know you don't support ASE. However all of the datastores we built specific models for are working correctly(in ASE). It is only in this specific situation where there is an issue(dynamically created datastore with a stored procedure as a datasource that has parameters).
  1. Helpful
  1. Armeen Mazda @Appeon
  2. Monday, 15 June 2020 15:22 PM UTC
When we claim something is not supported it doesn't mean it won't work at all. It can be some things fail and we haven't gotten around to resolving.

As I mentioned, please open a support ticket and provide example code that is failing so we can address in future release.
  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.