I had made a Microsoft Office Access 2007 database with more than 2000 records. A copy of which was given to my friend. We both made a number of amendments and added new records in our respective copies. Now I want to compare both databases & merge the databases into one. There is only one table in the database, so basically both the tables need to be merged with the amendments made by both of us. How do I do it?

Member Avatar
Member Avatar
+0 forum 3

Hello Daniweb Community, I've been looking around online for help with this but I can't seem to find a way to get a query to do what I want. The image below should pretty much say what kind of result I'd like to get, it's pretty much merging the tables weather or not the second table has a row with the same ID and if it doesn't then just return NULL. ![Capture.PNG](/attachments/large/3/482460ec5c7e9191e454995d816694a0.PNG "align-center") Thanks

Member Avatar
Member Avatar
+0 forum 4

Hi all, I am trying to compare output from DB The code below works on 1 check, but I require to do this on multiple products like so `if rowProduct("GRPCODE") <> "Cross Hire" or rowProduct("GRPCODE") <> "Boiler Ancillaries" then` etc but the above line does not work as I have coded it? What is the problem with the code. Thanks in advance if rowProduct("GRPCODE") <> "Cross Hire" then ' Elimination unwanted code if not rowStock.eof then ' stock found do while not rowStock.eof ' loop through stocl if instr(RemoveItems, "," & rowStock("ITEMNO") & ",") = 0 then ' item not …

Member Avatar
Member Avatar
+0 forum 1

Hi Guys, Im currently working with application, where it will automatically inform the user that there is an overdue account today. i decided to compare the current date(today) to stored date in mysql database, heres my code: Public Sub getReminder() Dim _con1 As New MySqlConnection Dim _cmd1 As New MySqlCommand Dim dr As MySqlDataReader Dim date1 As String With _con1 .ConnectionString = "server=xxx.xxx.x.x;uid=xxx;pwd=xxx;database=daspatch" If _con1.State = ConnectionState.Closed Then _con1.Open() End If End With 'date1 = Convert.ToDateTime(Today) _cmd1 = New MySqlCommand("SELECT date_due FROM billing_tbl", _con1) date1 = Date.Today dr = _cmd1.ExecuteReader() If dr.HasRows Then MsgBox("You have account already due") Else MsgBox("You …

Member Avatar
Member Avatar
+0 forum 5

Hi, I'm new to perl, and need help about comparing 2 columns within 2 different .tsv files. I have search through the forum for some similar case of mine, such as [url]http://www.daniweb.com/software-development/perl/threads/335711[/url], [url]http://www.daniweb.com/software-development/perl/threads/336421[/url] and [url]http://www.daniweb.com/software-development/perl/threads/311399[/url] , I have tried to modified them according to my needs but somehow the final output is not right, so I decided to make a new thread. I have 2 input tsv files, The first one is archive.tsv. It is a paper database with the format of [B]<Paper ID>[/B]\t[B]<Paper Title>[/B]\t[B]<Author>[/B]\t[B]<url>[/B] [ICODE]P08-1016 Lexicalized Phonotactic Word Segmentation Margaret M. Fleck [url]http://aclweb.org/anthology-new/P/P08/P08-1016.pdf[/url] P08-1021 Correcting Misuse of Verb Forms …

Member Avatar
Member Avatar
+1 forum 7

void password(){ string fpass; string pass; cout << "Type the password " << endl; getline(cin,pass); cin.ignore(); ifstream fin(FILENAME1); string str; getline(fin, str); fpass = str; cin.ignore(); if (pass.compare(fpass) == 0){ cout << " Hello!" << endl << endl; cout << "What do you want to do?" << endl; }else{ cout << "\n\n INCORRECT! \n \n \n"; cin.ignore(); char choice; cout << "Try again? y/n --> "; cin >> choice; if (choice == 'y'){ password(); } } } What's the problem with this? It worked, but didn't do what I expected...

Member Avatar
Member Avatar
+0 forum 3

Hi, I need to compare record using sql ce I have this data, can be thousand rows ID Type Date Time 02-0009 I 01/02/2014 8:00 02-0009 O 01/02/2014 18:00 02-0009 O 01/03/2014 18:00 02-0009 I 01/04/2014 8:00 02-0009 O 01/04/2014 18:00 For every date there should be a 'I' and 'O' type If last Type for a date, for example 01/02/2014 is 'O', the Type for the next date should be 'I' and vice versa The situation in dates 01/02/2014 with type 'O' and 01/03/2014 with type 'O' is invalid The invalid record could be with type 'I' or 'O' …

