Tip Bank

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 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

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

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

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

PST File Corruption

Question: My computer froze and when I restarted it I discovered that my personal folder inbox has no folders. I also can no longer access the e-mail that I get