Tip Bank

DevX - Software Development Resource

Overriding a Deprecated Function

Question: I have a class that extends one class and implements an interface.The interface requires a getName() method.At the same time the class I am extending has a getName() functionthat

DevX - Software Development Resource

Finding the Identity Fields

Question: I am working on a database program that will insert random data into all fields in the database. What the program is supposed to do is look for field

DevX - Software Development Resource

Sending Internet E-mail

Question: I am trying to send e-mail from my PowerBuilder app to an e-mail address that is not in my address book; it’s an Internet e-mail address. I do not

DevX - Software Development Resource

yymmdd-to-yyyymmdd Date Format

Question: Is there a way to automatically convert the date format from yymmdd to yyyymmdd? Answer: Yes there is. Check out the STYLE argument of the CONVERT function, which displays

DevX - Software Development Resource

Changed Permission Properties

Question: When I do a property box on a file/directory, the Security sheet changes from the normal (NT4, SP0) one to a new one. Can you explain this? (I have

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

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