Discussions tagged DataStore
Hi we are creating charts in WMF format, when using a virtuel PDF printer the charts looks great, but when using PDF Lib (PDFNative) it looks really bad quality.
Why is this the PDFNative not creating good quality of the images? Se attahced files.
...
Change background.transparency in nested report object - PB2022 R3
- How-to
- Last updated 7 months ago
- Mark Goldsmith replied 7 months ago
I have been tasked with adding a watermark to printed documents.
Before printing, I copy the dataobject into a local datastore, copy the data (RowsCopy), add the watermark to the background (Modify("CREATE...")), and then make the background for ea...
datastore don't print with colors
- How-to
- Last updated 1 year ago
- Thierry Del Fiore replied 1 year ago
Good morning,in our application we need to print in the background and the datawindow used contains colored text objects.Until Release PowerBuilder 2022 with runtime 22.0.0.1900 everything worked perfectly.Now we have moved on to Release PowerBuilder...
PowerBuilder 2019 R3 - Build application is crashing.
- Issue
- Last updated 1 year ago
- ALEXANDER TAPIA replied 1 year ago
Our PB windows application was developed in PB version 8 and it has been migrated to PB 2019 R3. The PB 8 build it not crashing but when it was migrated to PB2019 R3, we encountered crashing issue during its runtime. I did a debugging and found out t...
Datastore & millions of rows
- Resolved
- Advice
- Last updated 1 year ago
- Brage Mogstad replied 1 year ago
Hello,Anyone managed to work with "big data" in PB & Adaptive Server Anywhere? I'm using PB 19 and 32-bit ODBC.So far I've only been able to solve manipulation of data with either SQL statements in string & Execute immediate, or simply trigge...
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...
Disconnection problems PowerServer 2022
- Issue
- Last updated 1 year ago
- Armeen Mazda @Appeon replied 1 year ago
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...
How to keep track of row count in multithreading
- How-to
- Last updated 2 years ago
- Chris Pollach @Appeon replied 2 years ago
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...
ImportFile for XML file returning -4
- Resolved
- How-to
- Last updated 2 years ago
- Aron Cox replied 2 years ago
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...
.Net Assembly required DLLs not found
- Resolved
- How-to
- Last updated 2 years ago
- Mark Lee @Appeon replied 2 years ago
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...
Error -15448 return from Retrieve() called on created DataStore
- Resolved
- Issue
- Last updated 2 years ago
- Daniel Vivier replied 2 years ago
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 ...
Save problem through DataStore command .Update()
- Advice
- Last updated 2 years ago
- Benjamin Gaesslein replied 2 years ago
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...
PB 2019 Crash on datastore reset with MS Server 2019 and Task scheduler
- Issue
- Last updated 3 years ago
- Chris Pollach @Appeon replied 3 years ago
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...
Using the Microsoft Text Driver ODBC driver to read text files
- Resolved
- How-to
- Last updated 3 years ago
- Steen Jakobsen replied 3 years ago
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...
Error using DataStore into user function
- Resolved
- Issue
- Last updated 3 years ago
- John Fauss replied 3 years ago
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...
How to have a single function works on both a datawindow and a datastore?
- Resolved
- How-to
- Last updated 3 years ago
- Benjamin Gaesslein replied 3 years 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 4 years ago
- René Ullrich replied 4 years 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 ?
- 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...
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...
- Page :
- 1