Update Syntax in VB

06-10-2002, 07:18 AM

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.

06-10-2002, 07:24 AM
UPDATE I_persons
SET I_persons.tel = S_persons.tel
FROM I_persons, S_persons
WHERE I_persons.name = S_persons.name AND I_persons.address = S_persons.address

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum