Discussions tagged DataStore

Hi, I have found a strange behavior of PB when I use a DataStore into a user function. If I run the projet directly from powerbuilder the function returns the info correctly, but if I run from .EXE it does not work as expected. I prepared and attac...
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...
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....
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...
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...
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...
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