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

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