Discussions tagged DataStore
How to have a single function works on both a datawindow and a datastore?
- Resolved
- New
- How-to
- Last updated 2 days ago
- Benjamin Gaesslein replied 4 hours ago
Hello (and Happy New Year),
We have a simple function that iterates over the rows of a datawidnow and fill some objects from some of the items in the row. This function looks like the following:
public subroutine fill_recipe_components(datawindow a...
Local datastore - retrievestart
- Resolved
- How-to
- Last updated 3 months ago
- René Ullrich replied 3 months ago
Hello,The case is this: for every row in table A- I want to updates these records in table B, which points on A.ID What I've managed to do: - for ll_i = 1 to dw_a.RowCount() if in b exists records for a get records from b do ds_b ds_b.update ds_b....
How to replace "SqlExecutor.SelectToStore" method ?
- How-to
- Last updated 3 months ago
- Ramón San Félix Ramón replied 3 months 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...
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...
Datawindow/Datastore - Insert/Update if exists problem
- Resolved
- How-to
- Last updated 1 year ago
- Michael Kramer replied 1 year ago
I have to modify exisiting data import function which works IN LOOP like:get data from text> put into datastore (via INSERT ROW(0) > update ( which causing insert into table....).my goal is to modify it to work like:add, new column - operationif op...
I was working with the Create Web API tutorial and tried to add another call for another table other than Departments. I created a Controller for Persons and all subsequent items, which would take the RetrieveOne for an int on the AdventureWorks2017...
DW XML Import Templates
- How-to
- Last updated 1 year ago
- David Peace (Powersoft "The PowerBuilder & C# People") replied 1 year ago
Hi All,
Hoping some of the gurus out there can help with this.
I am currently trying to make use of the XML Import Templates on Datawindows in an existing legacy project. I have previous experience of using PBDOM and parsing XML file via large amo...
SetTransObject fails with a -1, PB 2017 R3 1880
- Resolved
- Issue
- Last updated 1 year ago
- Chris Pollach @Appeon replied 1 year ago
Using PowerBuilder 2017 R3 Build 1880. Nothing .NET, using standard PowerBuilder.
ids_accs = CREATE DataStore
ids_accs.DataObject = "d_users"
ii = ids_accs.SetTransObject(SQLCA)
SetTransObject is returning -1 at runtime. If running in the ID...
- Page :
- 1