Compare Database -
Not sure if this is the right place, but I'm pretty stuck. I have 2 pretty large list ... like 1 million plus records & 10 Million plus.
One of them has a bit older data but I want to compare it to the new one and confirm the data.
The new one contains the 10 Million records.
Would importing into a both into a DB and using a VB compare string take forever?
Is there an efficient way?
Need some help or information regarding this issue. -
hi everyone.
Currently trying to create a program that compare two database. What i wanted to ask is how to compare two same database from difference location. Example. Database A is at HQ and Database B is at Branch 1. When ever Branch 1 updated its Database (B), HQ's Database A wi
can I compare each table in two databases -
hello,
I have 2 databases, DB1 and DB2, and each database have some tables, one of database have same table's name with the other database.
I like to compare entry in each table. as example, all entry in table-1 in DB-1 will compare to table-1 in DB2, and so on.
table-1 in DB1 h
Compare MDB -
I want to compare two Access 2000 database files. And find out what records have been changed.
Is there a program to compare two files?
DataTable Comparision -
Hello All,
I am working in C#.NET 2.0
I need to Compare two databases, in which one is of Oracle Database and another is of SQL Server 2000 database. I want to delete records from SQL Serever which are not in Oracle database.
I created two datatables - SQLdt and ORAdt,I did upto
Compare Records -
I have to tables with similar fields in different database , I need to compare the contents of them , How could I do it using ADODB.Record facility.
With Regards
Delete record from database **Resolved** -
VB6 SP5, Access2000 .mdb, Jet.
I have two databases, both contain Customer Data (different). What I would like to do is compare Customer in Database 1 to Customers in Database 2.
If the Customer 1 does NOT exist in Database 2, then I would like to delete Customer 1 from Database
Database compare -
Is there any easy way to compare two databases?
help with DateTime.Compare -
hi! can anybody please help me. Why is it when i try to compare two the same dates I was not getting the right return value of Datetime.Compare which 0. I dont know if the problem is in my code or is in the Datetime.Compare method. by the way, i attched a screenshot to give you more id
Option Compare Database - make it stop! -
Whenever I make a new Form/Module,
Access 2000 inserts Option Compare Database.
Does anyone know how to turn this feature off?
Help! Compare Two Values on Two Tables and Get Unmatched Value -
I want to compare two tables
[tblCrewOnBoard] --- [ID Number]
[tblServiceRecord] --- [ID Number]
I want to compare the [ID Number] from both tables and get the [ID Number] that does not present in [tblService Record].
Im using vb6 ADO ODBC... using MSAccess Database
Any
Tool development to compare tables in Oracle database -
Hii everyone,
I am naresh from banglore,i am planning to develop a tool to compare the datatypes of each column from two tables that are in Oracle database.I am planning to use VB scripting to do this.
Please help me out on this,how to access oracle database Using VB,how to get the
how can i compare the value in database -
how can i compare the the add value in availabe in database.
compare value in vb.net -
I have some problem as below:
Suppose i have select some value in listbox and hit a button. I compare
the value in list box with the value present in database.
Now based on this comparison, i want to display warning message box
Suggestions are welcome.
Option Compare -
Can anyone give me some insight as to the benefit of using option compare.. i pretty much know what it does.. and that it is compare binary by default... but when should you use option compare text instead?
compare last row data from sql database table with textbox -
hi,please help.how to compare compare last row data from sql database table?
current i want to compare the last row data from the database table with the textbox value.
from the sql database table have ID fields.
for example:
txtavg.text is the current textbox.
avg field is from
Fast Compare -
Dear All,
I have two Richtext box in Form . I have typed some word in Each boxex.These Text boxes has arround 100 - to 150 lines each.
I want to Fast Binary compare method, which will highlight the First Mismatch with some colour in Each Text box.These Compare sh
How to compare many values... -
I have to compare many values included in database...
The values I have to compare is "Cities"
I have to know "What is the pourcentage of job I shipped to each city ?"
Thanks in advance !
easiest way to compare 2 lists -
what is the syntax for using the compare in vb... ie compare filelist1 to filelist2 and see what files one directory has that the other doesnt
Compare Database -
Not sure if this is the right place, but I'm pretty stuck. I have 2 pretty large list ... like 1 million plus records & 10 Million plus.
One of them has a bit older data but I want to compare it to the new one and confirm the data.
The new one contains the 10 Million recor
compare values -
How do I compare values in the textbox with the record in database (Access) and return my the results in mshflexgrid?
[2005] Remove composite key (SQL JET) -
I'm busy writing a program where a user selects two Access databases (a source and a compare) and then the compare database gets altered to look like the source database, but still keeps its data, Everything works, except for composite keys, I can't seem to get them removed ... Does an
Compare input and list of CmbBox -
I would like to compare only the input section of the combobox with the field in the database to check for duplications
if cbobox.????? = rs ("data") then
msgbox " You Have a Duplication"
else: Resume
end if
If i use text in the ????? section, it compares t
Compare dates from db to current date -
I have a problem. I retrieve some dates from a database in the format dd/mm/yyyy. These dates are stored in the database.
what i want is to compare the date that i retrieved, to the current one, calculating the days between the two dates. afterward i want to place this in a column i
Compare Two Word Files -
Hi All,
I want to develop a VB6 application to compare two word files.
I want to include option to
- compare the content only.
- compare the content and Formating also.
I want you all to suggest me the best way to do it.
Thanks in Advance.
compare label with database -
hi guys,
1st of all, i tried google to solve my problem but i couldnt find any.
i am facing problem which is i do not know how to read the data from database ... what i want to build is something like this:
i want to compare the value in database with a label. i am totally bl
Compare two databases in vb -
I have two database. One database holds a list of all the employees. The second database holds a list of data from a survey which tracks who entered the survey. What I want to do is have vb look at the first database to get a list of all the employees. Then compare it to the second dat
[resolved]case-insensitive string compare -
Quickie - just looking for an existing function to compare example and eXamLe which will return true, without having to overload string.compare functions.
Compare word Documents -
Hello,
Is it possible to compare two word files without using MS Word's inbuilt Compare & merge option?
May be in VB way???
Could you please help me out on this.
Thanks,
Kanna.
how to compare data in vb.net -
friends,i have small query
i have one program which requres ,first of all i want to get data from database server and compare with data getting from data which is locare at sharepoint service,so plz write a code for this
Find the largets value -
I have an access database table that contains a list employment types as columns and zone codes as the rows. i want to right a script that goes along each employment type for the first zone code and look at the first value and compare it to the second to find the largest one. If that i
How to compare Date -
Hello
i want to compare Current Date with the field (entry_date) in My Access Database DB.
How can i do. plz plz help me.
i open recordset and write select statement with where clause . What comparison criteria in where clause will search records in rs. Tell me. plz.
Security Login -
I am relatively new to programming and could use some direction from someone more experienced.
What I am trying to do is create a login routine for a VB.Net app I have created. I need to promp the user to enter a username and password, then compare their password with the password
How to compare multiple (part) strings -
Hi,
I have 2 listboxes and want to compare both and count in how many lines are identical strings. BUT .... I want to use part of the strings (same as with MID) and this part strings chance always.
For example: I want to compare at the begin the characters 1-5 then 2-6 then 3-7 a
compare date in VB -
I have data field in database as "date"
I would like to query, say 1 week or 1 month, and get the result in to recordset.
How do I compare date? and know it's how many days from now?
[2005] Compare Mysql Tables -
Hi,
I'd just like to start off by saying im pretty much a newb with VB. I'm usualy working with PHP but i've been asked by my boss to do this (through my obvious objections) so im hoping someone can help.
I've been asked to basicaly make a program to compare a table of our datab
better way to compare dates -
hi guys! can anybody please help me...i have the code below which compare two dates,datenow and the alarmdate, and show the alarm notification when they are equal but as you can notice the way of comparing dates is first Convert both dates ToShortDateString and compare it and when they
comparing datas from two access database -
Hi!
i'm new to this sitution i don't have any idea how to compare data from two database... the fields of the database are very much the same..
can anybody give me example or code that handle the same situation as i have.. please? i really need it and need to know it..? please h
oracle - compare date -
hi, help needed!
i'm doing a vb.net project!
i use MS Access as my database at the beginning.
so i use:-
CDate(valid_date) < # " & DateTime.Now.ToString("dd/MM/yyyy") & "#
to get some record that the valid_date is < than today date!
it work wel
Problem with Date Range -
I'm bringing back dates from a database and want to compare those dates to see if they're between a range defined by two dtPickers. I've tried using >= and <= but it doesn't seem to work for dates. I was testing to see if the dates were equal and that worked fine, although it may
Listview compare -
im trying to compare two values that i will get from a database to those that will be stored in a listview.
Lets say the two values will be 2, 5 (this will be retrieved from the database (table a)). and the values in the database is 2, 6, 4, and 5 (from table b). any ideas how i can