Remote Update (error -4425)
People,
The statement below doesn't works:
----------------------------------------------------------
UPDATE database@server-name:table-name
SET database@server-name:table-name.* = tmp_table-name.*
| The variable "tmp_table-name" has not been defined
| LIKE the table "database@server-name:table-name".
| See error number -4425.
-----------------------------------------------------------
However, if I apply the same convention during INSERTion, it works:
----------------------------------------------------------------------
INSERT INTO database@server-name:table-name VALUES (tmp_table-name.*)
** no problem, it work fine.
-----------------------------------------------------------------------
Why doesn't the system allowed for such UPDATE when the tmp_table-name
have been defined accordingly.
Comment please.
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
_/_/_/_/ _/ _/ _/_/_/ Richard Wellis Sinyem
_/ _/ _/ _/ _/ Company: Malitnet Consultancy Sdn Bhd
_/ _/ _/ _/ _/ Tel: 082-415785 Fax: 082-428264
_/ _/ _/ _/ _/
_/_/_/_/ _/ _/ _/_/_/ E-Mail: sinyem@pc.jaring.my (home)
_/ _/ _/ _/ _/ URL : http://www.malitnet.net.my
_/ _/ _/ _/ _/ _/
_/ _/ _/ _/ _/ _/
_/ _/ _/_/_/_/_/ _/_/_/
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=