Tip Bank

DevX - Software Development Resource

DECODE Function

Question: As I understand it, the DECODE function or procedure is available in XPS 8.3 and IDS 2000 9.2 or above. Is it available in 7.2x? If not, is there

DevX - Software Development Resource

Moving Mailboxes Correctly

Question: We have set up a second Exchange server within our site and moved 170 mailboxes over to it. However, it does not appear that the mailbox data has transferred.

DevX - Software Development Resource

Disabling Function Keys in an Application

Question: How do I disable function keys in an application? Answer: You can disable function keys by using the ON KEY LABEL command. Putting an asterisk (*) after the key

DevX - Software Development Resource

Mailbox Names with Different Domains

Question: I have a problem creating the same mailbox names with different domain names at one server (one site). How can I go about doing that? Or can I only

DevX - Software Development Resource

Getting the Address of a Function

Question: In VB, I can use the function AddressOf. It is the return address of function WNDPROC. Is there a similar function in PowerBuilder? Answer: In PowerBuilder you cannot get

DevX - Software Development Resource

Removing Characters from Strings

Question: I need to delete certain characters from a string, particularly a money field in the format 99,999,999.99. Is there an easy way to delete the commas and period from

DevX - Software Development Resource

Moving from Fox for DOS to Visual FoxPro

Question: I would like some Visual FoxPro application as a starting guide in VFP 6. I’m finding it hard to add commands using a form. For example, I want to

DevX - Software Development Resource

Porting from Oracle to Informix

Question: We have an existing application, which has been developed using ASP. The database being used is Oracle 8. Now, for a different customer, we want to port this application

DevX - Software Development Resource

Building Crosstabs

Question: How do I build crosstabs in Visual FoxPro? Answer: Visual FoxPro has a wizard that helps you create a Crosstab query. From the Wizards submenu on the Tools menu,