Member Avatar
Member Avatar
+0 forum 12

dear friends m using strtotime () function to compare two dates , but it is not working for the date greater then '19-jan-2038'.my os is win 7 32 bit and php 5.2 and apache 2.2.plz if any body having any solution , kindly share it

Member Avatar
Member Avatar
+0 forum 6

I am writing a program where the user enters 2 strings and the program checsk to see if any characters are in both strings, and if they are, remove them from the first string and print it. So i have this at the moment, and it's almost working but it seems to be ignoring the first character of the second string. If you enter "computer" and "program", for example, it returns "cpute" instead of "cute". Anyone have any ideas? [CODE] #include <iostream> #include <string> using namespace std; int i; int j; string x; string y; int main() { cout << …

Member Avatar
Member Avatar
+0 forum 5

Input Files: ============ XML ==== <para>some Text</para> <para>some Text</para> <para>some Text</para> <para>some Text</para> <para>some Text</para> <para>some Text</para> Text File ========= some Text<insert>New Text</insert> some Text <delete>some</delete> Text some Text some Text some Text some Text OUTPUT: ======= <para>some TextNew Text</para> <para>some Text</para> <para> Text</para> <para>some Text</para> <para>some Text</para> <para>some Text</para> We have to compare xml file and text file and update the output in XML file.

Member Avatar
Member Avatar
+0 forum 1

i have much tried for this solution but not any well solution found.if any one know how can we compare two audio files by their voice and after comparing it give the result of matching voices.please if any one now the solution told me.

Member Avatar
Member Avatar
+0 forum 2

I need to search the content from one list (List A, Column A) for the mention of items from another list (List B, Column A), and if any matches are found, I need to publish in Column B of List A the data from Column B of the associated matching item of List B. Can anyone help? Tables below to help clarify what I'm asking. **List A **(The list being searched) Column A Column B (blank) The bucket e(5) was full The broom stood The call came d(4) **List B** (The reference list - e.g., "does list A contain any …

Member Avatar
Member Avatar
+0 forum 1

Im new to programming python3 and i'm trying to write a password program. i want to compare a word from a .txt file with a input. no matter if i type the password in write or wrong it always comes up 'access denied!' inFile = open('passwordtest.txt', 'r') password = inFile.read() userguess = input("Enter password: ") if password == userguess: print('Access Granted!') else: print('Access Denied!') input() Thank you in advanced!!

Member Avatar
Member Avatar
+0 forum 3

