Discussions tagged Retrieve
I'd like to know how I can retrieve the license if I lose the machine that registered the license.
Please reply.
Thank you....
Events in a transaction object (n_tr) like retrievestart/-end for logging purposes.
- How-to
- Last updated 8 months ago
- Olaf Bönning replied 8 months ago
I like to log the begin and the end of an SQL statement because i like to measure the time the SELECT needed.
In datawindows i have the retrievestart and retrieveend events where i can exactly do what i wish to do.
In embedded SQL i use SQLCA which...
Retrieve function throws error 'Invalid Character value for cast specification'
- Resolved
- How-to
- Last updated 10 months ago
- Benjamin Gaesslein replied 10 months ago
Hello everyone, I have a problem when I am debugging my code, it turns out that the code leads me to display an error message that I am getting after the expected error message. When I press my Search button I am getting the following error: "Invalid...
RestClient code conversion error or silent crash with larger datasets
- Issue
- Last updated 1 year ago
- Logan Liu @Appeon replied 1 year ago
Hello,
I'm using PB2021 Build 1509, and we utilize ASP .Net Core 3.1 REST api's for all data access. Those were built with SnapDevelop and .Net Datastores. It has been working relatively well until more recently when several users started trying to...
Most of my career I have had to maintain some other developer(s) code. With that in mind, I attempt to follow PowerBuilder's documented approaches for all the code I write. I have, however, seen code like what is shown below that works in a client/...
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...
How to use SetSqlSelect on a report using SnapDevelop
- How-to
- Last updated 2 years ago
- Olan Knight replied 2 years ago
We are migrating an existing PowerBuilder application to make use of SnapDevelop to handle the datawindow calls. Our system has a reporting area, where we give the user a selection of criteria they can use to customize the report. As the current sy...
Hi Friends,
I've got a datawindow that I use for query... in my code, I stop after every 250 rows and ask user if they want to retrieve more.
I was editing the datawindow, and it automatically retrieves EVERYTHING... over 200,000 rows. The message...
We have a customer running our PB 2017 app in a Citrix Environment. They experience random crashes when generating a document for preview. By adding writes into the code to a log table on their system, we have been able to determine exactly where the...
DB2 TimeStamp Retrieval Argument
- How-to
- Last updated 3 years ago
- Chris Pollach @Appeon replied 3 years ago
Hi all,
I have a program that must be able to retrieve data based on the previous day's "Approved Date." I am using PowerBuilder 2017 and I am accessing a DB2 database. The only retrieval argument in my query is of DateTime type (see query attache...
Local datastore - retrievestart
- Resolved
- How-to
- Last updated 3 years ago
- René Ullrich replied 3 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....
Good day
How can I retrieve data from one window to another like data that was filled front person to be retrieve by second person and edit is admin and nurse and create report using grid that can combined three tables to make one table which is r...
Hi all,
We have a master table with detail records. Each detail record has another level of detailed records.
Our current print function is a retrieve of a composite datawindow. Printing is done for each master table record , but also reprintin...
- Page :
- 1