Discussions tagged SnapDevelop
We are using PB/SnapDevelop 2019 build 2082 with an Oracle 12 database. I created a datawindow/datastore object with a SELECT that matches the columns and datatypes of an external datawindow and then ported it to the API using the C# Model Generator...
I'm getting a parsing error when trying to port a datawindow to our Web API using the C# Model Generator. The database is Oracle and the error is Error: ORA-00952: missing GROUP keyword. Below is the select statement being used. It seems like the...
Hi All,
There is a blob column in one of our Oracle database that has to be displayed to the Users in our web site.
We are coding a new REST Web API that one of our web sites is consuming the methods.
The Snap Develop is the PB 2019, not the PB 20...
I am trying to deploy a web api I created with SnapDevelop from a development server to a production server and am getting the attached error when calling the api. The api uses aspnetcore v2.1.1 (via nuget) and I had the client install that on produ...
Hi All,
The result set return by the datastore is a JSON format which is different when compared with the JSON string returned by the datastore.ExportPlainJson built in method: teh column names are surrounded by the back slash character \
Example i...
Hello,
(probably someone from Appeon should answer this question)
On your website "Installation Guide of SnapDevelop (PB Edition) 2019" you have listed this as requirements:
Microsoft .NET Framework 4.6.1 SDK
Microsoft .NET Core SDK 2....
We are experimenting with C# Model Generator and SnapDevelop in Powerbuilder 2019. We would like to use this to create ASP.Net WebApi C# code based on our existing Datawindows so we don’t have to write all the code from scratch.
According to the App...
Hi all,
the .NET Datastore only has a couple of events, namely RetrieveStart, RetrieveEnd, UpdateStart, UpdateEnd, RowDeleting, RowDeleted.
There does not seem to be an event "SqlPreview". In PowerBuilder one can see the issued SQL of every single ...
In my PowerBuilder Client, I want to use the JsonPackage object to send the result sets of two datastores to our Web API that was created with SnapDevelop. Here is my PB code:
//set values of JSONPackage with API datastores ljpk_submit.setvalue( "...
I'm getting a parsing error in the C# model generator for a datawindow that I am not sure how to resolve -- see attached. The datawindow works fine in PB when doing a preview and passing the required arguments. The issue appears to related to a sub...
We are using xUnit for our unit tests. Tests – very simple ones – will often fail with the attached error when doing a 'Run All Tests' operation. And it is random. If I select the failed test that is highlighted below and do a 'Run Selected Test' ...
Hi All,
This is INFORMATION - Not request for help
You may experience issue with VS Code not recognizing C# code targeted for .NET Core 3.0 if you also have SnapDevelop installed. Same issue may occur if you have any app installed that embeds MSBui...
I'm using the datastore model of SnapDevelop in a web api to populate an external datawindow in the client using the ShareData() method. How would I -- with one restclient call -- populate this multi-row grid datawindow AND also import a single row ...
Problem: Any value I pass to the Retrieve(argument) method returns the error below. I can't tell why.
I've tried different data types in the database I need to pull records from. I've tried to use Guids, strings, number types, etc, but none of them ...
Hi,
I've started using SnapDevelop today for the first time and I've got a small issue when I run my project. It pops up with the attached Security Warning about installing a root certificate for localhost. I only seem to get this message if I run ...
Using PB 2019, we have migrated several datastores to a SnapDevelop .NET assembly. Looking through the various tutorials and sample projects, we do not see any examples of accessing datastore column values using object dot notation. All appear to use...
How can I change the code template SnapDevelop uses when I create new "API Controller Class"?
Initially I want to
decouple action names in route from method names in the controller
- and - rename HttpPost method Update => Insert
- and - rename ...
I am getting an error when exporting a datawindow using the C# Model Generator to a snapdevelop web api. When I open the C# Model Generation window I am asked to select/setup a database connection profile which I am able to do. The test connection ...
hello community
How do I enable GIT sin SnapObject?
thank you
Gimmy...
Hi,
we are in the process of building a Web API with SnapObjects. In PowerBuilder, we support either Sql Server or Oracle with the same table structure.
For number columns we use "int" in Sql Server and "number(38)" in Oracle. Unfortunately that le...
- Page :
- 1