Tip Bank

DevX - Software Development Resource

Asynchronous Processing

Question: I have written an ActiveX EXE. that handles Batch Reporting requirements on a large amount of data. Even though it is an Out-of-Process “server”, it still seems to execute

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

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