Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 166
  • Last Modified:

Playing with databases...

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
majala
Asked:
majala
1 Solution
 
dirtdartCommented:
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now