devxlogo

Tip Bank

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

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

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

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

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

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

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

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