Hi Team, I am working on Collections and in order to Sort ArrayList of Objects of a Class based on their instance variable, it is mentioned in book that I need to OverRide CompareTo Method. compareTo Method works fine but Iam not getting the clear idea of its sorting logic. Below is an Example. public class smalldeer extends deer implements Comparable<smalldeer> { private String name; public smalldeer(String name) { // TODO Auto-generated constructor stub this.name=name; } public static void main(String[] args) { // TODO Auto-generated method stub ArrayList<smalldeer> s = new ArrayList<smalldeer>(); smalldeer obj = new smalldeer("Apple"); smalldeer obj2 = …

Member Avatar
Member Avatar
+0 forum 3

i want to comare textbox value with datagridview items before adding this textbox value in datagridview

Member Avatar
Member Avatar
+0 forum 5

Dim hTable As Hashtable = New Hashtable() Dim duplicateList As ArrayList = New ArrayList() Dim itm As ListViewItem For Each itm In ListView1.Items If hTable.ContainsKey(itm.Text) AndAlso hTable.ContainsKey(itm.SubItems(1).Text) AndAlso hTable.ContainsKey(itm.SubItems(2).Text) AndAlso hTable.ContainsKey(itm.SubItems(3).Text) Then 'duplicate duplicateList.Add(itm) Else hTable.Add(itm.Text, String.Empty) End If Next 'remove duplicates For Each itm In duplicateList ListView1.Items.Remove(itm) Next I want to compare 3 subitem in listview like this: Date____________Name_______________Value 11/12/13________llallala_______________12334 11/12/13________llallala_______________12334 11/12/13________ddsfvxcv_____________16542 13/12/12________ddsfvxcv_____________12334 10/12/13________owowewe_____________23024 then normally it will remove first and second row because it is duplicate but now it cannot.... I means it just compare between first column....so if the first column is same but second and third …

Member Avatar
Member Avatar
+0 forum 3

Dear, I'm trying write a simple C program that h two input files. Both are large files. First file has one column and second file has two columns. Just compare the first colums of both files and print the whole line of second file that matches first one. File2.txt 123456 ABCDE 234567 DEFER 563467 UIERT 349056 UIFRT File1.txt 234567 563467 The output file should be like this 234567 DEFER 563467 UIERT Could some one help me in finding logic.

Member Avatar
Member Avatar
+0 forum 4

Hello Experts, First of all I don't know if i am on the right track.If I am not please suggest your best,easy options :) What I am trying to do is the following. I have a web page which is included with textboxes I have also a database inside there is the following informations Devices Feature1 Feature2 Device1 10 15000 Device2 15 12000 Ok Feature1 input will be the TextBox1.Text Feature2 input will be the TextBox2.Text input For Example user will write 12 to the textbox1 and will click to "calculate" button Output will be transforming the label into Result …

Member Avatar
Member Avatar
+0 forum 3

Array1 = array(000,400,000,500) Array2 = array(300,400,450,500) if the values of Array1 matches with Array2 values then the matching values of Array2 should be replaced with 000 i.e. Array2 = array(300,000,450,000) somebody help me. thanks in advance

Member Avatar
Member Avatar
+0 forum 2

Hello friends, I have just joined this online community. I also started a new website about choosing the best car loan service provider. If you have some suggestion to promot my website then give me your suggestion.

Member Avatar
Member Avatar
+0 forum 1

Hi. I'm creating a short-answer quiz. The questions has one text area each for answer. However, for each question there are several answer suggestions in the database. I'd like to compare the value post by the text area with the suggestions. $answers = explode(" ", $ans[$arr_ind]); //$ans[$arr_ind] holds answers from form foreach ($answers as $answer) { $answer = trim($answer); if(stripos($atext[$arr_ind], $answer)!== false){ //$atext[$arr_ind] holds answer suggestions //correct $result = "<p align='justify'><img src='image/mark.png' border='0' width='20' height='20'></img><b> YOUR ANSWER: </b>". $ans[$arr_ind]. "</p>"; //$correct = 1; } else $result = "<p align='justify'><img src='image/cross.png' border='0' width='20' height='20'></img> <b>YOUR ANSWER: </b>". $ans[$arr_ind]. "</p>"; }//foreach echo …

Member Avatar
Member Avatar
+0 forum 2

Hi guys, i'm a little bit new to c# but someone asked me to make something for him, now was the question to make a Winform application, and you can insert 2 xml files, then read the xml files, and make a new xml file with the updated data out of the 2 xml files, so my question is if someone can help me a little bit out of this.

Member Avatar
Member Avatar
+0 forum 3

Hey guys! I'm selecting the parts for my new gaming desktop and I don't know too much about audio. I'm using the Gigabyte GA-Z77X-D3H ATX LGA1155 Motherboard and I don't know if I should buy a Asus Xonar DG 24-bit 96 KHz Sound Card. I tried looking at the audio specs of both but I don't understand too much about it. So is it worth it and what are the differences? Thanks

Member Avatar
Member Avatar
+0 forum 2

I have two text files containing multiple lines of text, I need to compare both files and write the missing lines in the file two. i will use a while loop for check every 60 seconds, i an idea but just work 1 pass File one: 2012-10-04 01:03:11,50EF87C3.req,192.168.1.1,12312312312,OK -- HUAWEI Mobile Connect - 3G Modem #6,Text="1" 2012-10-04 01:18:59,50EF8BAD.req,192.168.1.1,12312312312,OK -- HUAWEI Mobile Connect - 3G Modem #6,Text="2" 2012-10-04 01:20:46,50EF8BAE.req,192.168.1.1,12312312312,OK -- HUAWEI Mobile Connect - 3G Modem #6,Text="3" 2012-10-04 01:21:33,50EF8BAF.req,192.168.1.1,12312312312,OK -- HUAWEI Mobile Connect - 3G Modem #6,Text="4" 2012-10-04 01:39:06,50EF8BB0.req,192.168.1.1,12312312312,OK -- HUAWEI Mobile Connect - 3G Modem #6,Text="5" File two: 2012-10-04 01:03:11,50EF87C3.req,192.168.1.1,12312312312,OK …

Member Avatar
Member Avatar
+0 forum 3

I have this code: $status_kol=trim($v->Status); $mojakolicina = "Raspoloživo"; if($status_kol=="Raspoloživo"){ $status_dobavljivosti=2; } else { $status_dobavljivosti=0; } echo "OVO JE ZA dostupnost : $status_dobavljivosti <br/>\n"; But i alway get 0 And I get 3 when status_kol is not "Raspoloživo"? Can you help me with this? Thans

Member Avatar
Member Avatar
+0 forum 5

hello, i have made the code below. however, when comparing the two strings they are not equal when in theory i thought they would be. String word="abc"; String d=""; d += "a"; d += "b"; d+= "c"; if(word==d) { System.out.println("IS EQUAL"); } When i just print out string d it prints out abc, but for some reason its not REALLY abc. why?

Member Avatar
Member Avatar
+0 forum 2

string word = "abcde"; int count = 0; for(int i = 0; i < word.length(); i++){ for(int j = 1; j < word.length(); j++){ if(word.at(i) == word.at(j)){ count++; } } } i am trying to write a program that when i am given a string i can count letter pairs in the string so for example: cat returns 0 and doggy returns 1. this i what i have written now and i tried cout the loops and such but im still very lost in what i am doing wrong. any help would be very helpful

Member Avatar
Member Avatar
+0 forum 1

Hi Everyone, Im' new in C. I was tasked to do a word game. Its a Guess a word game. The user inputs the letter through arrow keys. Then, my program supposed to check if each letter is correct. Then, display it in boxes. The problem is I cannot validate the letter chosen when it's duplicate. I used the strstr command in searching the letter. Below is the snippet, please help: substr=strstr(temp,temp1); if (substr != NULL) { if (prevchc != choices[pos1]) { rightlet=rightlet+1; gotoxy(1+rightlet,18); printf(choices[pos1]); prevchc=choices[pos1]; } //else // { // gotoxy(20,20); // printf("You already guessed the letter"); } if …

Member Avatar
Member Avatar
+0 forum 3

#!/usr/bin/perl -w use Win32::OLE qw(in with); use Win32::OLE::Const 'Microsoft Excel'; $Win32::OLE::Warn = 3; # die on errors... # get already active Excel application or open new my $Excel = Win32::OLE->GetActiveObject('Excel.Application') || Win32::OLE->new('Excel.Application', 'Quit'); # get a new workbook $book = $ex->Workbooks->Open('C:\Users\Andrew Babitt\Documents\ProductClonesTest.xls'); $Obook = $ex->Workbooks->Open('C:\Users\Andrew Babitt\Documents\NSS\extract_Products.xls'); my $billschedule = $Obook->clumn(B)->{value}; my $totalamount = $book->clumn(D)->{value}; my $opnum = $book->clumn(E)->{value}; my @array = (\$billschedule, \$totalamount, \$opnum); my $var = 0; while ($book->Range(0,0)->{value} ne '') { if (@array[0][$var] = $book->Range(0,9)->{value}) { if (@array[1][$var] = $book->Range(0,10)->{value}) { write(@array[2][$var], $book->Range(0,11)->{value}); } } else $var = $var+1; }

Member Avatar
Member Avatar
+0 forum 2

Hello, i have encountered with a problem in one of methods comparing string from database to the string named pword that i initialized from textbox. Can anyone know the easiest for begginer to fix it? I would be very very greatful. SqlConnection myConnection = new SqlConnection(); myConnection.ConnectionString = "Data Source=.\\SQLEXPRESS;AttachDbFilename=D:\\Studijos\\c#\\KursinisDarbas\\BazineAplikacija\\BazineAplikacija\\DuomenuBaze.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"; DataSet myDataSet = new DataSet(); string sql = "SELECT *From tblWorkers"; SqlDataAdapter myAdapter = new SqlDataAdapter(sql, myConnection); myAdapter.Fill(myDataSet, "Workers"); myConnection.Open(); int MaxRows = myDataSet.Tables["Workers"].Rows.Count; bool permition = false; for (int i = 0; i < MaxRows; i++) { DataRow myRow = myDataSet.Tables["Workers"].Rows[i]; MessageBox.Show(myRow.ItemArray.GetValue(4).ToString()); if (Convert.ToInt32(myRow.ItemArray.GetValue(0).ToString()) == ID) …

Member Avatar
Member Avatar
+0 forum 3

The End.