Tech Articles


Updating the Datawindow Object Definition


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.

integer li_file, li
string ls_old_syntax, ls_importsyntax
// old datawindow syntax saved to a file
ls_old_syntax = 'C:\temp\d_oldstuff.txt'
// open and read the file
li_file = Fileopen(ls_old_syntax, TextMode!)
Filereadex(li_file, ls_importsyntax)
// remember to close the file
FileClose(li_file)
// check version of ls_importsyntax
IF POS(ls_importsyntax, 'release 12.5;') > 1 THEN
   // its already new, leave it alone        
ELSE
   // dw_new is object on the window
   dw_new.reset()
   dw_new.dataobject = ''
   // create the new datawindow object from the old syntax
   li = dw_new.create(ls_importsyntax, ls_err) 
   // now get the new syntax
   ls_new_syntax = dw_new.describe("DataWindow.Syntax")   
END IF

Now you can do whatever you want with the new syntax.

Comments (0)
There are no comments posted here yet

Find Articles by Tag

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