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

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