Tech Articles


The dwSyntax Tool


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.

Image

 

From the tool’s menu, navigate to Syntax>Modify>Attributes.

Image

 

From the “Object” DDLB, choose “ComputedField”.

Image

 

From the “Attributes” listbox, select “Expression”.

Image

 

You’re then presented with two versions of the syntax’s template; one for Modify() call usage, the other if you prefer dot notation. Copy/paste the template syntax and replace the bracketed portions as appropriate with explicit values or with reference variables.

DWSyntax offers this functionality without breaking a sweat. To really start utilizing the power of the tool, browse its “create” syntax capabilities…

Image

 

…or its GUI have you build SyntaxFromSQL() syntax from scratch…

Image

 

If you’re relatively new to PowerBuilder, you may find this tool to be instructive. If you’re an experienced PowerBuilder developer, I hope you enjoy the productivity this tool will provide.

Comments (0)
There are no comments posted here yet

Find Articles by Tag

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