Hi!

I would like to update an Ingres Table (I_persons) connected using an ODBC driver from an SQL Server table (S_persons) using an OLEDB driver.

Lets say: I_person Table has the ff: columns namely name,address, tel. while S_persons has also the same.

Pseudocode: Update I_persons table from S_persons where I_persons.name=S_persons and I_persons.address = S_persons.address set I_persons.tel = S_persons.tel

Can somebody translate this psuedocode into a correct VB syntax?

Thanks in advanced.