Tip Bank

DevX - Software Development Resource

Sorting by Year From a Date Column

Question: How do I sort by year a datawindow that already sorts in ascending or descending? (The field is in mm/dd/yy format.) Answer: Create a computed column on the datawindow

DevX - Software Development Resource

Activating Trim Trailing Blanks

Question: How do I activate trim trailing blanks from No to Yes? Answer: The SET ANSI PADDING statement controls the setting you are referring to. When a table is being

DevX - Software Development Resource

Writing Null Values to a File

Question: What’s the best way to write null values in file, then read them back from file? Answer: If you are using the built-in PowerBuilder functions to read the data

DevX - Software Development Resource

Renaming a SQL Column

Question: Can I rename a SQL column without making a new table or relying on GUI? Answer: The ALTER TABLE ALTER COLUMN SYNTAX supports either dropping an existing column or

DevX - Software Development Resource

Error When Starting IDS

Question: I just installed IDS 7.31.uc5 on HPUX 11. When I try starting it up (oninit -iy) I get the following error: unable to open input file ‘s’unable to open

DevX - Software Development Resource

Product Compatibility

Question: How can I find out which Informix products/versions are compliant/compatible with other Informix product/version combinations? Answer: Try calling your local Informix office. They may have something. As a general

DevX - Software Development Resource

Quickly create HTML tables from an ADO Recordset

The ADO Recordset object exposes the GetString method, which returns the values in the Recordset into a formatted string. Here’s its syntax: res = GetString([StringFormat As StringFormatEnum = adClipString], _

DevX - Software Development Resource

Print the WebBrowser’s contents

The WebBrowser control doesn’t expose any method to directly print its contents. You can achieve this effect through the ExecWB method, by passing the OLECMDID_PRINT constant in its first argument: