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

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