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

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