Discussions tagged SnapDevelop
Hi Guys
I've a table "flusso_ccic" and a datastore in PB2019 R2 on it
No column identity, just the key from some columns
I converted to a Model on Snap Develop R2 and Retrieve works fine, but If I try to Run a Create from a rest Client the query f...
I am creating a unit test (XUnit) for a service in SnapDevelop. The service method takes a DataUnPacker object as a parameter. This gets passed to the API from PowerBuilder using the jsonpackage object. My question is how can I populate this in a ...
I have setup JWT Authentication in our SnapDevelop Web API using this as a guide:
https://docs.appeon.com/appeon_online_help/snapdevelop2019/Secure_a_Web_API_with_JWT_Token/index.html
It seems to be working well so far and I am getting a token back...
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...
Web API Deployment
- Resolved
- Issue
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...
SnapDevelop and .NET
- Resolved
- Misc
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 ...
Process JsonPackage in SnapDevelop Controller
- Resolved
- How-to
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 ...
Certificate Security Warning from SnapDevelop
- Resolved
- Issue
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 ...
Object dot notation examples for .NET Datastore
- Resolved
- How-to
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 ...
Find Questions by Tag
.EXE
.NET 6.0
.NET Assembly
.NET Core 3.1
.NET Core Framework
.NET DataStore
.NET Std Framework
32-bit
64-bit
ADO.NET
AEM
AI
Algorithm
Amazon AWS
Android
Apache
API
APK
App Store
App Store (Apple)
Appeon Workspace
Appeon Xcelerator Plug-in
Architecture
Array
ASE
Asynchronous Methods
Authentication
AutoBuild
AutoCompiler
Automated Testing
Automation
AutoScript
Azure
Barcode
Base64
Batch
BigData
BLOB
Branch & Merge
Browser
Bug
Build
Button
C#
C# Class Importer
C# Editor
C# Model generator
Calendar
Camera
Certificate
Chrome
Citrix
Class
Client
Client/Server
Cloud
Cluster
Collection
COM
Command Line
Compiler
Compression
Computed Field
Configuration
Controls
Cookies
Cordova
Crash
Cross-Platform
Crosstab
CSharpAssembly
CSharpObject
CSS
CSV
Cursor
Data
Database
Database Driver
Database Painter
Database Profile
Database Provider
DataObject
DataSource
DataStore
DataStore (C#)
DataStore (PS)
DataType
DataWindow
DATE
DATETIME
DB2
Debug
Debugger
Debugging
Deployment
Design
DLL
DO-WHILE
Dockable
Docker
Documentation
DOUBLE
Download
DragDrop
Edge
Edit Style
Editor
Elevate Conference
Email
Embedded SQL
Emulator
Encoding
Encryption
Enhancement Request
Entity
Entity Framework
ERP
Error
Event
Event Handler
Event Handling
Excel
Exception
Export
Expression
External Functions
F#
Field
File
File Access
Filter
Firefox
Firewall
Font
FOR-NEXT
Foreground
Format
Function
Garbage Collection
GeoLocation
Git
Graph
HANA
Hash
Header
HTML/5
HTTP/S
HTTPClient
Icon
IDE
Identity
IIS
IMAPI
Import
InfoMaker
Inheritance
Installation
Integer
IntelliSense
Interface
Internet
Internet Explorer
iOS
IPA
iPad
iPhone
IWA
J#
Java
JavaScript
JBoss
JDBC
JOIN
JSON
JSONGenerator
JSONParser
Kestrel
Label
Lambda
Large File
LDAP
Library
License
LINQ
Linux OS
Load Balancing
Localization
Localized PBVM
Log In
Log Out
Logging
LONG
LONGLONG
macOS
MAPI
Maps
MDI
Memory
Memory Leak
Menu
Merge
MessageBox
Messagging
Method
Migration
MIME TYPE
Mobile
Model
ModelStore
ModelStore (C#)
MSOLEDBSQL
Multi Threading
MVC
MySQL
n-Tier
Namespace
NativePDF
NVO
OAuth
ODATA
ODBC
Office
Offline
OLE
OLEDB
Online
Open Source
OpenAPI
OpenSSL
Oracle
OrcaScript
Other
Outlook
Output
Package
Parameter
Patch
PayPal
PB Classic
PB Native
PB.NET
PBC
PBD
PBDOM
PBG
PBJVM
PBL
PBNI
PBORCA
PBVM
PBX
PDF
Performance
Permission
PFC
Picture
Pipeline
Play Store (Google)
Plugin
Popup
Port
POST
PostgreSQL
PowerBuilder
PowerBuilder (Appeon)
PowerBuilder (SAP)
PowerBuilder Compiler
PowerBuilder Runtime
PowerClient
PowerScript (PS)
PowerScript IDE
PowerScript Migrator
PowerServer
PowerServer Mobile
PowerServer Toolkit
PowerServer Web
PowerServerLabel
Print
Properties
Proxy
Publish
PULL
PUSH
Query
Regression
Release
Renew
Resize
Response
REST
Retrieve
RibbonBar
RibbonBar Builder
Rich Text
Roadmap
RPC
Runtime Packager
SaaS
Scaffolding
Script
SDI
SDK
Security
Server
Service
Session
Single Sign-on
Size
SMTP
SMTPClient
SnapDevelop
SOAP
Sort
Source Code
Speech Recognition
SQL
SQL Anywhere
SQL Server
SqlBuilder
SqlExecutor
SQLite
SqlModelMapper
Storage
Stored Procedure
Subscription
SVN
Swagger
Syntax
TabbedBar
TabbedView
Tablet
TabPage
Target
TE Control
Testing
Text
TFS
Theme
TIME
Timer
TLS/SSL
Tomcat
TortoiseGit
TortoiseSVN
Transaction
Transparency
Trial
Trigger
TRY-CATCH
TX Control
Type
UI
ULONG
UltraLite
Uninstall
Unit Test
Unit Testing
UNIX OS
Update
Upgrade
Upload
URL
User Center
User Object
UWP
Validation
VARCHAR
Variable
Versioning
Visual Studio
Visual Studio Code
VM
Voice
Warning
WCF
Web API
Web Extensions
Web Service
WebBrowser
WebForms
WebLogic
WebSphere
WildFly
WinAPI
Window
Windows OS
WinForms
Wizard
Workgroup
Workspace
WPF
XCODE
XHTML
XML
Zoom