Discussions tagged DataStore

Just posting some advice in case someone else stumbles onto an issue like this. The SQLSTATE = 42000 a catch all basin for everything under the sun from Microsoft can lead you in circles. Here's another gotcha. When using a PB 2019 R3 application w...
Hi PB users, We try to solve a crash problem with PB 2019 R2, that occurs in the constructor event of a user object instantiated by a window running with MS windows server 2019 and task scheduler with "Run whether user is logged on or not" mode. Wi...
I need to read some data from tab-separated text files with a row of column headers, where I know that certain column names will always be there, but don't know whether they will always be in the same order, or what other columns might be there. So l...
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