Tip Bank

Question: I am a technical copywriter currently writing a fact sheet for a software company providing DB2 SQL support. They have something they want to call “limited dynamic SQL.” Here’s

Question: I was out on the Fox newsgroup and somebody posted some ADO code in Visual FoxPro that alarmed me. VFP seems to have a major problem repeatedly accessing the

Question: How do I correct a spelling error in a table? I am at a loss as to where to start. Answer: Hoping for the best, I’d say that what

Question: I am trying to import data from a .CSV file and verify that the rec importing does not exist on the destination database (SQL7 DB), then either insert or

Question: I have a table in FoxPro 3.0 that I need to export to FoxPro 2.6 to give to someone outside my company. However, when I export, the memo fields

Question: How can I configure Exchange Server for simple automatic replies when e-mails are sent to a specific account? Answer: The easiest way to do this is to log in

Question: My Exchange server has two partitions (C and D). There is a file (TEMPDFRAG.EBD) that is on the C drive and is taking up a lot of space. Is

Question: How difficult is it to convert a Sybase Transact-SQL database to SQL/400, and where can I find information on SQL/400? Answer: I don’t know but, in the main, learning

Question: How do I compare two tables and extract only where field1 doesn’t match field2? Will MINUS do it? Answer: Yes, but it’s not that direct. To do MINUS (or