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

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