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

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