- You are here:
-
Home
-
Articles & Blogs
-
Tech Articles
- PowerBuilder
Tech Articles
- Details
- Written by John Strano
- Category: PowerBuilder
- Hits: 1376
User Rating: 4 / 5
Thank you Sandy Barletta!
Just after the earth began to cool (I think it was in the PB3 time frame), I discovered the DWSyntax tool created by Sandy.
‘Round about that time I had been exporting DataWindow objects (this was before “edit source” folks) in order to get functional syntax for my dwModify() calls. Lo’ and behold I discovered this nifty GUI that would allow me to browse the dwDescribe(), dwModify(), SyntaxFromSQL() argument syntax for any DataWindow item or for the DataWindow object itself.
Fast forward to the present day. Let’s say you need to change the expression of a computed field at runtime, much as I illustrated in another tip on dynamically “creating” DataWindow groups.
From the PowerBuilder IDE, open the “New” dialogue. Select the “Tool” tabpage, and then select the “DataWindow Syntax” item.
- Details
- Written by John Strano
- Category: PowerBuilder
- Hits: 2217
User Rating: 4 / 5
Here’s a DataWindow tip…and a half.
Unless you want to dynamically build a DataWindow object from scratch at runtime (it’s do-able…but quite involved), there’s no direct way to create a group for a DataWindow object in an ad hoc manner. Here’s a workaround.
First, insert a computed field in an extant DataWindow object and give it an expression that’s an empty string. For the sake of this tip the computed field’s name will be “dynamicgroup”.
- Details
- Written by Matthew Balent
- Category: PowerBuilder
- Hits: 1101
User Rating: 3 / 5
I'm doing some work on an application to aid in the mass update of various datawindow attributes. It's not rocket science since you are dealing with a series of text files and doing some basic 'find and replace' operations. However, if you have ever worked on a project which has been around for a while you will notice that datawindows do not get 'migrated' when you upgrade to a newer version of PowerBuilder; the export syntax remains at the version in which the thing was last modified and saved.
Now you might think that using the LibraryExport and LibraryImport methods will do the trick but you would be mistaken. A newly imported datawindow object keeps the same version as when it was exported.
To accomplish the task you need to use the datawindow CREATE method.
- Details
- Written by Roland Smith
- Category: PowerBuilder
- Hits: 1589
User Rating: 5 / 5
I needed a way to build a string in a loop for import into a DataWindow but speed was important.
I created an object with functions that allows for string concatenation using a blob variable that is allocated once and no external function calls are needed.
To test my object I concatenated a string of 445 characters to a new string 500 times. The standard method seen here took 320 milliseconds:
ls_data = "-start-"
For li_idx = 1 To 500
ls_data = ls_data + "-" + String(li_idx) + "-"
ls_data = ls_data + is_string
NextThe test using my object seen here took only 20 milliseconds:
n_stringclass sc
sc.alloc(225000)
sc.copy("-start-")
For li_idx = 1 To 500
sc.concat("-" + String(li_idx) + "-")
sc.concat(is_string)
Next
ls_data = sc.value()- Details
- Written by Roland Smith
- Category: PowerBuilder
- Hits: 1413
User Rating: 4 / 5
I had a need to sort a string array and I found some code on Real Gagnon’s website that sorted numbers by creating a DataStore/DataWindow on the fly and used that to sort. Someone added a comment that for strings you need to define the column as char to avoid errors. I improved the code by adding a loop to determine the longest string in the array and using that when defining the DataWindow source.
public function boolean of_sortarray (ref string as_array[], string as_order);// —————————————————————————–
// SCRIPT: of_SortArray
//
// PURPOSE: This function sorts the passed array using a DataStore created
// on-the-fly.
//
// This is based on code from Real Gagnon:
// http://www.rgagnon.com/pbdetails/pb-0114.html
//
// ARGUMENTS: as_array – Array of values to sort
// as_order – The sort order:
//
// Order value Resulting sort order
// ———————— —————————
// a, asc, ascending, ai, i Case-insensitive ascending
// d, desc, descending, di Case-insensitive descending
// as, s Case-sensitive ascending
// ds Case-sensitive descending
//
// DATE PROG/ID DESCRIPTION OF CHANGE / REASON
// ———- ——– —————————————————–
// 09/27/2016 RolandS Initial Coding
// —————————————————————————–
- Details
- Written by Roland Smith
- Category: PowerBuilder
- Hits: 1175
User Rating: 3 / 5
I was wondering if it was possible to have a MessageBox that could automatically close after a set period of time so I did some searching and found that you can!
In Windows XP, Microsoft added a function MessageBoxTimeout but didn’t document it. The normal MessageBox function was changed to call MessageBoxTimeout passing the maximum value for the timeout. The maximum timeout value equates to about 49 days.