Discussions tagged C# Model generator
Select Error: ERROR [07006] [Sybase][ODBC Driver][SQL Anywhere]Cannot convert string to a integer
- Resolved
- Issue
- Last updated 3 months ago
- David Xiong @Appeon replied 3 months ago
Hi Team,
We just used PB2022 R3 to deploy one of our products on PowerServer. We are seeing odd problems with datatype conversion on one of the application's screens. I am only receiving the error in the Powerserver deployed app, even though it d...
SnapDevelop 2021: C# Model Converter issue
- Resolved
- Issue
- Last updated 2 years ago
- David Xiong @Appeon replied 2 years 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...
Efficient retrieval of nested data in Web API Model via .NET DataStore?
- Resolved
- Advice
- Last updated 2 years ago
- Roland Mühlberger replied 2 years ago
Dear .NET DataStore users,
we have a Web API based on the .NET Datastore that - especially in one case - uses heavily structured objects derived from DataObjects with nested objects which then get added as Properties in the Model annotated as DwRepo...
Convert DW to Model: very slow
- Issue
- Last updated 3 years ago
- Chris Pollach @Appeon replied 3 years 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 ...
Hi,
I am running PB 2019 R2 build 2328
I have SnapDevelop. I can open the C# application created on it from Powebuilder IDE just fine.
I am trying to use C# Model Generator to export my dw to the C# Webapi application.
When I right click the dw t...
Datawindow Converter Error with SnapDevelop 2019 R2
- Resolved
- Issue
- Last updated 4 years ago
- Ricardo Jasso replied 4 years ago
I am in the process of migrating a web api from SnapDevelop R1 to R2. We have about 50 datawindows that were exported to the api using the C# Model Generator. The exported srd's and classes for these were in a 'DataWindows' folder along with the co...
Retrieving LONG column in .NET datastore (Oracle)
- Resolved
- Issue
- Last updated 4 years ago
- Thomas Rolseth replied 4 years ago
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...
PB 2019 - missing context menu
- Issue
- Last updated 4 years ago
- Julie Jiang @Appeon replied 4 years ago
Hi All,
Hoping someone can help me with PB 2019.
I recently attended the Elevate recap in Barcelona, where Marco Meoni gave a workshop on using the PB 2019 and SnapDevelop. It was great to finally get to use the C# features, with the intention of ...
ASP.Net Web API, RetrieveOne method with string ID
- Resolved
- How-to
- Last updated 4 years ago
- Olivier PAVLIN replied 4 years ago
Hello,
I try to migrate some of my PB2017 project to a web api, in my model generate with my datawindow i have a 'Clients' table with a primary key ID as string value called "Cd_Cl".
Here is the generated model:
public class Dw_Clients ...
How would you modify the code from the C# generator to create a multi-tenant web api?
- Resolved
- How-to
- Last updated 5 years ago
- Sabir Foux replied 5 years ago
This may be more of a question I can post on the dotnet forums but I wanted to asked for the expert opinion from the Appeon community first.
Lets say I create a web api from my data windows using the C# generator. I want to have a database for each ...
C# Generation with Progress Database
- How-to
- Last updated 5 years ago
- Douglas Lee replied 5 years ago
I'm trying to generate C# web service for a progress database and keep getting the error....
[DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Syntax error in SQL statement at or about ") = 'autoincrement' then 1 else 0 end AS" (107...
Parsing error in C# Model Generator
- Resolved
- Issue
- Last updated 5 years ago
- Chris Pollach @Appeon replied 5 years ago
I try to generate classes with C# Model Generator.
DB Connection is ODBC - informix.When i test connectiion PB say is ok.
When i try generate classes give me excetption
System.Data.Odbc.OdbcException (0x80131937): ERROR [42000] [Informix][In...
C# Model Generation Error - SQL Server
- Issue
- Last updated 5 years ago
- Thomas Rolseth replied 5 years ago
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 ...
- Page :
- 1