Tip Bank

DevX - Software Development Resource

dBASE IV’s ODBC-compliance

Question: Is dBASE IV an ODBC-compliant database? Answer: ODBC compliance is (or was) a specific set of functionality expected of a back end being mediated by an ODBC driver program

DevX - Software Development Resource

Very Slow Queries

Question: I’m working on a database built for reporting purposes. Tables are updated once a month. Reporting queries are taking many hours to complete, some up to 26 hours. The

DevX - Software Development Resource

Finding the Max and Min in Consecutive Data

Question: I have a table in Microsoft Access 97 with sales info in the following format: Prod_Type, Box_Number, Cust_No.FA1111 , 400400 , 40010FA1111 , 400401 , 40010FA1111 , 400402 ,

DevX - Software Development Resource

Memo Fields in FoxPro for DOS

Question: I am working on a FoxPro for DOS system and I am using the COPY TO function to export the DBF to a (text or Microsoft Excel) file. However,

DevX - Software Development Resource

Exchange/Outlook Client Lockup

Question: I’ve got a mailbox on our Exchange 5.5 server that locks up Outlook 2000 client after running for a period of time. I’ve tried it on multiple machines so

DevX - Software Development Resource

Exchange Rules Limit

Question: I am trying to set up 87 rules for a specific mailbox. Problem is, I get an error message stating there are too many rules. Is there a limit

DevX - Software Development Resource

Selecting Rows Based on a Distinct Value

Question: I have a table in my SQL 7 database that, among other values, contains e-mails. There are duplicate e-mail values in this table. I want to extract one record

DevX - Software Development Resource

Exchange Event Service

Question: I have nine Exchange 5.5 post offices. Most started as 5.0 post offices, which were then upgraded to 5.5 with SP1. The newer post offices have a “Microsoft Exchange

DevX - Software Development Resource

Exchange Server 5.5 Messages to AOL Recipients

Question: None of the clients using Exchange e-mail can successfully send an e-mail message to an America Online recipient. We do not get an undeliverable message from the Exchange Server.