Discussions tagged DataStore
We have a datastore using an Oracle Stored Procedure Update. For the insert stored proc, one of the columns is mapped to an output argument, to capture the new transaction sequence ID generated by the stored procedure. Client Server app correctly pop...
Hello everyone.
I need help, I have a powerbuilder 2022 and it is mounted on a server with windows server 2019, all my projects are set to run on power server and use an IIS server to publish it, so far everything works fine but, when my users star...
Im making an app using multithreading and I would like to keep track of row count for my data window Retrieve() 's. Is it possible? To my understanding, RetrieveRow() event in Datastore is what keeps the count of rows being retrieved, but how can I s...
PowerBuilder 2019 R3 build 2728
Windows 10
I am having a silly isue that is probably all my fault, but I can't seem to work it out. I am exporting four datastores to an XML file using this command
ads.SaveAs(as_file, XML!, true, EncodingU...
Dear Support Team,
I have created the .Net Assembly project in Power Builder which will generate the DLL as an output and same DLL I am referencing in my another .Net Program. In my Power Builder .Net Assembly project I have used the DataStore to lo...
This is in PB2019 Build 2082, using the Firebird SQL Database.
We have one user’s database from our application that is behaving extremely strangely for certain SQL retrieved through a datastore created at runtime (actually, our inherited datastore ...
Hi guys,
We have a very strange problem. Our big application written on PowerBuilder, C#, VB and works with Oracle and Mss databases.
The save process to database going by command dscontrol.Update() through array of datastores control. The problem ...
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