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

Question: When connecting to an Informix database using Visual InterDev and SCO Retriever 32 ODBC, I can see tables and column names but when I try to look at data,

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,

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

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

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

Question: Define a Web database, please. What are the advantages and disadvantages? How do I connect different software to the Web? Answer: A Web database is any database that you

Question: When e-mail messages are not being delivered and the MTA queue is backed up and all the services is running, what could be another step I can take to

Question: How do I display the rows of a table’s contents vertically? I want to list the tracks of a CD, LP, etc. from their table at the bottom of

Question: I am returning a resultset from an Informix Stored Procedure to VB6 via ODBC and ADO. Is there any way of returning the field names? At this point I

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

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.

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

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

Question: We are getting a divide-by-zero error running FoxPro for Windows 2.5 on a Novell server on the network on an NT workstation. Can I use the patch in version

‘ Replace the last occurrence of a stringFunction ReplaceLast(Expression As String, Find As String, ReplaceStr As String, _ Optional Compare As VbCompareMethod) As String Dim i As Long i =

‘ A replacement for the Split function under VB4 and VB5” Note that the return value is a Variant that contains’ an array of stringsFunction Split(ByVal Text As String, Optional

‘ A replacement for the StrReverse function for VB4 and VB5Function StrReverse(ByVal Text As String) As String Dim length As Long, index As Long length = Len(Text) StrReverse = Space$(length)

‘ Join variant that works with’ bi-dimensional arrays of any type’ and that encloses string values between quotes” ARR is the 2-dimensional array whose element must be joined’ ROWSEPARATOR is

‘ A replacement for the InStrRev function under VB4 and VB5” NOTE: uses the StrReverse functionFunction InStrRev(ByVal Text As String, Search As String, _ Optional ByVal Start As Long =

‘ A replacement for the Join function under VB4 and VB5Function Join(arr() As String, ByVal Delimiter As String) As String Dim index As Long For index = LBound(arr) To UBound(arr)

‘ A Split variant that parses a string that contains’ row and column separators, and returns a 2-dimensional array” the result String array has a number of columns equal’ to

‘ Join variant that works with arrays of any type’ and that encloses string values between quotes” ARR is the array whose element must be joined’ SEPARATOR is the separator

‘ A replace for the Filter function under VB4 and VB5” Note that the source array is modified. For this reason’ this is declared as a Sub rather than a