Tip Bank

DevX - Software Development Resource

Animated Image Bitmaps

Question: How do I animate an image in PowerBuilder? Someone told me I would have to split the gif into frames and then set up a timer. Answer: You can

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

Register and unregister type libraries

All COM-oriented VB developers know how to register and unregister an ActiveX DLL, using the REGSVR32 utility. However, there is no such an utility to register and unregister a type

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], _