NexusDB Newsgroups

NexusDB Newsgroups (http://www.nexusdb.com/forums/index.php)
-   Binaries (http://www.nexusdb.com/forums/forumdisplay.php?f=24)
-   -   UPDATE error Mult Column and Blob Fields Tables and Samples (http://www.nexusdb.com/forums/showthread.php?t=20615)

Diniz 16th December 2018 11:08 PM

UPDATE error Mult Column and Blob Fields Tables and Samples
 
1 Attachment(s)
Hi Eivind

//UPDATE ERROR
SELECT REFERENCIA, DESCRICAO, UNIDADE, FOTO, INFORMACAO
INTO #Temp
FROM PRODUTOSB
WHERE CODIGO = 1;

UPDATE PRODUTOSA
SET REFERENCIA = (SELECT REFERENCIA FROM #Temp),
DESCRICAO = (SELECT DESCRICAO FROM #Temp),
UNIDADE = (SELECT UNIDADE FROM #Temp),
FOTO = (SELECT FOTO FROM #Temp),
INFORMACAO = (SELECT INFORMACAO FROM #Temp)
WHERE CODIGO = 1;



// INSERT (OK)
INSERT INTO PRODUTOSA SELECT * FROM PRODUTOSB WHERE CODIGO = 11;

thanks
Diniz

---
Este email foi escaneado pelo Avast antiv?rus.
https://www.avast.com/antivirus



All times are GMT +11. The time now is 01:34 AM.

Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.