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

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