Discussions tagged SnapDevelop
Is there a maximum size for output ParamValue arguments from a stored procedure in SnapObjects
- Resolved
- New
- Issue
- Last updated 6 days ago
- Daryl Foster replied 5 days ago
Hi, we've been using SnapObjects for quite a while without too many issues, but today we found that one of our stored procedure calls truncates the output parameter to 4000 characters. Is that configurable in SnapObjects, or is it a hard limit? We a...
Problemas con tipo de datos en la construccion del modelo
- Misc
- Last updated 2 months ago
- Chris Pollach @Appeon replied 2 months ago
Tengo una aplicaicon PB2021 , al crear un proyecto POWERSERVER 2021; estoy teniendo problemas con la generacion del modelo, en SnapDev, veo que el modelo crea un tipo de datos que no corresponde al DW.
El asunto es que el SP DataSource del dw es un ...
PowerServer 2021 Transaction Error
- Issue
- Last updated 3 months ago
- Thomas Rolseth replied 3 months ago
I've deployed a PB application to PowerServer 2021. The application uses SQL Server for the backend database and is hosted on a remote AWS web server running IIS. The deployment process went fine and I can launch the app w/o issue using the CAL.
...
DateTime data type error with PowerServer WebAPI
- Issue
- Last updated 3 months ago
- Armeen Mazda @Appeon replied 3 months ago
I am getting a datawindow error when retrieving a datawindow that is part of a tab page on a window. See attached image to view the error. The database is SQL Server and the application has been been deployed to PowerServer 2021. The datawindow ha...
SnapDevelop 2021: C# Model Converter issue
- Resolved
- Issue
- Last updated 4 months ago
- David Xiong @Appeon replied 3 months ago
We have a client that made a simple change to a datawindow. They changed a column in the select from CAST(col1 AS CHAR(10)) to TO_CHAR(col1). They then used the C# Conversion tool in SnapDevelop 2021 to import this change into the API which was succe...
POST content-type application/json: max. Textsize 32K?
- Resolved
- How-to
- Last updated 5 months ago
- David Xiong @Appeon replied 5 months ago
Hi,
I'm beeing writing a small WEB-API which has to process POSTed metadata and files as json-data and insert it into a SQL Server database.
I know, the client could send the data and files together in one POST using the content-type form-data.
B...
Is CrypterObject supported in SnapDevelop 2021?
- Issue
- Last updated 6 months ago
- Francisco Martinez @Appeon replied 6 months ago
I am using the SnapDevelop 2021 Powerscript to C# migrator tool. I received the not supported errors on the CrypterObject. as shown below:
// [ERROR0008] Translation of the enum value(AES!) is not supported. // [ERROR0008] Translation of the enum v...
CancellationToken in SnapDevelop
- How-to
- Last updated 7 months ago
- Francisco Martinez @Appeon replied 7 months ago
Per the SnapDevelop documentation, the RetrieveAsync method takes a cancellationtoken parameter to make an operation cancelable (see link below) and throws an exception in the TRY/CATCH block if that if that happens. How is that done in practice thou...
Where do put my validation code in WEB API
- How-to
- Last updated 8 months ago
- Francisco Martinez @Appeon replied 8 months ago
Hello all!
I am new to Web API and C#. I have watched most videos on API (Bruce Marc and others). I want to develop web api that can be consumedby any client not just powerbuilder app, Client app will send just one row at a time. So I am assuming ca...
Hi all, hope this wasn't asked before:
Creating the web api sample project from snap development 2021 I get a service listening on localhost:5000. Connecting with a test program consuming on this address works fine.
When I change the IP address in ...
Re: Can we still remain as a PowerBuilder developer?
- Misc
- Last updated 9 months ago
- Armeen Mazda @Appeon replied 9 months ago
Hello,
Released features and planned one (Roadmap)
We have been using Powerbuilder for more than 2 decades and still love to be a powerbuilder developer(s). We have tons of codes developed in powerscript and have experience in analysing and solvi...
Data Type "Numeric()" Identity column not supported
- Resolved
- Issue
- Last updated 9 months ago
- shoaib siddiqui replied 9 months ago
I have a small test project in SnapDevelop/R3 to test WebApi using SAP ASE database, I have simple datawindow in my target. While converting this datawindow in SnapDevelop I am getting this error.
Parsing 'd_all_tickets_contract (c:\dev\e-ticket\ti...
load sqlselect from model without params
- How-to
- Last updated 10 months ago
- David Xiong @Appeon replied 10 months ago
is it possible to load a sqlselect from a model without params?
I have this structure:
[SqlParameter(name: "first", dataType: typeof(int))][SqlParameter(name: "second", dataType: typeof(int))][FromTable("mytable", Schema = "DBA")]
[SqlWhere("...
retrieve Data from Model using the sqlselect attribute and paramvalues
- Resolved
- How-to
- Last updated 11 months ago
- David Xiong @Appeon replied 11 months ago
How can i retrieve Data from Model using the sqlselect attribute and paramvalues?
I already ask a stackoverflow question;
https://stackoverflow.com/questions/68129138
How can I retrieve data from my SQL-Model using the SqlSelect attribut...
SnapDevelop Connecting to MS SQL Server
- Resolved
- Issue
- Last updated 11 months ago
- Sivaprakash BKR replied 11 months ago
I'm using SnapDevelop 2019R3 Build 2703. I cannot connect to MS SQL Server. I get network connectivity error and a timeout. I can connect to the same database using PB IDE on the same Wind 10 PC.
I've checked that required protocols are enabled o nt...
Cannot find some libraries in SnapDevelop
- Issue
- Last updated 1 year ago
- Alex Hernandez replied 12 months ago
Hello,
I've just created a WebAPI project in SnapDevelop (2019 R3), and as it opens I get these errors. It seems that it does not find SnapObjects library and I have not found how to deal with this.
I tried to add a DataContext file just to test ...
Hello,
I'm trying to create a database connection in SnapDevelop 2019 R3 (I tried in R2 also) to an Oracle database, but I get the error "ORA-12537: Network Session: End of file". It's strange because I can connect to this database in Powerbuilder w...
WebAPI Tester and optional parameters
- Issue
- Last updated 1 year ago
- Logan Liu @Appeon replied 1 year ago
My API has a method with an optional parameter, that is passed as path:
api/v1/ISV/Credits/[Channel]
It is marked as [HttpGet("{customer?}")] and is declared as:
public string Credits(string channel="")
in the WebAPI Tester, it is listed ...
Hello,
Using SnapDevelop 2019 R3 Build 2703 & Visual Studio Community 2019
Project: .Net-DataStore-Example
Trying to publish it in a Win 10 computer from both SnapDevelop and Visual Studio. Works fine when published from Visual Studio and N...
Convert DW to Model: very slow
- Issue
- Last updated 1 year ago
- Chris Pollach @Appeon replied 1 year ago
Hello,
When I convert a datawindow to a C# model in SnapDevelop, it takes forever.
"Forever" meaning about 2 minutes. The first times I was thinking that it just didn't work.
My DW has about 10 columns, 1 or 2 tables. If I try other DW's it's the ...
- Page :
- 1