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

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