Tech Articles


Calling SHGetKnownFolderPath from PowerBuilder


Up through Windows XP, if you wanted to get the physical location of certain defined folders (e.g. the users Documents folder), you would use the SHGetFolderPath function in the Windows API.  Roland Smith has examples of using that on his Topwiz Software site.  That function continues to work in later versions of Windows, although it's basically a wrapper for the SHGetKnownFolderPath function.

SHGetFolderPath uses CSIDL values, whereas SHGetKnownFolderPath uses KnownFolderID GUIDs.  One difference is that there are a lot more KnownFolderIDs than there are CSIDLs.  That means some of the defined folder locations you may want to get the physical location for can't be accessed through the older SHGetFolderPath method.  And that's exactly the situation I ran into.


I needed to find the user's Downloads folder, and there isn't a CSIDL value for that.  So, I needed to see how to call the SHGetKnownFolderPath function from PowerBuilder.  As with many OLE and Windows API calls, it can save you a lot of time if you can find some Visual Basic code that does what you need to do, and you can convert the syntax.  And fortunately, I found some that did this.



So, with a little tweaking, I ended up with this:

//Local External Functions:

 Function Long CLSIDFromString (ref string lpszGuid, ref blob pGuid ) Library "ole32"   
 Function Long SHGetKnownFolderPath( ref blob nFolder,int dwFlags,uLong hToken , ref long pszPath) LIBRARY "Shell32.dll"   
 Subroutine CopyMemory ( ref String pDest, long pSrc, long ByteLen) Library "kernel32" Alias For "RtlMoveMemory"   
 Subroutine CoTaskMemFree ( long hMem) Library "ole32"   
 Function Long lstrlenW ( long ptr) Library "kernel32"   

//PowerScript

 blob     guid  
 long     ll_rc, ll_folderpointer, ll_folderlen  
 string ls_folder, ls_folder_id  
 ls_folder_id = '{374DE290-123F-4565-9164-39C4925E467B}'  
 IF CLSIDFromString (ls_folder_id, guid ) = 0 THEN  
      IF SHGetKnownFolderPath ( guid, 0, 0, ll_folderpointer ) = 0 THEN  
           IF ll_folderpointer <>0 THEN  
                ll_folderlen = lstrlenW ( ll_folderpointer )  
                If ll_folderlen <> 0 THEN  
                     ls_folder = Space ( ll_folderlen )                      
                     CopyMemory ( ls_folder, ll_folderpointer, ll_folderlen * 2 )  
                END IF  
           END IF  
           CoTaskMemFree ( ll_folderpointer )  
      END IF  
 END IF  
 MessageBox ( "Downloads Folder", ls_folder )  


Hope you find that useful as well.

 

 

 

 

 

 

Comments (1)
Tuesday, Sep 23 2025

I tried this with PB 2022 Build 1892 and it works the first time. The second call causes it to hang for a few seconds and then it aborts.

0

Find Articles by Tag

Android Debugger PBDOM Testing Debug Authorization Database Connection Database Profile Text Git .NET Std Framework Model JSON .NET DataStore Linux OS Source Control SqlExecutor Configuration Event Handler Installation Mobile OAuth Syntax 64-bit Database OLE CoderObject Database Table Schema Export JSON BLOB JSONParser Data Service PDF 32-bit REST Web API iOS NativePDF Encoding Windows 10 Icons HTTPClient Debugging External Functions Azure TFS COM Filter JSONGenerator WebBrowser PostgreSQL Error Variable PowerBuilder Compiler SnapObjects GhostScript Icon Window Branch & Merge TreeView SDK Transaction UI Script Import JSON Event IDE DataWindow JSON RibbonBar SOAP Visual Studio Interface SQL Server Source Code PowerBuilder (Appeon) PowerServer Web DataWindow XML Bug SVN Stored Procedure Migration ODBC Class Design RichTextEdit Control SQL Oracle C# Graph PBVM Repository InfoMaker Elevate Conference MessageBox PDFlib SqlModelMapper Windows OS Database Object RibbonBar Builder TLS/SSL Authentication Automated Testing Array Application API PowerBuilder Outlook Open Source License WinAPI Excel DLL .NET Assembly DevOps File CI/CD Database Painter Jenkins RESTClient Charts UI Modernization OrcaScript TortoiseGit Platform Trial Expression Database Table Data PowerScript (PS) Deployment Performance Database Table Import DragDrop PBNI PowerServer Mobile PFC CrypterObject Resize UI Themes DataType Export PostgreSQL ODBC driver Messagging Web Service Proxy Sort Encryption OAuth 2.0 Menu ActiveX SnapDevelop Event Handling Validation