Here is a simple modification to the PFC string service (n_cst_string) which will parse out an array of any datatype and returned a delimited string of the contents. The new method is a polymorph of the existing of_arraytostring. public function long of_arraytostring (any aa_array[], string as_delimiter, ref string as_string) // convert array to string array…
- .ics
- .NET
- Active Directory
- C#
- Citrix
- COM
- Connection string
- Dashboard
- datawindow
- debug
- disaster prepardness
- ETL
- EVENTCREATE
- Facsys
- frogs
- games
- MDI
- mySQL
- ODBC
- OLEDB
- Outlook
- parenting
- PB.INI
- pfc
- Powerbuilder
- Powerbuilder OLE
- Powerbuilder Tutorial
- programming
- regasm
- REPORTEVENT
- SCOPE_IDENTITY
- source control
- SQL Anywhere
- SQL Native Client
- SQL Server
- TWAIN
- Uniface
- Visual Basic
- web service
- Windows API
- Windows Event Log
- Windows settings
PowerBuilder – PFC String service extension
PowerBuilder – PFC String service extension - the full story »
Sequence Numbers in SQL
Here is a link to a very good article on SQLServerCentral.com showing a technique to re-sequence items via a database stored procedure rather than on the client. It’s pretty straight forward and solves a fairly common issue I’ve addressed several times in PowerBuilder over the years.
PowerBuilder ‘Gotcha’ – Autoscript and Clipboard
Ah, you finally gotten the time to refactor some code or maybe even clean up some proof of concept to move it into an actual application and now it’s time to make the stuff more ‘Object Oriented’. You look in your Open method and it’s full of various stuff. You create a new method to…
Update Columns in Database
It’s pretty common to want to update a column (or several columns) in one table with the value(s) from another table. Here is how to do it: UPDATE Table SET Table.col1 = other_table.col1, Table.col2 = other_table.col2 FROM Table INNER JOIN other_table ON Table.id = other_table.id WHERE … The structure of this syntax is always something…
PowerBuilder – Adding a Structure to an NVO
It is possible to define a structure within an non-visual object. You can view/ or edit the source of the nvo and insert the structure definition directly: global type nvo_case from nonvisualobject end type type str_test from structure within nvo_case end type end forward type str_test from structure string as_parm1 string as_parm2 end type global…
PowerBuilder – Add /Remove a Font at Runtime
Here is a way to add (and remove) a font to the user’s machine at runtime. You can also use this to check if a user has a particular font installed since the code also shows how to list all the installed fonts (need MS Word for this). Way back in my PB5 days I…
PowerBuilder ‘Gotcha’ – Window Hangs when Opened
So your working on some prototype for a proof of concept and are banging away at your code. Cut paste, snip, add error checking for just one case, add another control, etc., etc., and etc. You run the application, your window loads, and then things hang. You check the code, you check the database, you…
PowerBuilder – Next Key Service
As an extension of the next key stored procedure article, here is a pretty easy to implement a next surrogate key service to use with the PFC. If you don’t use the PFC it is still fairly easy to use with some modification. You can use this service anytime you want to get a sequential…
PowerBuilder – Move Frequently Chosen Items to Top of DropDownDataWindow
I’m looking at an application which basically records demographic information for a population. One of the fields listed is ‘primary language’ which has a typical dropdowndatawindow interface. I look at the options and BAM!, a huge alphabetical list (including Esperanto!). Now this application is generally used in the US so my guess is at least…
Next Key Service for Database tables
This provides for an easy way to generate key values for tables in a database when you don’t want to use a system generated value (like an IDENTITY column). The example is for MS SQLServer 2000 but could be adapted to any database which supports stored procedures. Note that this service assumes the key value…
