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

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