devxlogo

Tip Bank

Restoring Tables

Question: Does SQL 7.0 allow you to restore a table from a database dump much the way SQL 6.5 did? Answer: No, not exactly. The only way you can restore

Comparing Columns from Different Tables

Question: I have a problem comparing columns from different tables. I tried: SELECT tblThumBereinigt.Nummer, dbo_BABEWERTUNG.BANUMMERFROM dbo_BABEWERTUNG, tblThumBereinigtWHERE (((dbo_BABEWERTUNG.BANUMMER)[tblThumBereinigt].[Nummer])); but this does not give me what I want. How can I

Using DTS

Question: Is it possible to create a DTS package that does an Update rather than a Select statement? Also, when I save a DTS package in a file (*.dts as

Limited Dynamic SQL

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

Problems with ADO

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

DTS & Data Driven Query Task

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