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

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