Discussions tagged DataStore (C#)
How to Sort by multipe columns (IDatastore.Sort)
- Resolved
- How-to
- Last updated 4 years ago
- Ramón San Félix Ramón replied 4 years ago
In my PowerBuilder applications I order the datawindow with various parameters as in the following example ...
dw_1.SetSort("param1 a, param2 a, param3 a")
dw_1.Sort()
In SnapDevelop I see Sort Method, but I don't know how to order multiples p...
How to replace "SqlExecutor.SelectToStore" method ?
- Resolved
- How-to
- Last updated 4 years ago
- Ramón San Félix Ramón replied 4 years ago
Hi
I'm using PowerScript Dynamic DataStore like this:
//----------------------------------------------PowerBuilder Example ------------------------------------------
long ll_row, ll_rowCountString ls_sqlString ls_Syntax, ls_error, ls_clienteDataSt...
Datastore RESTClient Object Submit Function Response is slow (then fast!)
- Resolved
- Issue
- Last updated 4 years ago
- Jim Nesbitt replied 4 years ago
I'm using Powerbuilder 2019 R2 Beta and SnapDevelop.
I migrated a simple application to PB2019R2 and then built a Web API in SnapDevelop following the instructions in
https://docs.appeon.com/appeon_online_help/dwconverter2019r2/CRUD_Operations_wit...
Passing IDataUnPacker object to API service in unit test
- How-to
- Last updated 4 years ago
- Thomas Rolseth replied 4 years ago
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 ...
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...
Sorting, filtering, and paging - ASP.NET MVC with SnapObjects
- How-to
- Last updated 5 years ago
- Michael Kramer replied 5 years ago
How to implement sorting, filtering and paging to my asp.net mvc controller with snapdevelop, in order to use this kind of RESTFUL syntaxe url:
http://www.example.gov/api/v1/magazines.json?year=2011&sort=desc
There is plenty of tutorial on how ...
Enhance JSON response from asp.net web service
- Resolved
- How-to
- Last updated 5 years ago
- Olivier PAVLIN replied 5 years ago
Hi there,
In my MVC .Net Web API i have this auto-generated GET function in my controller which works fine and return the list of all the elements in my table (SimpleJson.png).
[HttpGet][ProducesResponseType(typeof(IEnumerable<Ds_Invit_Sydrtcml&...
ASP.Net Web API, RetrieveOne method with string ID
- Resolved
- How-to
- Last updated 5 years ago
- Olivier PAVLIN replied 5 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 ...
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' ...
I see that you use ILogger to capture errors in some of you PowerBuilder.Data objects. I have a couple of questions. I am not sure how to use this method other than the method you show in one of your examples.
var factory = new LoggerFactory(); fa...
Caching a IReadOnlyDataObject created by ParseDataObject
- How-to
- Last updated 5 years ago
- Logan Liu @Appeon replied 5 years ago
Is there a way to place in the cache the IReadOnlyDataObject created by DataObjectFactory.ParseDataObject so it can be available for instantiating a DataStore object?
As far as I can tell from the documentation, instantiating a DataStore depends on ...
snap developer: how to get datastore column names and data-types
- How-to
- Last updated 5 years ago
- paulo gomes replied 5 years ago
Hi All,
We are migrating a NVO to REST C# Web API. One of the methods that has to be migrated gets as argument a datastore and return, by reference, two (02) string arrays: column_names and dataTypes_names
The PB method get the number of datastore ...
Migrate NVOs from EAS web app to REST Web API with PB 2019/Snap Develop
- Advice
- Last updated 5 years ago
- Ricardo Jasso replied 5 years ago
Hi all,
We are evaluating the efforts to migrate PB NVOs from an EAS web app to REST API using Snap Develop and PB 2019.
We already migrated few methods using the IDataStore object. However we noticed that several methods were missing from the orig...
- Page :
- 1