>lol...my native language is english... :D
>
>
>ok what i want is to basically....
>when i click a button i run a check on a table if the data is already there i get notified, if its not...its add it to the table
Just do a simple insert command, e.g.
** This will insert only new records
insert into myTable select * from myOtherTable T LEFT JOIN myTable My on T.Name = my.Name where myName IS NULL
** This will give you all already existing records
select My.* from myTable my INNER JOIN myOtherTable T on My.Name = T.Name
If it's not broken, fix it until it is.
My Blog