Hi all.

Can I do an update between tables of different databases?

Something like this:

I have two databases: EMPRESA_01 and EMPRESA_99 and I want to update a field of the table
CLIENTES

UPDATE EMPRESA_99
SET EMPRESA_99.CLIENTES.NOMBRE=SELECT NOMBRE FROM EMPRESA_01.CLIENTES WHERE
EMPRESA_01.CLIENTES.NOMBRE=EMPRESA_99.CLIENTES.NOMBRE

(this of course does not work)

Thank you

Francisco


Are they using different sessions?

Roy Lambert [Team Elevate]

Roy.

No, I'm trying in edbmgr in the same session.

Francisco


I know you can update from one database to another because I do it. Staring at it for ages I finally realised your problem is

UPDATE EMPRESA_99

All you've given is the database name not the table name. Try

UPDATE EMPRESA_99.CLIENTES

Roy Lambert [Team Elevate]

Roy.

I put this instruction

UPDATE EMPRESA_99.CLIENTES
SET NOMBRE=SELECT NOMBRE FROM EMPRESA_01.CLIENTES.NOMBRE WHERE
CODIGO=EMPRESA_01.CLIENTES.CODIGO

but does not work

Do you have any example?

Thanks

Francisco


UPDATE Companies  SET Companies._Website = (SELECT _Website FROM LIVE.Companies WHERE _ID = 1000001) WHERE _ID = 1000001

Roy Lambert

Roy

   
UPDATE CLIENTES
SET CLIENTES.NOMBRE = (SELECT NOMBRE FROM EMPRESA_01.CLIENTES WHERE CODIGO = '1')

this works but I need to relate the two tables by the field code

something like ....

UPDATE CLIENTES
SET CLIENTES.NOMBRE = (SELECT NOMBRE FROM EMPRESA_01.CLIENTES WHERE CODIGO =
EMPRESA_01.CLIENTES.CODIGO)

Is this possible?

Thanks

Francisco


If you've tried it and it doesn't work what error do you get.

Roy Lambert [Team Elevate]

Roy

UPDATE EMPRESA_99.CLIENTES
SET NOMBRE = SELECT NOMBRE FROM EMPRESA_01.CLIENTES WHERE CODIGO =EMPRESA_01.CLIENTES.CODIGO

-->

ElevateDB Error #700 An error was found in the statement at line 2 and column 86 (Expected
end of expression but instead found .)

Thanks

Francisco


If the tables aren't to big post them to the binaries along with a description of what you're trying to do and I'll see if I can come up with a solution for you.

Roy