Tip Bank

DevX - Software Development Resource

Folder Removal

Question: How do you delete folders like Front Page, Outlook Express and the like? Answer: Well, from the command line you have several options. You can use DelTree to remove

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