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

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