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....
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...
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...
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/...
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...
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...
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...
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