Tip Bank

DevX - Software Development Resource

Moving the Master and MSDB Databases

Question: How can I move the master and msdb database devices to another disk in SQL Server 6.5? Can I mirror them and then unmirror them, swapping to the mirror

DevX - Software Development Resource

SQL Query in FoxPro Reports

Question: I am doing calculations in reports using SQL and FoxPro 2.6 for Windows. My SQL query works fine, except for one thing. I want to display information in the

DevX - Software Development Resource

Message Box for Unsaved Changes

Question: How do I get a message box to appear if users have not saved their work, asking them if they want to save their work? (I am using PowerBuilder

DevX - Software Development Resource

Unable to Update Cursor

Question: When I try to build an app (.exe) I get the error message “Cannot update the cursor.” All the prg, menu, and forms seem to work (i.e., compile with

DevX - Software Development Resource

Highlight the contents of a control on entry

You probably already know that you can highlight the contents of any textbox by adding two lines of code in its GotFocus event: Private Sub Text1_GotFocus() Text1.SelStart = 0 Text1.SelLength

DevX - Software Development Resource

Suppress TreeView’s tooltips

By default, all TreeView controls whose version number is 4.70 or higher display the text of the node under the cursor if the node itself isn’t completely visible. You can

DevX - Software Development Resource

Build a simple browser for icons

Winodws uses a special browser to show all icons contained in a file and offers the end user the possibility to choose an icon from it. You can add this

DevX - Software Development Resource

Quickly clear a portion of an array

The fastest way to clear an array is to ReDim (if the array is dynamic) or Erase it (if the array is Static). However, if you want to clear a