Solved

Playing with databases...

Posted on 1998-06-30
1
157 Views
Last Modified: 2010-05-03
Is there any way to add one database (dBaseIV) to another so that there isn't any dublicates in data?
Here's example:
I've got one database where is datas from 1/1/1998 to 15/6/1998 and another where is datas from 1/6/1998 to 30/6/1998. I wanna kind of update this first database so that there is all datas from 1/1/1998 to 30/6/1998.

Could there be any SQL-clause to do this? If there is could you give me example?

Thanks for advance.
0
Comment
Question by:majala
1 Comment
 
LVL 5

Accepted Solution

by:
dirtdart earned 50 total points
ID: 1464589
When I've had to do this, I've used the following method:

Dim srcRs As Recordset
Dim destRs As Recordset
Dim SQL As String

SQL = "SELECT * FROM MyTable WHERE MyField = '" & srcRs("MyField") & "'"

set destRs = db.OpenRecordset(SQL)
destRs.MoveLast
destRs.MoveFirst
If destRs.Recordcount <> 0
    'Move record from one table to the other because it doesn't exist
End If
destRs.Close

0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Use Multiple Forms 4 49
MS Date Picker 64 bit 32 bit issue 12 49
HOW D I CLEAR PICTURES IN IMAGE CONTROL AND COMMENTS IN CELLS WHEN WORKBOOK IS OPENED 18 85
TT Auto Dashboard 13 85
The debugging module of the VB 6 IDE can be accessed by way of the Debug menu item. That menu item can normally be found in the IDE's main menu line as shown in this picture.   There is also a companion Debug Toolbar that looks like the followin…
Article by: Martin
Here are a few simple, working, games that you can use as-is or as the basis for your own games. Tic-Tac-Toe This is one of the simplest of all games.   The game allows for a choice of who goes first and keeps track of the number of wins for…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now