devxlogo

December 14, 1999

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

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,

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

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

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