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

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